Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Teach me, oh wise ones!
Message
From
04/10/1999 22:51:01
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00272552
Message ID:
00272553
Views:
30
Hi Phil,

>I am trying to design an report that uses informtion from three tables (calibration master, calibration details and calibration companies). I tried the obvious approach and added all three tables to the dataenvironment, and the persistent relationships (as defined in the dbc) were showing. But when I preview the report, I am unsuccessful in making all three tables move together.

This is how its usually done:

1. Create a temporary Cursor like this:
SELECT Master.pk, Child.fk ;
   from master left join child on master.pk = child.fk ;
   into cursor 'temp'
Obviously this will need to be modified and more complicated, but its the thoery here.

2. Create your report with expressions PK and FK (no aliases) and remove all the tables from your DE.

3. Select your cursor and run the report.

Will this help?
Previous
Reply
Map
View

Click here to load this message in the networking platform