in

jetlounge

the minty fresh blog that whitens your teeth!


Syndication


Passing Parameters to Reporting Services using an URL

by David Leibowitz | December 18, 2007 | Comments: 5

When launching SSRS reports by URL, it is often necessary to include parameters. To do so, simply include the parameter name, an equal sign, followed by the parameter.

So param=value for a report where CustomerID is 1 would look like:

http://localhost/ReportServer/Pages/ReportViewer.aspx?%2ReportFolder%2DemoReport&rs:Command=Render&CustomerID=1

Now, let's say you want to pass in a NULL value for CustomerID. That would look like:

http://localhost/ReportServer/Pages/ReportViewer.aspx?%2ReportFolder%2DemoReport&rs:Command=Render&CustomerID:isNull=True

 

del.ico.us digg this technorati BlinkList Furl reddit DotNetKicks google! live Facebook Stumble Upon Yahoo!



Comments

 

Umar said:

That didn't work for me.

July 8, 2008 7:16 PM
 

david said:

You need to change the localhost to your server (and port number if used)

July 9, 2008 9:13 AM
 

california auto insurance quotes said:

good stuff

May 28, 2011 4:46 PM
 

california auto insurance quotes said:

awesome post

May 28, 2011 5:26 PM
 

california auto insurance quotes said:

great point

May 29, 2011 1:13 AM

Leave a Comment

(required)  
(optional)
(required)  
Add
Powered by Community Server (Non-Commercial Edition), by Telligent Systems