Dynamic text depending on content

[dercognus]

Hi all,

I added some textfields to a report which contain different value. It is possible that these values are "null". I want to check if the contant is "null" and if so set the text in this textfield to a default char (say "-"). Can anybody help me how I this can be done?

Thanks in advance

Cognus

 

[cjturner]

Is underlying DB MySQL? You can probably do (some variant of) this in your SQL query;

Select

AAA,

BBB,

IF(target_field IS NULL, '-',target_field) as My_version,

CCC from ...

 

The 'My_version' field is the one you would use in the report.

[dercognus]

No it's no DB as data source. I use a JavaBean as datasource.

[szaharia]

You could use a <printWhenExpression /> for your report element. You can define 2 report elements with the same x, y, width and height, one containing the valid data, and the other exposing only the '-' character. Using their printWhenExpression you can make them visible or no in your document, depending on the "print when" condition.

Hope this helps,

sanda