[dba-issues] [Issue 116463] Conditional print expression not working with IF(ISNUMBER( functions

2011-02-05 Thread cdchar
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=116463





--- Additional comments from cdc...@openoffice.org Sat Feb  5 18:27:26 
+ 2011 ---
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])


-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org



[dba-issues] [Issue 116463] Conditional print expression not working with IF(ISNUMBER( functions

2011-01-17 Thread oj
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=116463


User oj changed the following:

What|Old value |New value

  Status|NEW   |RESOLVED

  Resolution|  |FIXED

Target milestone|---   |OOo 3.4





--- Additional comments from o...@openoffice.org Mon Jan 17 11:47:36 + 
2011 ---
Fixed in cws dba34d.

A fixed version can be found here
ftp://qa-upload.services.openoffice.org/dba34d/report-builder.oxt

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org



[dba-issues] [Issue 116463] Conditional print expression not working with IF(ISNUMBER( functions

2011-01-14 Thread r4zoli
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=116463
 Issue #|116463
 Summary|Conditional print expression not working with IF(ISNUM
|BER( functions
   Component|Database access
 Version|OOO330m19
Platform|All
 URL|
  OS/Version|Windows 7
  Status|NEW
   Status whiteboard|
Keywords|
  Resolution|
  Issue type|DEFECT
Priority|P3
Subcomponent|SRB
 Assigned to|oj
 Reported by|r4zoli





--- Additional comments from r4z...@openoffice.org Fri Jan 14 12:19:43 
+ 2011 ---
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.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org



[dba-issues] [Issue 116463] Conditional print expression not working with IF(ISNUMBER( functions

2011-01-14 Thread r4zoli
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=116463





--- Additional comments from r4z...@openoffice.org Fri Jan 14 12:22:09 
+ 2011 ---
Created an attachment (id=75563)
bugdoc with report


-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org



[dba-issues] [Issue 116463] Conditional print expression not working with IF(ISNUMBER( functions

2011-01-14 Thread r4zoli
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=116463





--- Additional comments from r4z...@openoffice.org Fri Jan 14 12:30:33 
+ 2011 ---
IF(ISNUMBER([field_name]);[filed_name]) is the correct function which I used in
example file.
Wrongly inserted into first post. 

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org