Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Teach me, oh wise ones!
Message
De
04/10/1999 22:51:01
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00272552
Message ID:
00272553
Vues:
31
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?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform