CODEWITHSUNDEEP
reporting-servicesssrs-2008query-stringssrs-2008-r2ssrs-2012
Pedram
Pedram

Reputation: 6508

Read query string parameter value in SSRS Report

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'.

Upvotes: 0

Views: 3600

Answers (3)

Pedram
Pedram

Reputation: 6508

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

Upvotes: 0

stubaker
stubaker

Reputation: 1958

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

Upvotes: 1

Aditya
Aditya

Reputation: 2301

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)

Upvotes: 0

Related Questions