September 26, 2013 at 4:35 am
Hi Please find the attached snapshot for SSRS Custom Number format issue.
I am using as Number format :- #,##0.00%;(#,##0.00%)
Font Format :- IIF(ReportItems!txtBox4.Value < 0 "Red" , "Black")
But the result is coming with 0.00% as 3 type Black, Red(Without bracket) and Red(with bracket)
Can you please let me know how #,##0.00%;(#,##0.00%) work ?
______________________________________________________________________
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.”
September 26, 2013 at 4:38 am
The red within a bracket is negative, so that one is correct.
The 0.00% without bracket is maybe slightly below zero, but it is rounded to zero by SSRS?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 26, 2013 at 6:00 am
for testing, why not increase the decimal places in your format string to see what numbers you're dealing with (and therefore why you're getting the styles applied). alternatively, just add another column to show the true numbers and remove it afterwards. Saves you from guessing...
Steve.
September 27, 2013 at 8:29 am
In the Color property of your text box, not in the Format property.
Please add your expression to the Color property of the text box, something like this
=IIF(ReportItems!Textbox15.Value < .05, "Red", "Blue")
hth
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply