mpiaser Posted February 22, 2015 Share Posted February 22, 2015 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? Link to comment Share on other sites More sharing options...
butlerc Posted February 22, 2015 Share Posted February 22, 2015 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. Link to comment Share on other sites More sharing options...
mpiaser Posted February 22, 2015 Author Share Posted February 22, 2015 Where can I see the print when expression property. When I right click a field I am not seeing the option. Link to comment Share on other sites More sharing options...
butlerc Posted February 23, 2015 Share Posted February 23, 2015 left click field - then look at properties tab. right click menu its not there. Link to comment Share on other sites More sharing options...
butlerc Posted February 23, 2015 Share Posted February 23, 2015 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. Link to comment Share on other sites More sharing options...
mpiaser Posted April 7, 2015 Author Share Posted April 7, 2015 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. Link to comment Share on other sites More sharing options...
mpiaser Posted April 11, 2015 Author Share Posted April 11, 2015 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now