Using Multiple Access Tables

[redboan]

Hello all,

I am new to Crystal Reports and have encountered a problem. I have 14 tables in Access that I need to use. I have put the first table into Crystal flawlessly. However, I need the report to be continuous with all 14 tables. Grouping has not worked for me, but I do need the same layout (using one group only) for all 14. Basically, I need 14 separate reports in one, but all being continuous.

Any suggestions would be AWESOME!

Thanks,
adrian

[V361]

Can you create a view in access to combine the 14 tables ?, if not,
you may need to look into making subreports. Copy your current report, and paste with new name, open new name, you should be able to insert a subreport (using the old file name), then all you will need to do, is modify the connections to point to the different Access Tables. (A View would be much better, if you can pull that off)

Do you have a common data element to all 14 tables ?, if not, you will have trouble trying to link those tables. Good Luck