Changing table background color based upon data value

rbguy

Hello,
I thought I could figure this one out but nothing seems to work. I want a dynamic report where a table of data elements changes based upon the value of one of those data elements.

For example, I have a report with a parameter job number. Once the user selects the job number the report displays a table with information about that job. One data element for each job is a status. If the status is ?Complete? I want the table to show green, if the status ?Not Complete? then the table should be yellow.

Any suggestions on how I would go about accomplishing this?
Thanks.

kclark

You should be able to do this from the highlights tab. Click on the row of your table > property editor > highlights > add. From here you can add an expression to say something like

if(row["SOMEROW"] == "Some Data")

Then you can choose what highlight color you need if it matches.