Hiding Empty Column Group Headers in a Table

[ballinascreen]

Folks,

I'm using a DataSet as a datasource for a table in on of my report detail bands. The DataSet comprises of three separate groups and therefore I have 3 corresponding header column groups. Each header column group contains a single Text Field which is used to print out pertinent headers as the groups change. However, one of my groups will not always contain a value and in these cases I would prefer that the group header cell was hidden/removed - rather than leaving a fixed space matching the predefined height of the cell.

I've tried setting various combinations of 'Remove Line When Blank' at the table level, and 'Remove Line When Blank' & 'Blank When Null' at the Text Field level and nothing seems to work. Is it possible to do this? Or am I missing something obvious?

Would appreciate any info/workrounds.... thanks.

 

Post Edited by ballinascreen at 05/31/2012 12:12

[adamp99]

 Maybe you could try the following

 

Say COLUMN1, COLUMN2, COLUMN3

 

Create a copy of COLUMN3 and place it in the same position as COLUMN2

 

Then use the "Print When Expression" to define when each of the columns are visible (this will only be displayed in preview)