loop through a report parameter to generate an SSRS report

Question

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............

Answer 1

The 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.

---

Dasari

Answer 2

Hi Jeevan, Thanks for your response. This idea seems interesting, Is there a way to call Report.rdl files ?

Regards......

Answer 3

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

http://technet.microsoft.com/en-us/library/reportservice2005.reportingservice2005.createsubscription.aspx

I think this will help you.

---

Dasari

Answer 4

Hi Jeevan, Thanks for guiding me I have been able to accomplish it with your idea.

Regards...........