Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Help
Message
De
25/06/1998 15:33:09
 
 
À
25/06/1998 15:22:32
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Re: Help
Divers
Thread ID:
00111672
Message ID:
00111691
Vues:
14
>>Hi Sergio,
>>How many tables are you trying to use for this report?
>I'm using two tables.
>
>Each table represents an expense account, similar structure, both have to print on the same page.
>
>Thanks for your response.

Try:

SELECT *,1 AS TabNum ;
FROM table1 ;
UNION ALL ;
(SELECT *,2 AS TabNum ;
FROM table2) ;
UNION ALL ;
(SELECT *, 3 AS TabNum ;
FROM table3) ;
ORDER BY TabNum ;
INTO CURSOR alltable

Now do your report using "alltable" cursor and group as needed.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform