SSRS Number - Custom Format Issue

• SQL_By_Chance

  Hall of Fame

  Points: 3915

  More actions

  September 26, 2013 at 4:17 am

  #395561

  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.”

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  September 26, 2013 at 4:39 am

  #1653488

  Please do not crosspost. It wastes peoples time and fragments replies.

  Original thread can be found here:

  http://www.sqlservercentral.com/Forums/Topic1498757-147-1.aspx

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP