Share via

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

Xiaowen Dong 100 Reputation points
2023-08-30T14:12:35.8566667+00:00

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

Thanks!

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,969 questions
Accepted answer
  1. AniyaTang-MSFT 12,446 Reputation points Microsoft Vendor
    2023-08-31T05:34:25.05+00:00

    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

    Preview:

    Screenshot 2023-08-31 133338

    Best regards,

    Aniya

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.