ssrs setting column visibility on rowgroup

reporting-services ssrs-2008
Gabe picture Gabe · Aug 9, 2012 · Viewed 32.6k times · Source

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

Answer

JKF picture JKF · Aug 10, 2012

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.

Related questions

How do I format date and time on ssrs report?

on SSRS report I need to show todays date and current time i tried this =FormatDateTime(Now,"MM/dd/yyyy hh:mm tt") but this is not working for me giving an error. Anyone please help me for expression ? I …

Read More
How to get rid of blank pages in PDF exported from SSRS

I have a two-page SSRS report. When I exported it to PDF it was taking 4 pages due to its width, where the 2nd and 4th pages were displaying one of my fields from the table. I tried to set the …

Read More
SSRS Query execution failed for dataset

Have just deployed my Project on to my reporting Server. I have multiple datasets which are referencing views which exist on the db on that server. When I try to go into any report part I am getting this message: …

Read More