开发者

SSRS 2005 Report Model Filter Named Query on Global UserID

开发者 https://www.devze.com 2023-01-22 09:32 出处:网络
Is it possible to filter a named query in a reporting services data source view o开发者_JS百科n the global user ID?

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号