×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Number field problem

Number field problem

Number field problem

(OP)
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
Replies continue below

Recommended for you

RE: Number field problem

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

RE: Number field problem

(OP)
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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close