I have this report where i have the fields DataFeedCode,Frequency,ArrivalDate and ArrivalDay. I have a parameter on Datafeedcode. And what i want to acheive in this is if the particular datafeedcode didnot arrival on the particular ArrivalDay it has to be hihlighted in Red.

 

i.e. Example: Datafeedcode: ABC ArrivalDate: 05/04/2010 ArrivalDay: Tuesday. Expected arrival for ABC was on Monday. HOw would i write a condition so that it highlights the fields based on the user selecton. I have a formula written under Format color for each field saying the following

If  {?clientcode} = {ClientFileInfo.DataFeedCode} and {Data_Feed_Lookup.Frequency} = 'MONTHLY' and {@Expected Arrival} <> 1 then (CrRed)

..Can anyone help with the idea of how to move ahead.

 

Thanks