Answered by:
How to Hide and Show Parameters based on user Security in AD Group.

-
Hello,
I have two identical reports (one returns confidential data and one is for public). The public report has only one prompt (date) and it retrieves data only for the userID of person running the report. The confidential report has another extra prompt, Date and UserID. By entering someone else’s userID, it retrieves data for that userID, only managers have access to this report.
I have created a process (TSQL Function) by passing a userID, I can determine if a user part of public group or managers.
Instead of creating multiple reports for multiple groups I want create one report and I have done that. The problem is that I don’t have any control over parameters.
For example: UserA is public and UserB is part of managers group. I can determine based on my function which group user belong to then dynamically execute proper sql for its dataset.
UserA parameter Date
UserB Parameter Date, UserID
How can I show or hide the extra UserID when UserA runs the report?
Thank you.
Question
Answers
-
Hi rv7a99cv,
From your description, you want to hide/show a parameter UserID depend on whether the user is part of public group or managers. In Reporting Service, we can’t set the parameter visibility to Visible or Hidden based on an expression, it is not supported in current release of Reporting Services. So we can’t hide the UserID parameter based on the user Security in AD Group.
However, it seems that the method which you have done before is the best workaround for you based on my research.Thank you for your understanding.
Thanks,
Katherine Xiong- Marked as answer by rv7a99cv Tuesday, October 15, 2013 8:18 PM
All replies
-
Hi rv7a99cv,
From your description, you want to hide/show a parameter UserID depend on whether the user is part of public group or managers. In Reporting Service, we can’t set the parameter visibility to Visible or Hidden based on an expression, it is not supported in current release of Reporting Services. So we can’t hide the UserID parameter based on the user Security in AD Group.
However, it seems that the method which you have done before is the best workaround for you based on my research.Thank you for your understanding.
Thanks,
Katherine Xiong- Marked as answer by rv7a99cv Tuesday, October 15, 2013 8:18 PM
-