Highlight record based on two conditions

[veles]

Hi,

I am using crystal XI and would appreciate some help.

I need to highlight a field based on two conditions.

The field is a sum of numbers (hours of employee). The employee can be with code CL or UC.

I need to highlight the hours of CL under 40hrs. I have it to highlight any hours under 40 (working OK). How to add the second condition for the highlight to look only at the CL employees.

Thanks

 

[pmax9999]

The following approach assumes the report is grouped by employee and uses a Sum type summary to total the hours.

Create the following Formula, which I have called {@HL}, which will return True or False (and replacing the field names with those from your DB):

[Code {@HL}]
{Table.Emp_Code} = 'CL' and
Sum(Table.Hours, Table.Employee) < 40
[/Code]

Then, using the Highlighting expert, set it to highlight when {@HL} = TRUE

Hope this helps

Cheers
Pete

 

[veles]

Thanks Pete,

Worked like a charm.