Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Highlight record based on two conditions

Status
Not open for further replies.

veles

Technical User
Sep 1, 2006
57
CA
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
 
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
 
Thanks Pete,

Worked like a charm.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top