Reporting Server - Passing Parameters programtically

We've developed several reports where you can type in / select variables and run them, affecting their outcomes.

We'd like to change this so if the user clicks on a link from our Intranet, this takes them straight to the report with the appropriate parameter(s) - rather like the "jump to report" function within a report - i.e. the url for that function...

Is this possible?

Steve

Yes, it is. You should check in the docs for topics mentioning "URL Access", but the basic deal is this:

I usually start this by drilling down to the appropriate URL for the report (sans parameters) using ReportServer rather than Reports (Report Manager) interface.

Once you have the appropriate base URL, you can add the appropriate instructions to the URL's query string.

You start with the ones that tell the server to render the report, in the appropriate format, for example:

&rs:Command=Render&rs:format=EXCEL

... and then you can add your params to this as more name-value pairs in normal querystring style, for example:

&myParam1=53&myKeyValue=SomeToken&myID=965

... okay?

By "start with" and "then", I don't mean that the order of the params and report instructions in the query string is significant, just that I generally think it through in this order, report-owned instructions and then parameters. If you are going to build the URL dynamically at runtime it helps to think about the two groups separately <s>.

>L<

|||

superb! i think the note to add to this is to use the "report server" site not the "reports" site i.e. http://servername/reportserver rather than http://servername/reports

thanks

|||

Yup, that's the way they do it in the docs, and that's the way I've been doing it... one site is the "real" server and the other is just the pretty interactive interface....

>L<

|||Thank you for this information. It works perfectly! You saved me a bunch of time!