SSRS Field Expression to change the background color of the Cell

Question

I m trying to write a field expression for a Cell in my report where I have to change the background color of the cell depending on the string value in the cell  Ex  if the column has a value  Approved  in it  the cell should show a green background color  I tried the following     IIF fields column value    Approved    Green     and    IIF Fields column Value   Approved    Green     Neither works   I know i m missing something in the syntax   Probably I m not refering green to the back ground color in the syntax  Please help

User · Accepted Answer

The problem with IIF Fields column Value    Approved    Green   is that you are missing the third parameter  The correct syntax is IIF   some boolean expression    result if boolean expression is true    result if boolean is false    Try this   IIF Fields Column Value    Approved    Green    No Color     Here is a list of expression examples Expression Examples in Reporting Services

User · Answer

IIF Fields ADPAction Value ToString   ToUpper   Contains  FAIL    Red   White    Also need to convert to upper case for comparision is binary test

User · Answer

Make use of using the Color and Backcolor Properties to write Expressions for your query  Add the following to the expression option for the color property that you want to cater for   Example   iif fields column value    Approved    Green    lt other color gt      iif needs 3 values  first the relating Column  then the second is to handle the True and the third is to handle the False for the iif statement

User · Answer

IIF fields column value  Condition  Red   Black

User · Answer

IIF Fields Column Value    quot Approved quot    quot Green quot    quot No Color quot

User · Answer

You can use SWITCH   function to evaluate multiple criteria to color the cell  The node  lt BackgroundColor gt  is the cell fill   lt Color gt  is font color   Expression    SWITCH                Fields Usage Date Value Contains  TOTAL            AND  Fields User Name Value Contains  TOTAL            Black                 Fields Usage Date Value Contains  TOTAL            AND NOT Fields User Name Value Contains  TOTAL             595959                 NOT Fields Usage Date Value Contains  TOTAL             AND Fields User Name Value Contains  TOTAL            AND Fields OLAP Cube Value Contains  TOTAL             c65911                 NOT Fields Usage Date Value Contains  TOTAL             AND Fields User Name Value Contains  TOTAL            AND NOT Fields OLAP Cube Value Contains  TOTAL              ed7d31       true    e7e6e6          Daily Totals    CellFill  amp  Dark Orange -  c65911   TextBold  amp  True  Daily Totals    CellFill  amp  Dark Orange -  c65911   TextBold  amp  True   Daily Cube Totals    CellFill  amp  Medium Orange -  eb6e19   Daily User List    CellFill  amp  Light Grey -  e7e6e6   Date Totals All Users Total    CellFill  amp  Black -  black    TextColor  amp  Light Orange -  ed7d31   Date Totals Per User    CellFill  amp  Dark Grey -  595959   TextColor  amp  Yellow -  yellow     ALL OTHER CONDITIONS   Daily User List    CellFill  amp  Light Grey -  e7e6e6    XML node in report definition file  SSRS-2016   VS-2015                     lt TablixRow gt                     lt Height gt 0 2in lt  Height gt                     lt TablixCells gt                       lt TablixCell gt                         lt CellContents gt                           lt Textbox Name  Usage Date1  gt                             lt CanGrow gt true lt  CanGrow gt                             lt KeepTogether gt true lt  KeepTogether gt                             lt Paragraphs gt                               lt Paragraph gt                                 lt TextRuns gt                                   lt TextRun gt                                     lt Value gt  Fields Usage Date Value lt  Value gt                                     lt Style gt                                       lt FontSize gt 8pt lt  FontSize gt                                       lt FontWeight gt  SWITCH                NOT Fields Usage Date Value Contains  TOTAL             AND Fields User Name Value Contains  TOTAL            AND Fields OLAP Cube Value Contains  TOTAL            Bold       true   Normal        lt  FontWeight gt                                       lt Color gt  SWITCH                Fields Usage Date Value Contains  TOTAL            AND  Fields User Name Value Contains  TOTAL             ed7d31                 Fields Usage Date Value Contains  TOTAL            AND NOT Fields User Name Value Contains  TOTAL            Yellow                 NOT Fields Usage Date Value Contains  TOTAL             AND Fields User Name Value Contains  TOTAL            AND Fields OLAP Cube Value Contains  TOTAL            Black                 NOT Fields Usage Date Value Contains  TOTAL             AND Fields User Name Value Contains  TOTAL            AND NOT Fields OLAP Cube Value Contains  TOTAL             Black       true   Black          Daily Totals    CellFill  amp amp  Dark Orange -  c65911   TextBold  amp amp  True  Daily Totals    CellFill  amp amp  Dark Orange -  c65911   TextBold  amp amp  True   Daily Cube Totals    CellFill  amp amp  Medium Orange -  eb6e19   Daily User List    CellFill  amp amp  Light Grey -  e7e6e6   Date Totals All Users Total    CellFill  amp amp  Black -  black    TextColor  amp amp  Light Orange -  ed7d31   Date Totals Per User    CellFill  amp amp  Dark Grey -  595959   TextColor  amp amp  Yellow -  yellow     ALL OTHER CONDITIONS   Daily User List    CellFill  amp amp  Light Grey -  e7e6e6  lt  Color gt                                     lt  Style gt                                   lt  TextRun gt                                 lt  TextRuns gt                                 lt Style   gt                               lt  Paragraph gt                             lt  Paragraphs gt                             lt rd DefaultName gt Usage Date1 lt  rd DefaultName gt                             lt Style gt                               lt Border gt                                 lt Color gt LightGrey lt  Color gt                                 lt Style gt Solid lt  Style gt                               lt  Border gt                               lt BackgroundColor gt  SWITCH                Fields Usage Date Value Contains  TOTAL            AND  Fields User Name Value Contains  TOTAL            Black                 Fields Usage Date Value Contains  TOTAL            AND NOT Fields User Name Value Contains  TOTAL             595959                 NOT Fields Usage Date Value Contains  TOTAL             AND Fields User Name Value Contains  TOTAL            AND Fields OLAP Cube Value Contains  TOTAL             c65911                 NOT Fields Usage Date Value Contains  TOTAL             AND Fields User Name Value Contains  TOTAL            AND NOT Fields OLAP Cube Value Contains  TOTAL              ed7d31       true    e7e6e6          Daily Totals    CellFill  amp amp  Dark Orange -  c65911   TextBold  amp amp  True  Daily Totals    CellFill  amp amp  Dark Orange -  c65911   TextBold  amp amp  True   Daily Cube Totals    CellFill  amp amp  Medium Orange -  eb6e19   Daily User List    CellFill  amp amp  Light Grey -  e7e6e6   Date Totals All Users Total    CellFill  amp amp  Black -  black    TextColor  amp amp  Light Orange -  ed7d31   Date Totals Per User    CellFill  amp amp  Dark Grey -  595959   TextColor  amp amp  Yellow -  yellow     ALL OTHER CONDITIONS   Daily User List    CellFill  amp amp  Light Grey -  e7e6e6  lt  BackgroundColor gt                               lt PaddingLeft gt 2pt lt  PaddingLeft gt                               lt PaddingRight gt 2pt lt  PaddingRight gt                             lt  Style gt                           lt  Textbox gt                           lt rd Selected gt true lt  rd Selected gt                         lt  CellContents gt                       lt  TablixCell gt

[reporting-services] SSRS Field Expression to change the background color of the Cell

Examples related to reporting-services

Examples related to field

Examples related to cell

Examples related to background-color

Examples related to ssrs-expression