The background color changes when the report field contains "Pass"

Xiaowen Dong 80 Reputation points

I created a report. There are fields such as ID, Name, description, etc. I want the row background to change yellow when the description field contains "Pass".


SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,555 questions
{count} votes

Accepted answer
  1. AniyaTang-MSFT 9,681 Reputation points Microsoft Vendor

    Hi @Xiaowen Dong

    You can try using the Instr function. The Instr function returns an integer specifying the starting position of the first occurrence of a string in another string.

    I did a simple test, select the data row of the table. Then set the expression for BackgroundColor in the property.

    Screenshot 2023-08-31 133153


    Screenshot 2023-08-31 133338

    Best regards,


    0 comments No comments

0 additional answers

Sort by: Most helpful