leehockhin Posted September 27, 2007 Share Posted September 27, 2007 Hi, I have a row that produces a "null" column in my crosstab. I want this row to be printed, thus I cannot drop this data using the query. Is there a way to suppress/drop the "null" column?See attached pdf for a better idea of my problem. [file name=ztp_purchase_loads02.pdf size=40226]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/ztp_purchase_loads02.pdf[/file] Link to comment Share on other sites More sharing options...
burasami Posted September 27, 2007 Share Posted September 27, 2007 just right click in the column and click on properties and click on text field tab and tick the box "blank when null" Link to comment Share on other sites More sharing options...
leehockhin Posted September 28, 2007 Author Share Posted September 28, 2007 Thanks for your suggestion.If I did not misunderstand you,The instructions removed the word "null" for the column header cell, but the whole column is still there. What I want to do is to suppress/drop the whole column.The whole column (with column header "null") has no significant value in it and is only taking up space. Link to comment Share on other sites More sharing options...
burasami Posted October 3, 2007 Share Posted October 3, 2007 ok click the field and in printwhen expression write as $F{field_name}==null?true:false.. i think this may help you 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