Reporting Services 2008: Using user!userid in Parameters

Question

I have a report with a parameter that is populated by a list of sales representatives returned by a query. I want to filter that list based on security rights of the user running the report.

In order to make the query work I need to pass the user!userID to the db. I tried something like this:

...where UserName = user!UserID...

But it doesn't like the syntax.

Answer 1

Change your query to:

where UserName = @user

... and in the "Parameters" tab, assign "User!UserID" to the "@user" parameter.