Change Font to RED Using FORMAT function and NOT changing FONT property

• syedathariqbal

  Hall of Fame

  Points: 3175

  More actions

  December 17, 2015 at 1:27 am

  #310275

  Hi All,

  I was creating a report and that stanadard requirements, to show negative numbers in Brackets and Red Color. This can be done and is fine.

  I was wondering if this can be done in Expressions only at 1 place, i.e. in Values and not required to change the FONT property.

  Something similar to excel. If I put below code in Excel it will not only put brackets for negative numburs but also change color to Red.

  #,###.#0_);[Red](#,###.#0)

  Can something similar be done in SSRS ? If so, I would have to do the change only at 1 place and would not have to be bothered to go in FONTS tab and do the check IF(Fields!name.value>0,"Red",nothing) etc

  Thanks in advance

• pietlinden

  SSC Guru

  Points: 63503

  More actions

  December 18, 2015 at 3:23 pm

  #1846891

  Can't you just change the font color property value to an expression?

• syedathariqbal

  Hall of Fame

  Points: 3175

  More actions

  December 19, 2015 at 10:31 pm

  #1846955

  Yes, thats how it should be. My supervisor is asking if its possible not to put the expressions only in 1 place (for Values) and not in Fonts.... 🙂

  And he reasons...If it can be done in Excel, there should be something similar in SSRS also.

  In Excel....If we put below as in Custom Format

  #,###.#0_);[Red](#,###.#0)

  Then negative numbers automatically gets a bracket and Red color font also.

  Anyways, I know now it can't be done. :w00t:

• pietlinden

  SSC Guru

  Points: 63503

  More actions

  December 20, 2015 at 4:51 pm

  #1847018

  Faulty reasoning on his part in my opinion. They're just different.