Post reply

Help! decimal format - trailing 0?

  • August 3, 2006 at 9:36 am

    #173663

    Hi all,

    I got a strange problem, I can't get the trailing 0 disappeared.

    The column has decimal 5(8,4) datatype in MSSQL server.  I formatted the field to #######0.#### in Reporting services. (Right click the field in design ->properties->select custom -> type #######0.####)

    But still if the value is 0, it displays as 0.0000.  What else I can do to display just 0? 

    By the way, this might be irrelevant, in Enterprise manager it displays as 0, in Query analyzer it displays .0000.

    Your help is highly appreciated,

  • August 7, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • August 7, 2006 at 11:25 am

    #653691

    Never mind, I need to change my stored procedure and the value now is formatted as ########0.#####.  The resulkts is looking fine.

    Thank you very much,

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply