Hiding Table Columns Dynamically

[Simon Keeton]

Hi,

I have a table where I’d like to selectively hide one or multiple columns based on a report parameter.

To do this I’ve created a column group in the table and have added a filter to it.  For the parameter I am building a short CSV list of the names of the columns that should be in the table so for example parameterA may equal “columnA, columnC, columnE, columnD”

In the filter I’ve used syntax to say:

Fields.columnA = If parameter like ‘%columnA%’ then Fields.columnA else null

AND

Fields.columnC = If parameter like ‘%columnC%’ then Fields.columnC else null

This approach works fine for the first column, but even if I change the report parameter applicably it’s always the first column that gets supressed and not any of the others.

Anyone got any ideas on it, or been able to suppress various multiple columns dynamically with a different approach?

Many thanks,
Steve

[Simon Keeton]

Hi,

I figured this one out.

By adding an adjacent column group for each of the fields and then adding individual filters to each column group I got what I was looking for.

Thanks,
Steve