views:

9

answers:

1

Hi,

Is it possible to filter a named query in a reporting services data source view on the global user ID?

I would like to do something like select UserName, ContactNumber, Email from Users WHERE (Users.UserName = User!UserID) so that it returns the name and contact details of the user running the report.

Any help would be much appreciated!