Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
HOW I CAN MAKE REPORT USING TWO TABLES IN THE SAME DATABASE
- Thread starter PUNCHI
- Start date
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
251-621-8972
dgilsdorf@mchsi.com
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.
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.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question