List Output with ColumnNumber() (Dynamic Column Display)

[RickJ]

Good day all!

I haven't had much luck finding information on this so I figured I would post here and see if anyone had something to add...

I'm trying to create a list output report that dynamically hides/shows columns based on user selection. Now I know I can create a variable for each column, check the parameter and render it that way. However I was trying to be fancy and use a single variable to handle all my renders.

What I tested was creating a boolean variable where: ColumnNumber() = 2

This should return yes for column 2 and no for all other columns. Then I use this variable as the render and tested, but it does not appear to be working. It seems to behave very strangely sometimes hiding all or displaying all columns despite what values I feed it.

So my questions:
1. Does ColumnNumber() work like I think it's supposed to? That is in a variable it will return the column of the list I am formatting? My google searches seem to indicate that CellValue, ColumnNumber etc are supposed to work that way...so this is why I'm confused. Maybe it only works on CrossTabs?

2. If it doesn't work, is there some other way to achieve the same objective?

Thank you!