Issue 116463 - Conditional print expression not working with IF(ISNUMBER( functions
Summary: Conditional print expression not working with IF(ISNUMBER( functions
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: ReportBuilder (show other issues)
Version: OOO330m19
Hardware: All Windows 7
: P3 Trivial (vote)
Target Milestone: 3.4.0
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-01-14 12:19 UTC by r4zoli
Modified: 2011-04-02 16:14 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
bugdoc with report (28.09 KB, application/vnd.sun.xml.base)
2011-01-14 12:22 UTC, r4zoli 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description r4zoli 2011-01-14 12:19:43 UTC 
Open attached file, open report.
Run report the data in report formatted as number contains 0 (zero) or values
from table. 

Edit any number field (decimal or integer), copy from Data tab Data field, the
function IF(ISNUMBER([field_name]);[Szam_int];" ")into General tab Conditional
print expression, delete function from data field. 

Run report.
When you changed function from data field to Conditional Print expression, NaN
and one number can be found in report.
Comment 1 r4zoli 2011-01-14 12:22:09 UTC 
Created attachment 75563 [details]
bugdoc with report
Comment 2 r4zoli 2011-01-14 12:30:33 UTC 
IF(ISNUMBER([field_name]);[filed_name]) is the correct function which I used in
example file.
Wrongly inserted into first post.
Comment 3 ocke.janssen 2011-01-17 11:47:36 UTC 
Fixed in cws dba34d.

A fixed version can be found here
ftp://qa-upload.services.openoffice.org/dba34d/report-builder.oxt
Comment 4 cdchar 2011-02-05 18:27:26 UTC 
Hi,

OOo 3.3  + SRB 1.2.1-rev2 

If a DB numeric field is null, printed with format 0,00 the output is:
"N,aN"  instead of  blank as with previous versions.

With fix
ftp://qa-upload.services.openoffice.org/dba34d/report-builder.oxt

a conditional print expression is needed :
ISNUMBER([field_name])
Comment 5 ocke.janssen 2011-03-16 13:43:28 UTC 
Please verify. Thanks.
Comment 6 marc.neumann 2011-03-23 10:00:36 UTC 
verified in cws dba34d
if I change the function in the bugdoc to "IF(ISNUMBER([field_name]);[Szam_int];"")" the field is empty in the cws.
Comment 7 r4zoli 2011-04-02 16:14:12 UTC 
Checked in DEV300m105, OK.