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

Question

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.

Answer 1

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

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time.
Thanks for helping make community forums a great place.

Answer 2

Thank you.