I have a details report that would run on multiple records and display output. For example I have 3 records and the report will display output of 3 pages ( 1 record per page). We have a logic to change the color of a row conditionally as follows,
| Record | Part Number | Status | Color |
|---|---|---|---|
| One | 12345 | SERVICABLE | Yellow |
| Two | 56789 | UNSERVICABLE | Red |
| Three | 10111 | REPAIR | Green |
Based on the Part number and status the color of the row should change. I tried to achieve this using Highlights option however I’m able to pass only the status column hence when the report runs for all the 3 records the color remains the same for all the 3 records though the status is DIFFERENT. I have observed that the report displays the logic based on the STATUS of the first row only. I’m not sure on how to pass the part number because it is unique for each row hence we need to build a logic to use part number and status combination.