Passing Parameters To Report Through URL in SQL Server Reporting Services (SSRS)

I was working on one of the requirements for a client where in the application owned by the client had a set of values in report column. The requirement was to make each of the values in that column a URL, on clicking this URL the value gets passed as a parameter to another report and the report is rendered without having to manually select/enter the parameter.
 
I had implemented a similar requirement in SSRS 2005 for one of the previous clients. In this current requirement which I am talking about the implementation was in SSRS 2008, which from this requirement standpoint does not make any difference.
 
I knew that we need to concatenate the value of the parameter to the URL of the report and this will do the job. So I took the report URL from the Report Manager and tried to concatenate the parameter but ended up in failure.
 
To resolve this I tried searching the web and found one article (http://www.mssqltips.com/tip.asp?tip=1336) which explained about various options/features which can be implemented through the report URL in SSRS.
 
While going through this post I found one very interesting thing and that is we need to concatenate the parameter value to the Report Server URL of the Report and not the Report Manager URL of the Report.
 
 
Many times we end up implementing the things in a straight forward fashion and hence dont come accross this kind of peculiar situations. However sometimes when we try doing the same thing differently, we end up meeting with this kind of peculiar findings which are worth treasuring in ones knowledge base.
 
Trying to implement something in different ways is worth it since we either end up finding an alternate/better/worst option which can be used to justify the best among the solutions identified or end up finding this kind of scenarios which have only one way to implement.
 
Happy Reporting 🙂
Advertisements

About Dattatrey Sindol (Datta)

Datta is a Microsoft BI Enthusiast, passionate developer, and a blogger. View Full Profile

Posted on November 23, 2009, in SQL Server, SSRS, SSRS Tips and tagged , , , , , , . Bookmark the permalink. Leave a comment.

What are your thoughts?

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: