Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, July 25, 2014 10:05 AM
Points: 122, Visits: 292
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 , [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.


______________________________________________________________________

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

Add to briefcase

Permissions Expand / Collapse