SSRS passing parameter via a URL

Question

SSRS passing parameter via a URL

mikek4030

Old Hand

Points: 336
More actions
January 26, 2021 at 6:42 pm

#3837727

Hello,
I have been looking of a good example of how to accept a parameter value via a URL but I cant find an example that fits.
The stored Procedure that is used as the dataset into the report needs a parameter. We need the ability to pull the parameter from the URL which is carrying the field we need. I can't find in Visual Studio where to set (or link) the parm to the url. Can you help? Thanks

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

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

ratbak Ten Centuries Points: 1358 More actions · Answer 1

Are you saying you want to navigate to the parameterized report URL so the report calls the proc w/ the parameter(s) already defined rather than opening report & setting parameters in the UI?

https://docs.microsoft.com/en-us/sql/reporting-services/pass-a-report-parameter-within-a-url?redirectedfrom=MSDN&view=sql-server-ver15

Start w/ your report URL (w/o parameters) and then append the parameters.

Multi-valued parameter values are repeated as if different parameters rather than in a comma-delimited list: https://sqlryan.com/2017/08/passing-multi-value-report-parameters-to-ssrs-using-the-url-querystring/

URL-encode any reserved or unsafe characters.

Don't wrap string parameters in quotes.

e.g.,

http://my.reportserver.com/Reports/report/Dashboard/Awesome%20Data%20Comparison?Latitude=45.018&Longitude=-92.60&AddressLabel=JoesHouse&ColorList=red&ColorList=green&ColorList=blue

mikek4030 Old Hand Points: 336 More actions · Answer 2

Thanks ratbak,

To go along with the last email. I did visit the sites earlier. And all though they do explain how to pass the parameter (unless I missed it) it does not explain how to set the passed parameter into the SSRS report parameter. When you go to the parameters properties, there is nothing suggesting pulling it from a URL. Like you would think there would be a setting for it.

Thanks again

mikek4030 Old Hand Points: 336 More actions · Answer 3

sorry I thought I replied earlier.

YEs, our URL contains an encrypted emp id that the user can't read. We want to pass that to the SSRS report and use it as one of the parameters in the report. I've been hunting for the answer. I find sites that tell you how to pass the parameter, but not how to handle it on the SSRS end.