Oracle and Crystal Reports
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Oracle and Crystal Reports

  1. #1
    Join Date
    Aug 2002
    Posts
    2
    I have the problem when I include a numeric column (int or number) from my Oracle DB in the Crystal Reports the numbers have always two decimal places by default.

    Seagate knows this bug and released a fix for it but it didnīt work.

    Knows anybody a fix for this prob ?



  2. #2
    Join Date
    Nov 2000
    Location
    Atlanta, GA, USA
    Posts
    85
    In crystal Reports, right click on the number field and select "Format Field", go to the Number tab and change the 1.00 to 1 under "Decimals". The default value is 1.00.

    If you would like to change the default setting for Crystal, Go to File, Options, Fields, Number, Number Tab, and change the 1.00 to 1 under "Decimals".

  3. #3
    Join Date
    Aug 2002
    Posts
    2
    Thanx....but this is not the problem.
    The prob is that i must join the column with a column from a MS SQL-DB and that didnīt work cause the decimal places.

  4. #4
    Join Date
    Nov 2000
    Location
    Atlanta, GA, USA
    Posts
    85
    Have you tried to get rid of the decimals before joining the tables ? Try the TRUNC function of oracle.
    trunc(table1.field1,0)

    Hope this helps.

Posting Permissions

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


Click Here to Expand Forum to Full Width