SSRS Hide Column Based on Drill Down Level

Asked Jan 10 '14 at 10:07

Active Jul 13 '15 at 09:19

Viewed 640 times

I have a ssrs reports with 3 row groups and 2 columns. e.g. Continent > Country > City | Sales | Tax

The user drills down from Continent to Country to City. They can always see Sales and Tax.

i want to hide the tax column when the user drills down to the city level (click + sign on country).

I have tried setting the column visibility based on a expression e.g. =IIF(CountRows("City")>0,False,True). But this gives me an error relating to scope.

Does anyone have any idea on how to do this?

asked Jan 10 '14 at 10:07

user1786107

2,921
5
24
35

How do you achieve the drill down? – kelsier Jan 12 '14 at 06:11
I use row grouping to achieve the drill down. I have 3 row groups. Continent, Country and City. – user1786107 Jan 13 '14 at 10:46

SSRS Hide Column Based on Drill Down Level

0 Answers0