How to display full URL when setting report parameters
I have a report (in SQL Server Reporting Services 2008) that has multiple parameters, but works very well. However, one of my users (my boss, of course) wants to be able to e-mail a link to the report using the parameters they have specified. They do not want to send the report itself, but just a link to it. However, as you set parameter values and click "View Report", the URL shown in the browser does not contain the parameter values in the querystring (just the default report path), and therefore is not really usable.
I know that this functionality is possible, because if I add a subscription to the report, and开发者_Go百科 check the "include link" checkbox, I get an e-mail with a link like this:
http://servername/ReportServer/Pages/ReportViewer.aspx?%2fRoot+Action+Analysis&ShowChart=2&sPN=&iDept=All&rs%3aParameterLanguage=en-US
Is there a server setting that could be changed to show the FULL URL (with parameters) as users generate new reports? Thank in advance!
I don't know how to change the settings so that the full URL is shown.
As a workaround you could add a textbox to the bottom of your report, and build the URL yourself in an expression by concatenating Globals!ReportServerURL, Globals!ReportFolder, Globals!ReportName, Globals!Language and your various Parameters.
精彩评论