jeudi 12 avril 2012 22:09
Hi, The client I work for wants to create one single document by looping through the LocationId parameter for a selected Date. This report takes 2 parameters CurrentDate and LocationId. This is a monthly report that needs to be mailed to these different locations each month.Is there a way to programatically loop through these 250 odd locations to generate a word or pdf document and save them to disk.
How technically feasible is it doing in SSRS?
Thanks in advance............
Toutes les réponses
jeudi 12 avril 2012 23:52The best way I would suggest you to do in SSIS script task and schedule the script task package in SQL Agent in SQL Management Studio.
vendredi 13 avril 2012 00:11
Hi Jeevan, Thanks for your response. This idea seems interesting, Is there a way to call Report.rdl files ?
vendredi 13 avril 2012 00:28
Yep you can call your SSRS report and pass the parameters and run the report and you can save that report in a particular folder and you can attach that to a email.
please find the link below
I think this will help you.
- Marqué comme réponse ione721 vendredi 13 avril 2012 21:14
vendredi 13 avril 2012 21:14
Hi Jeevan, Thanks for guiding me I have been able to accomplish it with your idea.