| View previous topic :: View next topic |
| Author |
Message |
cazbym
Power User
Joined: 16 Mar 2009
Posts: 63
|
 Posted: Tue Apr 24, 2012 11:14 am Post subject: [SOLVED] Numeric Null vs Blanks in Report Builder |
 |
|
The easiest way to describe my problem is the link below:
http://www.mediafire.com/download.php?691pbwaq3hh0772
I have a report which requires some Null decimal fields to return blanks, but they are coming up "N.an".
Link shows example of what is required.
_________________
OpenOffice 3.3
Windows 7
HSQL 2.1 file mode
JRE 1.6.0 30
Last edited by cazbym on Fri Apr 27, 2012 4:01 pm; edited 1 time in total |
|
| Back to top |
|
 |
cazbym
Power User
Joined: 16 Mar 2009
Posts: 63
|
| Posted: Wed Apr 25, 2012 12:15 pm Post subject: |
|
|
Hi,
Found the answer. Unbelievably to remove NULLs from the report - if you put NULL in the Conditional Print Expression box on the General tab of the problem Field's properties - all the NULLs are returned as Blanks.  |
|
| Back to top |
|
|
|
