Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2006
    Posts
    30

    Question Unanswered: how to display a number with 14 decimals

    i am using Oracle data base and i am storing a new 38digits(24, 14 decimals). but when i call it in the crystal reports its getting round off. can any one tell me how to display a number with 14 decimals

  2. #2
    Join Date
    Aug 2004
    Location
    Pune,India
    Posts
    94
    you can use specific formatting for this field. You can always define the number of decimal places you require with the numeric value.

    Hope this helps.
    In GOD we believe. Everything else we Test!

  3. #3
    Join Date
    Sep 2006
    Posts
    30
    i tried it..but its not accepting more than 10 decimals

  4. #4
    Join Date
    Nov 2005
    Location
    San Francisco, CA
    Posts
    506
    Quote Originally Posted by ppavan21
    i tried it..but its not accepting more than 10 decimals
    Crystal doesn't allow more than 10 decimal places,so to achieve your goal you need to convert it to a varchar field ,and then it will display it as a text .
    but you need to do all those subtotal calculations at your query level if your requirements are such.
    Success is the ability to go from one failure to another with no loss of enthusiasm.
    - Sir Winston Churchill
    Joydeep

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •