SSRS - Number formatting

  • Hi,

    I am using the following

    custom format "#,##0.00% ;(#,##0.00%)" in my SSRS numeric column

    and Color code :- IIF(COl.value < 0 , "Red" , "Black"

    However, When the data is displayed

    so values are 0.00 , (0.00),0.00

    I am unable to understand why 0.00 are coming.

    Please suggest.

    ______________________________________________________________________

    Ankit
    MCITP Database developer SQL 2008,MCTS Database Administration SQL 2008
    "Remembering that you are going to die is the best way I know to avoid the trap of thinking you have something to lose.
    You are already naked. There is no reason not to follow your heart.”

Viewing 0 posts

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