Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

ssrs setting column visibility on rowgroup

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. Trying to hide the entire first column.

SSRS 2008 R2

like image 607
Gabe Avatar asked Aug 09 '12 20:08

Gabe


People also ask

How do I hide empty columns in SSRS?

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".


1 Answers

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.

like image 113
JKF Avatar answered Oct 03 '22 10:10

JKF