I want the user to be able to select which columns we display in their reports. I've got a multiselect parameter that has a list of the reports' columns as the display member (and a number as the value member).
In the Column Groups I've added in a filter on one of the columns like so:
However when I try to run the report I get this error:
I've troubleshooted the Parameters.availableColumns.Value and it has the expected values.
I've troubleshooted this expression "1 In Parameters.availableColumns.Value" in the report body itself and it works as expected (shows true/false correctly)
I've changed the expression in the Column Grouping box to both "1 = 1" and "1 =2" and it shows/hides the column as expected.
The only thing I can think of is Parameters.availableColumns.Value isn't populated when it hits that expression in the Column Grouping. Is that right? And if so how can I go about giving the user the option to select the columns they want to show?