Hiding Columns In SSRS Report Until Row Group Expanded

Question

I have an SSRS report which consists of approximately 25 columns. There are also three row groups. I'm trying to hide specific columns in the report initially, and only make those columns visible when the row groups are expanded. Here is a screenhot of the report in its collapsed state:

Collapsed Report

So, when the report is collapsed, I want these four columns hidden: Policy Number, Invoice Number, Transaction Type, Date. These columns should only be visible once the row groups are expanded. See below:

Report Expanded

Another view of the expanded report: Expanded Row Groups

I do not have any column groups currently defined, only row groups.

I tried defining a column group using Policy Number as as test, and then set the visibility to an expression: =iif(IsNothing(fields!Current_Policy_Number.Value), False, True)

That expression hid the column, but when expanding the row groups, the column still stayed hidden.

I've been looking everywhere, but all the options I've found don't seem to fit my exact situation.

Any help would be appreciated!

Answer 1

One way to do that is to implement a custom grouping mechanism.

Use a custom group-icon and a hidden parameter. By default, groups should be hidden. So the visibility for necessary rows and columns should be:

=iif(Parameters!CustomGroup.Value = 0, False, True)

When user clicks the icon, a parameter is set (reload current report with CustomGroup-parameter set to inverse value) and then the groups are visible.