Combining two records into one

[harding1031]

Crystal 9.0
I am trying to display one line of detail that is originally two lines of detail in the table. All the info is the same except for the start time and stop time.
example:
Table data:
Time Oper Status Operation Code
11:00 Started PP1
11:30 Stopped PP1
12:00 Started PP3
12:30 Stopped PP3
I need the report to display like below:
Start Time Stop Time Operation Code
11:00 11:30 PP1
12:00 12:30 PP3
How can I create a report like this in CR. TIA.

 

[scottostanek]

Well you could group on the operation code "PP1" and suppress the detail line. Then make a formula field to pickup starttime and store the value if Oper Status = Started. Same with Stopped (or could be lazy and just use last instance of the Oper Status field).

Show everything in the group footer rather than detail lines.


Scotto the Unwise

 

[lbass]

Group by operation code and sort ascending on the time code. Drag the time field and the code into the group header. Create a formula {@Stopped}:

next({table.time})

Place this in the group header.

-LB