How to Remove or Hide Blank Columns in Excel through iReport

[pramod.kr0820]

Hi, I am struggling with a problem: I have one static text field and 24 columns in Excel file. I wants to display columns on true, false condition. 

True and false condition working fine, but above static text field not adjusting as per columns display. could you please tell how to adjust static text 

fields dynamically as per the conditions.

How to remove Empty Dynamic fields in above excel. After remove, above static text field should auto adjust. pleaseeeeee help me.

 

[hozawa]

If you've already set "net.sf.jasperreports.export.xls.remove.empty.space.between.columns" and it's not working, you'll probably have to dynamically create layout instead of using Jaspersoft Studio to create static layout.

http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.export.xls.remove.empty.space.between.columns

[pramod.kr0820]

Hi, thanks for your solution. Is there any way in which we can do same thing in iReport 3.7.3 or above

[hozawa]

Sorry, iReport is depreciated and no longer supported.

[pramod.kr0820]

Hi,  I have added one Dynamic field instead of Static text in iReport. I will visible on some condition basis. but, It's also have same problem. It will not auto adjust if I give inputs for alternate rolumns. it woks for all continues starting colums or end columns but not for other conditions. please help on this.

 

 

[pramod.kr0820]

Hi, Pleaseeee Can Anyone provide solution for this problem. It's very-2 urgent. thanks in advance