SSRS Parameter based on User

• neha.maasala

  Valued Member

  Points: 65

  More actions

  February 24, 2014 at 4:10 am

  #283993

  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

• Daniel Bowlin

  SSC-Dedicated

  Points: 34566

  More actions

  February 24, 2014 at 8:33 am

  #1691582

  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.