HOW I CAN MAKE REPORT USING TWO TABLES IN THE SAME DATABASE

[PUNCHI]

HELLO
HOW I CAN CREATE A REPORT USING TWO SEPERATE TABLES IN THE SAME DATABASE
THANKS

 

[dgillz]

Select both tables, and then link them. If yu have a report with only one table and want to add another table to it click on database, add database to report, then browse to it and add it. You will go into the visual linking expert to link the two tables. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[IdoMillet]

Sounds like you want to use the data from the 2nd table as if it was appended into the same table.

If that is the case, you can create a VIEW (Query in MS Access) or use Crystal SQL Designer as the data source with a UNION select statement:
---------------------------------
SELECT ... FROM TABLE1
UNION ALL
SELECT ... FROM TABLE2
---------------------------------

hth,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com