September 26, 2011 at 8:41 pm
Hello,
We have many SSRS reports integrated in asp.net application. The users run the reports from the interface. The user interface has many parameters and report name in drop down boxes. When the users select the report name and related parameters and click the botton (run report), then the 'report_parameter'n table is updated and runs the report using the parameters from the table.
Now, the manager wants to schedule to run each report with different parameters on weekly basis and save to the shared folders. Is there a way to accomplish this task? I used ssis script task to run the report dynamically in the past but I also need to update the report parameter table before the report is actually run, in this case. How can I do this task using SSIS or SSRS or asp.net codes?
Please suggest me.
Thanks and Regards
Ganesh
October 3, 2011 at 7:46 am
If you have the enterprise version you should be able to do a data driven subscription.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply