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
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?