开发者

Choosing a Reporting Services parameter value based on the currently logged in user

开发者 https://www.devze.com 2022-12-29 15:00 出处:网络
Here\'s my situation.I have a Microsoft Reporting Services report that as a parameter takes a salesperson\'s name and shows them their sales across their territories blah blah blah.

Here's my situation. I have a Microsoft Reporting Services report that as a parameter takes a salesperson's name and shows them their sales across their territories blah blah blah.

But, salesperson A should not be able to choose and view salesperson B's data. So, my thought was to get the currently logged in user from Reporting Services, and then use that to populate the "salesperson" parameter.

Is there a way to get the currently logged in开发者_如何学编程 user through some hidden RS interface, or is there some other way of accomplishing my goal that I'm just not seeing? Any help would be GREAT, as the higher ups aren't too happen with my (apparent) lack of security right now.


you can use from this in the Expression list: in SSRS 2008 : Built in Fields -> UserID

0

精彩评论

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