Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS Parameter based on User Expand / Collapse
Author
Message
Posted Monday, February 24, 2014 4:10 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 4, 2014 5:59 AM
Points: 1, Visits: 283
Hi,

I created a Report using BIDS.

The requirement is to restrict the parameter value based on User.

In the report there is one parameter(@Team) with multiple values which shows the team values.
The Team values should change for user to user based on the user .

Users: A,B,C,D and E Team:10,20,30,40 and 50

User A(belongs to team 10) should only choose @Team value 10 and other values(20,30,40 and 50) disappear/not able to choose.

User B(belongs to dept 10,20) should only choose @Team value 10,20 and other values(30,40 and 50) disappear/not able to choose.

User C(belongs to dept 30) should only choose @Team value 30 and other values(10,20,40 and 50) disappear/not able to choose.

User D(belongs to dept 40,20,10) should only choose @Team value 40,20,10 and other values(30 and 50) disappear/not able to choose.

User C(belongs to dept 10,20,30,40,50) should choose All @Team values 10,20,30,40,50.

How to implement this?

Thanks in advance

Neha
Post #1544424
Posted Monday, February 24, 2014 8:33 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 29, 2014 12:18 PM
Points: 2,818, Visits: 2,561
Create a hidden parameter using the built in field User.UserID as the default value. Then use that parameter as a constraint to another query that is used to create the available values of the parameter you want to be user sensitive.
Post #1544559
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse