Pass a variable to the report via a URL

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Pass a variable to the report via a URL

Author

Topic

chris_cs
Posting Yak Master

223 Posts

Posted - 2008-08-22 : 07:00:46

Hey Guys,

Does anyone know if it is possible to publish a report so that I can pass variables to it via a URL?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-08-22 : 09:54:07

do you mean passing parameter values through? if yes, then its possible. just append the ¶metername=value to report url so that it takes that value.

chris_cs
Posting Yak Master

223 Posts

Posted - 2008-08-22 : 09:59:52

Thanks for the reply that's exactly what I mean.

I'm having some trouble appending the value to the url though. If I go to the Reporting Services portal and browse to my report the URL is as follows:

http://servername/Reports/Pages/Report.aspx?ItemPath=%2fPrompt+List%2fPrompts+List

I'm assumin you meant that I should tag &user=AAA onto the end of this?

chris_cs
Posting Yak Master

223 Posts

Posted - 2008-08-22 : 10:51:21

I've managed to figure this out now. I needed to use the following:

http://servername/reportserver?/Prompt%20List/Prompts%20List&rs:Command=Render&user=DJJ

Thanks for your help.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources