I'm trying to hide a column but it belongs in the RowGroups area. Unfortunately, the Column Visibility is greyed out and disabled. I'd like to just hide the column under certain conditions (using expressions) but keep the grouping.
I found a similar question on SO but its solution did not work for me. Is there a workaround for this?
ssrs column visibility inside row groups
I've tried shifting some of the columns to the body area of the tablix, but then I can't merge cells vertically. I'm not sure what my options are.
In the image below, I'm trying to hide the first column but the Column Visibility option is disabled. .
SSRS 2008 R2
So, in case of a tablix, right click on the column, choose Column Visibility and write down the above expression below "Show or hide based on an expression".
Are you trying to remove Column 1? If you right click on the column header and choose Delete Column it will prompt you to either delete column and associated groups or column only. If you choose column only the grouping should remain.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With