Suppress/Exclude records in another group ?

[AussieLad]

We have a report that extracts stats from our Document M'ment system. An incoming document is assigned to a Workflow... within the workflow, there are various stages, called "Tasks". (eg, If a document if not actioned within 7 days, it moves from a "Due for Action" to an "Overdue" Task).
My report is grouped by User, Workflow, then Task. The details section displays Document No, Task_Id, Orig_Task_ID, Task Status, ("A"ctive or "C"ompleted).
(n.b. When a Task moves from "Due" to "Overdue", the "Overdue" Task gets a new 'Task_Id', & displays the original Task_Id in the 'Orig_Task_ID' field).
What I want is to prevent the tasks that have moved from "Due" to "Overdue" from appearing in the "Due" Group. They currently appear in both. This then gives inflated "Due" stats when a count, (& percentage), of Due-vs-Overdue Tasks is done.
(I hope I have offered enough group/field info for someone to help me... if not, I may have to go into detail about the four tables used... gasp !)

 

[Madawc]

In Crystal 8.5, one possible solution is to include a table twice, the second time as an 'alias'. If you do a left-outer join from 'Task_Id' to 'Orig_Task_ID', this should let you weed out all cases that are now overdue. It should be possible to do this in record selection, even.

Madawc Williams
East Anglia, Great Britain