Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help
Message
From
25/06/1998 15:33:09
 
 
To
25/06/1998 15:22:32
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Re: Help
Miscellaneous
Thread ID:
00111672
Message ID:
00111691
Views:
15
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform