Remove empty column from report

[amitaiemd]

Hello,All

Pls help i am in a big trouble,i have report page where selected columns and their values will be shown.Everything is fine but the issue is that,suppose i hav  report consisting of 10 column ,now i want to see only 5 columns and their values.,Here comes the problem except the selected 5 columns rest of the 5 columns are not showing but their spaces are still occupied by them.

i tried RemoveLineWhenBlank,BlankWhenNull and alsoPrintWhenExpression but no result.

 

 

In the attachment you can see after the name there were two empty column which are not showing but there space is still there.

Post Edited by amitaiemd at 08/09/2012 12:51

[cmatthews]

 Can you do it in the query with case statements and/or coalesce? Just collapse it down to the left first then the columns to the right will be the blank ones.

 

 

[amitaiemd]

I did'nt get your answer properly,what i am doing i am returning an arraylist containing multiple fields with value and without value(null).Now i want my report to be shown only the column which has data and it should overlap those column which has empty data or null value.

Please do suggest i badly need it.

Thanks

[amitaiemd]

i still did'nt get the right answer.It means nobody has the answer.

[jasperjones999]

try adding an expression to the "Column" (not the cells)

!$F{columnYourHiding}.toString().isEmpty() -- assumes the col is a string type

On "cell tab"  -> "Print When Expression" field