This is a migrated thread and some comments may be shown as answers.

Hiding Table Columns Dynamically

1 Answer 122 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Simon Keeton
Top achievements
Rank 1
Simon Keeton asked on 15 Nov 2012, 08:56 AM

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

1 Answer, 1 is accepted

Sort by
0
Simon Keeton
Top achievements
Rank 1
answered on 15 Nov 2012, 10:24 AM
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
Tags
General Discussions
Asked by
Simon Keeton
Top achievements
Rank 1
Answers by
Simon Keeton
Top achievements
Rank 1
Share this question
or