Highlight whole row in a crosstab based on non crosstab info

[Lucy_G]

Hi!
Using crystal reports 2020, patch 8.
I have a crosstab that has several rows: case #, client name, client id, sample id.
Two summarized fields: mode of Result and mode of Numeric Result.
1 column for Test Name.

Some cases use up to 4 tests, some just 1 so I have blank cells here and there.

For results, folks enter "positive" or "virus detected" or whatever sounds good at the moment so I have another field that is not in the crosstab that categorizes positives into a value called OOS-A.

I want/need to highlight the whole row when any of the results are categorized as positive, or RESULTS.S='OOS-A'.
I have spent the last few hours trying everything I can think of but nothing is working. I can't use the numeric result as a guide because for different tests, there are different ranges that indicate a positive. If I include the RESULTS.S field in the crosstab, it creates multiple rows and the user does not want that. She wants one row per sample with the 1 to 5 tests as their own columns.
I thought a crosstab would work but starting to think it'll be a slow painful death if I keep going this way. Does anyone have any advice on highlighting the row if one of the results is categorized as positive?
Attaching a sample of what end result needs to look like.
Any help is extremely appreciated
Lucy

 

[pmax9999]

Welcome to Tek Tips Lucy.

Are you using an 'actual' Cross Tab, or a 'Manual' Cross Tab?

The screen shot doesn't look like a real Cross Tab.

It is time consuming to set up data so I can recreate the same format for testing my approach. Happy to have a look at it if you are prepared to upload the report file with saved data (de-identified if applicable).

Cheers
Pete.

 

[Lucy_G]

Hi Pete!
I was trying to use an actual crosstab but ended up making a manual one that worked like a charm. The screenshot was only meant to show what I needed the end product to look like, sorry about that.

Lucy