Number field problem

Petbul · Oct 7, 2002

I have some problems with retreiving numbers with decimal places into Seagate report...Numbers are displayed in correct (required) format - e.g. 7,00 but related field in database contain 7,5. (Oracle 8.1.6, field type number,11,2).
Field format in Seagate seem's to be OK...
Fields are in the report without any changes (no formula applied).
Any Idea?
Thanks Petr

synapsevampire · Oct 10, 2002

Not sure what you need exactly.

You can right click a field and select format field and change how the number is displayed, or you can change it globally through a report (anything inserted in after the change) by selecting File->Options->Fields->Number and formatting that.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

Petbul · Oct 10, 2002

Thanks,
but that's not problem of field format.
Described problem occurs only in Designer - If I schedule report /e.g. to Excel/ there are all fields displayed correctly - with all decimal places /as in Example 7,5/ but not in Designer.
I think there could be some problem with national environment (Oracle, Win2000 etc.). We are using Oracle 8.1.6 with Czech Environment (NLS settings), decimal separator is "," and this could be the problem...(Somebody suppose to edit windows registry for Oracle...).
Petr

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Number field problem

Petbul

MIS

synapsevampire

Programmer

Petbul

MIS

Similar threads

Part and Inventory Search

Sponsor