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!

creating a report with 4 queries

Status
Not open for further replies.

jlockwoo

MIS
Mar 21, 2001
2
US
I need to create a report based on a 1 master query which calls 3 queries for each master record. Has anyone done this before?
 
You would probably be better off using a stored procedure that returns the result table for CR. CR can report off of an SP.

Crystal itself, can only read one set of directly linked tables per report. You could use subreports, but the performance would be much poorer. Ken Hamady
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top