October 31, 2012 at 4:31 am
Hi,
I have a report in SSRS report server URL, it takes location as a parameter from the query dynamically has a input to the report.
when I click the report, it has the drop down list where I need to select location, and then i can view the report.
Now, I need to subscribe this report, and i want this report on the windows share folder for all the location, i need these reports on a particular time and it should automatically take parameter from the drop down list, and generate the report saved in the windows share folder.
Please suggest/help me in this.
Thanks in advance..
October 31, 2012 at 10:39 am
If you use the enterprise version you can make a data driven subscription and build your parameter query there. However, if you need multiple values for a single parameter the task becomes more difficult because that functionality is built into the product. The easiest way I have found is to use a stored procedure and build the multi value parameter query into the stored procedure using an input parameter to control whether or not that section of the SP is run.
October 31, 2012 at 12:33 pm
Thanks Daniel..!
I am using enterprise edition only.. One more help.. is there a any way that the part of the report name is Dynamically generated by a query and get append to the existing report name.
For example -
Report name - Loc-XYZ.xls
where the "Loc" should dynamically get generated from a query,and also this "Loc" is passed as a parameter to this report.
October 31, 2012 at 2:33 pm
Well, that all depends on what you mean by report name. If you mean the actual name, it is possible but it is very difficult and involves doing some things that if done wrong can really mess up your report catalog and it is not supported by Microsoft. If you are talking about the report title that the user sees at the top of the report, simply make an expression in the title box something like ="Title here " & Parameters!ParameterName.Value
November 1, 2012 at 1:28 am
I am talking about the actual name can you please tell me how to do that.
i need location name appended to my actual report name, and this location field is getting from the query dynamically.
Thanks..
November 1, 2012 at 2:36 pm
I haven't actually tried this but i think it should work for any version of sql server that includes reporting services. if the location is the default parameter on the file-share subscription, you could create a dot net application that could a. for each report in the folder that the report was delivered to, query the subscriptions table to grab the default location parameter (XYZ), store it (XYZ) in a string variable (strloc), then rename the report , inserting the location (strloc) before the file extension (Loc-strloc.xls).
November 2, 2012 at 7:20 am
rahulpatange (11/1/2012)
I am talking about the actual name can you please tell me how to do that.i need location name appended to my actual report name, and this location field is getting from the query dynamically.
Thanks..
It involves going to the catalog table in the reporting services database and changing the name of the report and running the report and then going back to the catalog and changing the name to the next name you need. I believe I saw more detailed instructions right here on SSC in the forums, maybe an article or blog. I must warn you though, you do this at your own risk. The impact of modifying the catalog table incorrectly can impact your report server. You would probably be better off just making a different version of the report for each location.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply