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.
nitin.b.kuma...
None
0 Points
9 Posts
Add report parameter to the export file name under report subscription in Report Manager
Nov 02, 2012 03:38 AM|LINK
Hi,
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.
nitin.b.kuma...
None
0 Points
9 Posts
Re: Add report parameter to the export file name under report subscription in Report Manager
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.