Hide columns on reports

[mpiaser]

Is there a way to hide a column on a report if the column is blank or 0?

If there is a way to do this, will the hidden column NOT show up when the report goes to Excel?

[butlerc]

Yes, by using 'Print when Expression' property, just give it Boolean expression to your desired affect.

If you use a table element, then regardless of where the column is in the table the column will be removed and table re-sized dynamically. 

[mpiaser]

Where can I see the print when expression property.  When I right click a field I am not seeing the option.

[butlerc]

left click field - then look at properties tab. right click menu its not there.

[butlerc]

Yes, by using 'Print when Expression' property, just give it Boolean expression to your desired affect.

If you use a table element, then regardless of where the column is in the table the column will be removed and table re-sized dynamically. 

 

left click field - then look at properties tab. right click menu its not there.

[mpiaser]

I can see the Print when Expression property and I have tried various expressions but I'm not getting the right one.  the field is $F{device_name} and if it is blank I want the column to be removed when it the Excel sheet is created.

[mpiaser]

I can make this work for strings using: new Boolean($F{off_peak_free_minutes}.trim().equals("")==false)

I have to put this expression on the column headings and the column data.

 

So far I can't get the expression right to compare with zero.