Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SSRS - Number formatting Expand / Collapse
Posted Monday, September 23, 2013 7:19 AM


Group: General Forum Members
Last Login: Wednesday, March 18, 2015 3:05 AM
Points: 123, Visits: 299

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 , [color=#FF0000](0.00)[/color],[color=#FF0000]0.00[/color]

I am unable to understand why [color=#FF0000]0.00[/color] are coming.

Please suggest.


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.”
Post #1497376
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse