October 13, 2014 at 11:40 am
I need some advice on a solution. Lets say for example I have a table named Drier_Lot_Recipients with columns
grower_id int, crop_year int, and email_address varchar(100). This table contains users that would like to receive
an SSRS report I created on daily basis.
I created the SSRS report and it is deployed on a reporting services server. The name of the report is Drier_Lot_Report.rdl.
I am not sure what would be the best way to go about this. Should I do it all in SSIS or a stored procedure in SQL Server?
OR maybe a combination of both.
Do I need to have calls made to the RS.EXE utility? Do I need to setup database mail in SQL Server?
We have two SMTP servers.
So the end solution must call the Drier_Lot_Report and pass in two parameters (Grower_id and Crop_Year). The output
must be PDF and either have the grower_id included in the output filename OR generic filename
in a newly created folder with a name of Grower_id. Ideas please?
thank you
October 13, 2014 at 1:29 pm
Well I was hoping for a quick response but that didn't happen so I decided on a solution.
I am going to go the SSRS Subscription route. I saw a video on how to take a list of users
from SQL Server and import them as separate subscriptions. There will probably be less then 100
users that need this and the video showed the loading of over 500 subscriptions to a report.
After I get this initial set of users setup, I need to develop a front end to maintain these subscriptions
so that I user can login to a website and cancel their report subscription or start a new one
if they are not signed up for it. Hopefully that is possible or I will have to manually maintain myself
and I really don't want to.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply