Pulling Group of Records when one record is found

[YANKRAY]

Using CR9.0

Trying to create a report that will give Employee time charges if a particular record is found. Example:

EMPLOYEE: SMITH DATE: 10/04/2004

WORK ORDER START FINISH HOURS
0005 7:00 8:00 1.0
0004 8:00 9:30 1.5
9090 9:30 10:00 .5
0010 10:00 15:30 5.0

When I select a date I am trying to get in my result only the Employees with charges to WORK ORDER 9090, but if there is a WORK ORDER 9090 charge, I want all the records for that day to also show.

Is there a formula ro parameter that will work?

 

[synapsevampire]

Group by Employee.

In the Report->Edit Selection Formula->Group place the following

(If this is the maximum value that a workorder might hold, it real easy):

maximum({table.workorder}) = 9090

Otherwise you might creata a count for each employee using a formula:

if {table.workorder} = 9090 then
1
else
0

Then in the group selection formula use:

sum(@9090formula,{employee}) > 0

Should work...

-k