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!