Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Nov 12, 2012 02:58 AM by nitin.b.kumar
Nov 02, 2012 03:38 AM|LINK
I am trying to insert the report parameter to the name of the export file name which is generated by the subscription in SSRS Report Manager 2008.
The default value of the report input parameter is obtained by a query and the data changes from month to month to generate different reports. Right now I have to go about changing the file name every time a new default parameter is created for the report.
I checked all the forums but I do not see a way I could do that in SQL 2008 or even in the newer version. Please correct me if I am wrong.
I m now looking at creating a console based app which take value as command line and then execute the report in a C#.net tool which I plan to schedule using the windows task manager. However, I would want to make sure that there is no other way of doing
this without the external tool or code.
I am also looking at running the report from an SSIS package if that would help as explained in you post.
Your view and thoughts in this matter is highly appreciated.
Nov 12, 2012 02:58 AM|LINK
I wrote a console app to do the job and then schedule it with windows task manager.
Not using the SSRS report manager to schedule the report anymore.