General information
Category:
Reports & Report designer
I'll give it a try thanks Fred.!!
>>>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only