sql server reporting services: Filter query on userID in Reporting services -- sql server reporting services

Re: Filter query on userID in Reporting services

Jéjé
12/17/2005 8:56:35 AM

sql server reporting services: yes,
your query should be:
select * from table where LastName = @UserID

then map the @UserID parameter in the query to the global variable UserID

[quoted text, click to view]

Filter query on userID in Reporting services

Bertrand Burquier
12/17/2005 2:38:47 PM

Hi,

In reporting services is it possible to filter tables on global varial
UserID in a
query?

Like : select * from adress where LastName = UserID

What is the syntax exactly ?

Thanks for your help

Bertrand Burquier