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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to view more than one table

Status
Not open for further replies.

SLM2004

Programmer
Feb 12, 2004
1
FR
Hello
I'm new in Crystal Reports development .
I want to see the content of 5 (unlinked) tables using Crystal Reports.
All seems to be good but when i open CR, i just see the content of 1 table !!!
Any idea ?
Thanks
 
Crystal works on one table per report, so your request is handled using subreports, or if they are of similar structure, and you have a database capable of it, you might be able to use a Union query to create one row set, if that might meet your needs.

This is also Crystal version dependent, which you should include when posting.

-k
 
SLM2004

When you say that the tables are unlinked, do you mean they have no fields which are related (eg Account_No appears on 2 or more of the tables)?

If the tables cannot be linked then I would suggest you follow synapse's suggestion of subreports. This would require a main report and 4 subreports.

Good luck
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top