Can I program subscriptions into report | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Can I program subscriptions into report

I have 17 reports that I converted from Crystal using VS 2005. The reports work fine and now I am getting to the delivery phase. Each of the 17 reports call on one parameter (Publication_Code). There are 27 of these pub codes to choose from though. I can setup each report with a seperate subscription for each pub code, 17(reports)*27(pubs) = 459 seperate subscriptions. YIKES!!! What would be the best way to go about this? 1.Create 459 seperate subscriptions? (Least desirable option in case of schedule changes which might happen frequently)
2.Create a Data-Driven Subscription for each report? (Although this option doesn’t seem like it would support what I’m trying to do, I thought I’d put it in here to see if anyone can confirm it)
3.Somehow build a loop directly into the report to use all the publication_codes and create an output file for each? The third option, if possible, would work best for us.
Moved to SSRS topic section… MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

OK, I’ve got the data-driven subscription done for 1 of the reports.
I have it setup as a file share delivery. All of the reports will be delivered to the same path so here’s my latest dilemma:
How can I set the filename to be distinctive?
EX. I have a report called BBSC036A which uses a paramter called PUB_CDE, which contains 27 rows: ACC, JC, JD, JE, JG etc…
I would like the data-driven subscription to have the output file have both the report name (BBSC036A) and the PUB_CDE. IE: ACC_BBSC036A, JC_BBSC036A, JD_BBSC036A etc…
Is this possible?
]]>