locked
Rounding Off values In Crystal Reports RRS feed

  • Question

  • Hi am using crystal reports to display data .Here my stored procedure has a value of type string but when i pull data into report it takes the value as number n then roundoff the value 
    For example if My database returns value as 21.536 it gets rounded off to 21 even if i customise Decimal n ronding off  settings in c rystal report it shows as 21.00 but not 21.536 so can u help me :)

    Thnx
    Usha
    usha
    • Edited by palepu Monday, July 7, 2008 11:25 AM error
    Monday, July 7, 2008 11:24 AM

Answers

  • In your Stored Procedure, try converting your field to "real" datatype...

    e.g.     convert ( real , Your StringField )

    I am assuming you are using SQL Server

    Jon
    • Proposed as answer by neonprimetime Monday, July 7, 2008 8:22 PM
    • Marked as answer by jack 321 Thursday, July 10, 2008 6:05 AM
    Monday, July 7, 2008 2:06 PM

All replies

  • In your Stored Procedure, try converting your field to "real" datatype...

    e.g.     convert ( real , Your StringField )

    I am assuming you are using SQL Server

    Jon
    • Proposed as answer by neonprimetime Monday, July 7, 2008 8:22 PM
    • Marked as answer by jack 321 Thursday, July 10, 2008 6:05 AM
    Monday, July 7, 2008 2:06 PM
  • Thanks Jon...!!!

    Varinder
    Varinder Sandhu
    Tuesday, March 17, 2009 7:15 AM