CODEWITHSUNDEEP
reporting-servicesssrs-2012
Hare Rama Hare Krishna
Hare Rama Hare Krishna

Reputation: 1115

SSRS Report Hiding columns from different clients

I am having a requirement,say like a report having 6 columns(1,2,3,4,5,6) and I need to send this report to 2 clients A and B

client A needs only(1,2,3,4)

and Client B needs only(5,6)

How do I approach this ? I am very new to SSRS.

Upvotes: 0

Views: 34

Answers (2)

Randy
Randy

Reputation: 26

Assuming you have a parameter with the client id in it, like @Client, and @Client="A".
You can put an "iif" function in the hidden attribute of each column.
For example:
Colunm1.Hidden would be =iif(Parameters!Client.Value="A", False, True)
Is that what you are looking for? Maybe enough to get you started.

Upvotes: 1

Rednaxel
Rednaxel

Reputation: 968

Try the following =IIF(Fields!MyID.Value > 0, True, False). Try returning "SomeFieldValue" as an integer either at the database or dataset level it can be the client id.

For instance in your dataset query, cast SomeFieldValue (client) to an int and then in the column visibility expression try:

=IIF(Fields!SomeFieldValue.Value > 0, True, False)

Upvotes: 1

Related Questions