Report having data from multiple tables?

[vnk]

Hi All,

Can we have a report displaying the data from multiple
tables (All the tables have same columns).

I want the report in the following format:

Data from first table grouped by one of the column
Data from second table grouped by same column
Data from third table grouped by the same column.

Please help me.
Thanks In Advance,
VNK.

 

[IdoMillet]

If you want to combine the data and treat it as if it came from a single table, create a UNION query in Crystal SQL Designer (or a VIEW/Query in the database) to act as the data source for your report.

If you want to show the data in 3 consecutive sections,
you can use subreports.

Cheers,
- Ido ixm7@psu.edu