Please help printWhenExpression

[Kannan_S]

hi friends,

i have generated a csv file.

considering this csv file as a datasource i have to generate two reports based on a particular field.

 

the field name is id. it has only two types of data.

one is null and the other is 100ADxxxx.

 

i.e.,

 

the contents of the csv file is

 

null,peter null,mark 100AD1234,antony 100AD3265,george

 

one report should have

 

null peter null mark

 

second report should have

 

100AD1234 antony 100AD3265 george

 

i think i should use printWhenExpression in the jrxml file. But i am not clear how to implement that.

it is an easy task to achieve it in query making use of "like '100AD%'". but i should not do that.

 

is there any tag like printLikeExpression where by we can find whether the first 5 characters (100ADxxxx)of the data is similar to 100AD so that those data alone can be displayed?

 

please send me the code or any other good solution.

[rcracel]

Hi Kannan,

 

why not set it to print whenever the field is not null?

 

RC

[C-Box]

Here a simple Sample for your PrintWhenExpression:

 

Code:

new Boolean($F{MyField}.startsWith("100AD"«»))

 

;)

 

hth

C-Box

[Kannan_S]

Please find that only the field is not getting displayed and other rows are getting displayed when the condition is satisfied.

 

i need some thing like

 

select * from csvdatasource where id like '100AD'

 

so that only the rows in which the field id is like 100AD shall be displayed

 

now i am getting

 

100ADxxxx dsfdf 100ADxxxy sddfd -------- dfdfer ------- ererer

 

but i need

100ADxxxx dsfdf 100ADxxxy sddfd

 

only as a seperate report and

 

null dfdfer null ererer

[C-Box]

So when I do understand right you want show the fields in turn.

 

so you should use the PrintWhenExpression:

 

Code:

 new Boolean($F{id} == null) 

 

for BOTH Fields(id and name)

 

and check the attribute "removeLineWhenBlank" to true.

 

So the output will be if the PrintWhenExpression is TRUE:

 

null,peter null,mark

 

 

 

and if FALSE:

 

100AD1234,antony 100AD3265,george

 

 

must work! ;)

 

hth

C-Box

Post edited by: CBox, at: 2006/09/21 08:29

[lucianc]

If you set the printWhenExpression for a text field, then of course that the expression will only apply to the text field.

 

You should either set the printWhenExpression for the detail band or, if you are using JR >= 1.2.5, use the report filterExpression.

 

HTH,

Lucian