Is it possible to filter a named query in a reporting services data source view o开发者_JS百科n 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!
What I was looking for can be achieved by adding a filter attribute to the relevant entity in the report model. I eventually stumbled on a tutorial on MSDN which details a similar issue here.
精彩评论