Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to include data from multiple tables in a report...
Message
De
05/07/2000 17:21:05
 
 
À
05/07/2000 17:04:03
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00388552
Message ID:
00388557
Vues:
9
I can suggest 2 options:

1) Put all of the required tables in the DataEnvironment of the report and link them together like you would in the view designer.

2) Execute a sql select that joins all of the tables together and selects the required fields prior to designing and printing the report.

>Hi Guys
>Seeing as there is no way to reliably print ???, ?/?? reports on a network in VFP, I will have to beg advice on how to get the data from a number of tables onto one report. I am trying to build an invoice that gets data from a number of tables ie: labor, parts, flatrates, etc, and get them all into their own 'groups' on the report. With ?/?? it is simple, but in report designer there is only 1 'details' band, so how the hell do you get it all to come out legibly??
>Your assistance is most appreciated!
Thanks,
Dan Jurden
djurden@outlook.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform