SSRS Parent Column Background Color same as Details Row

Question

I have a report with one parent group and an expandable details group. My issue is that I would like the parent cell to have the same background color as that of the details row if any of the details rows has color.

For example: If I have a parent group of PART ID and details rows that contain columns for location and qty. If any of the qtys are below zero then I have a background color expression to set the qty field for that row to a background color of RED. I need the parent PART ID to also be red if any of the details rows are red.

I can't seem to find a solution to this issue on the web and everything I search only seems to return results about background colors for alternating columns which is not at all what I need. Your assistance is appreciated

Answer 1

There's not any kind of function for this. You would need logic based on how your data and report work. Maybe something like:

=IIF(SUM(IIF(FIELDS!QTY.VALUE < 0, 1, 0)) > 0, "RED", "WHITE")

If any of the QTYs are less than 0, then Red ELSE White.