views:

33

answers:

1

Hello,

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 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!

+1  A: 

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.

Fillet
Fillet - Your suggestion work great! Thanks for the idea and guidance.
Loki70
Take a look at the following links about passing parameters via the URL: http://msdn.microsoft.com/en-us/library/ms152835.aspx and http://www.mssqltips.com/tip.asp?tip=1336 once you know how the URL's for SSRS work, you can send personalized emails to different people with their own URL and Parameter settings.
D.S.