Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Crystal Reports
Message
General information
Forum:
Visual Basic
Category:
Third party products
Title:
Miscellaneous
Thread ID:
00407807
Message ID:
00407815
Views:
32
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform