Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Neha M
Starting Member
1 Post |
 Posted - 2014-02-24 : 06:55:22
|
| 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 50User 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 advanceNeha |
|
|
maunishq
Yak Posting Veteran
71 Posts |
Posted - 2014-02-25 : 14:20:46
|
| Instead of putting a parameter @Team, why don't you use the conditional formatting on the rows to display. i.e. don't put parameter @Team, and write IIF condition on rows hidden.so, right click on the details row, select visibility, select based on expression, and write your condition like:=SWITCH(User!UserID = "A",Fields!Team10.Value, and so on....)!_(M)_! |
 |
|
|
|
|
|
|
|
SSRS Parameters Based on User