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.

    Monday, October 14, 2013 4:30 PM


All replies