removing a field from the report

[preetipratapyahoo.com]

Hi,

How can i remove a field from the report ,when the value of the field is null.i used "Blank when null" and "remove line when blank" options,but the there is a blank space is in my report.Can i remove/hide that blank space?

[svenn]

Do you want to remove an item in a column of items or do you want to remove a whole row?

 

ie you have columns

 

a b c d e

 

and c is null so you end up with

 

a b d e

 

and would like to print in out as

 

a b d e

 

The only way to do this is to layer controls on top

of each other and control their creation with the "Print when expression".

[preetipratapyahoo.com]

Hi Svenn,

In my report i have rows like

a

b

c

d

e

 

If the value in the row c is null,i dont want to design

my report

 

a

b

d

e

 

Can u please tell me how can i use "Print when expression" to achieve this?

 

Thanks in advance

[svenn]

Ok it sounds like you don't want to show a blank row when C is null. To do this you need to set a value in the print when expression of your detail band.

 

1. Go to band properties

 

View -> Bands

 

2. Choose the detail band

 

3. In the Print When expression create an expression that evaluates to true when your row has a value. say your data source is the following SQL

 

select rowA from tableA

 

Your expression could be

 

new Boolean($F{rowA}.intValue()!=null)

[nickw]

Simply setting isRemoveLineWhenBlank to "true" will achieve this provided all elements in the row are blank. Svenn's solution can only work if every field in the detail row evaluates to "null" and you've got isBlankWhenNull set to "true".