setting new conditions in designing the rpt

hi,
thanks for ur replies which r valuable.
Am using ireport1.2.0, its fine working, but when i want to use zeros incase where the values are null and the datatype is numeric, instead of making it blank, and i don't want to give the condition in textfield expression like true or false when value equalto null...,
then whats the alternate method and also where the ireport is handling all these conditions, i can't able to find it, not with the setter , getter methods, is it internally handled by jasper or how, can u plz help me in understanding the cycle.

Ur reply will be very helpful for me,
thanks ,
lio.
lio's picture
lio
36
Joined: Jul 18 2006 - 4:06pm
Last seen: 16 years 10 months ago

2 Answers:

The blank when null condition is handled by JasperReports.

The only way to print "0" instead havong a blank field if the expression return null is to put a condition into the expression itself.

Giulio
giulio's picture
71843
Joined: Jan 2 2007 - 4:15pm
Last seen: 3 weeks 6 days ago
If I understand you right 0 should be printed instead of blank.

You could do this already in your query (depending on the database your are using). Something like

NVL(field, 0) -> would result in 0 values instead of NULL in ORACLE.

rgds
friedrichh's picture
Joined: Jul 17 2006 - 10:47pm
Last seen: 16 years 11 months ago
Feedback
randomness