Passing parameters in an URL to a report

Question

Passing parameters in an URL to a report

Jan-155192

SSCrazy

Points: 2613
More actions
May 9, 2006 at 8:18 am

#172436

Hi,
I want to pass a parameter directly in the URL to a report, without querying the user.
To do this, I have set the report parameters as follows:
- available values: Non-queried
- default values: Non-queried, =Globals!ReportServerUrl
This works fine, but I get the complete URL, not just the parameter (ex: http://localhost/reportserver/folder?test=myvar) How should I parse the parameter value out of here? Where can I write code in SSRS?
Thanks,
Jan

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

wayneph SSC Eights! Points: 828 More actions · Answer 1

You shouldn't need to parse the variable out. SSRS should do it for you. As long as the Parameter exists, it will be populated from the Query String.

You shouldn't need to set the default value in this case. You only need to set the default for when a value is not passed in at all.

wayne

Jan-155192 SSCrazy Points: 2613 More actions · Answer 2

Wayne,

Thanks, but I do not understand it completely yet. From which query string?

The URL parameters are not part of a dataset. I tried to do this on your suggestion, and indeed I can add predefined parameters as "calculated fields". There agan I can use "ReportServerURL", but so I'm stuck with the same problem I had before passing it through a dataset.

Regards,

Jan

wayneph SSC Eights! Points: 828 More actions · Answer 3

If you create a parameter named Test. You can get it's value by using the following expresion:

=Parameters!Test.Value

If you pass it in on the query string SSRS will automatically take it from the URL and update the value in the Parameters collection.

wayne

SQLWannabe SSCrazy Points: 2842 More actions · Answer 4

So, if I have an asp (not ASP.NET) page (let's call it deals) that was displayed using a sproc and that url has the value I want to pass in it, and I want to create a hyperlink to run a report on this deal, how do I pass my variable into my report? In other words my url looks like this:

http://MyServer/Deals/Deal.asp?DealID=925.

I want to pass 925 into my report. I can run the report manually and input the 925 into the "Prompt" box, but I want my users to click on the hyperlink and have it pass 925 into my parameter for my stored procedure that gets a dataset for my report. How can this be accomplished? I have my parameter, intDealID, in the report. Do I want to get my values from the 'Default Values' area? I feel like I'm on the 2 yard line, but can't put it in the end zone.