>I don't know if there is a better resource for asking crystal reports questions b/c there website didn't help me but if there is a place point me in that direction. Anyhow my wuestion is this. I have a report that displays a record from a requests table (Employee, Course Requested, Approx. Delivery Date) what I need to do is retrieve a value for each of these records from a rates table. The rates table is as follows:
>
>ID CourseID StartDate EndDate CostperPerson
>-- -------- --------- ------- -------------
>01 04 1/1/2000 06/31/2000 $5800
>02 04 7/1/2000 12/31/2000 $6200
>03 05 1/1/2000 06/31/2000 $4800
>04 05 7/1/2000 12/31/2000 $5200
>
>
>My problem is how do I, for each request, retrieve the appropriate value from this table in the crystal reports designer.
From Crystal Report, open the Reports menu and choose the Report Expert option. You will be able to add tables and link tables.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com