Read query string parameter value in SSRS Report

Question

I have passed one parameter to report server url.

http://<your server>/ReportServer?/<folder>/<reportname>&UserID=Name

How can I read UserID value in report.

Or

How can I print this value in any of the textbox to check what is passed to it?
For example: Above url should show 'Name'.

stubaker · Accepted Answer · 2016-02-05 00:50:30Z

1

Based on your comments I think you've figured this out already, but all you should need is the parameter UserId to exist on the report and it will get its value from the query string.

A couple other problems that can crop up when trying to pass a parameter:

Report parameters are case sensitive
Report parameters with visibility set to Internal can't be passed a value through URL

See also: Pass a report parameter within a URL on MSDN

answered Feb 5, 2016 at 0:50

stubaker

1,9581 gold badge23 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Aditya · Accepted Answer · 2016-02-03 10:31:10Z

0

You can try with the Built-In SSRS fields ...

Try using Expression -> Built-In-Fields -> UserId should work in this case, if I understood your question correctly...

OR

Try manipulating the report server URL. Provided below one for example ...

=mid(Globals!ReportServerUrl , InStr(Globals!ReportServerUrl,"&UserID=")+8)

edited Feb 3, 2016 at 10:31

answered Feb 3, 2016 at 9:11

Aditya

2,3198 gold badges40 silver badges58 bronze badges

4 Comments

Pedram Over a year ago

actually it will not show the query string parameter value of userID. For example I am passing Pedram but showing SERVER1\PC1

Aditya Over a year ago

From where you are passing Pedram ? Is it defined by you ?

Pedram Over a year ago

from web application in query string. btw can you please delete your answer as I wanted to this delete this question. it is due to my silly mistake I wan not getting parameter name in report.

Aditya Over a year ago

It is ok. Check for the updated answer. This should work in this scenario. It would help others also...

Pedram · Accepted Answer · 2016-02-05 04:12:03Z

0

Issue was with my parameter UserId.

I have set it as Internal that's why it was set to default value blank space instead of passed parameter UserId value. (Now I am using hidden)

Note: Report parameters are case sensitive so in my case it must be UserId

answered Feb 5, 2016 at 4:12

Pedram

6,55811 gold badges69 silver badges93 bronze badges

Collectives™ on Stack Overflow

Read query string parameter value in SSRS Report

3 Answers 3

Comments

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related