Find record ID's based on a selection and re-use them in another selec 1

[BobHorne2]

I need to produce a report in Crystal v 7.0 that first of all selects record ID's based on a date range, and then uses those ID's as the basis of another report that shows unrestricted date data against those ID's

ie. Select contract data for contracts with hours booked against then for last week, and then use the selected Contract ID's to report all hours todate on the contracts.

Any ideas, thanks in advance for any suggestions

 

[IdoMillet]

You could probably do this with SQL, but it may be simpler to use a linked subreport approach.

Cheers,
- Ido ixm7@psu.edu