Adding several databases to a crystal report

SwoI2D
SwoI2D used Ask the Experts™
on
Hello.

I'm developing an application that creates an access database for each month, like Nov-2002.mdb, Dec-2002.mdb, Jan-2003.mdb ...

I've created a Crystal report to display data on first database, but how can i add 2,3,4 or any databases to the report?

All databases have same field names and tables.

Like if i want to show data from october to december, i'll get all records from Oct-2002.mdb, then all from nov-2002.mdb and dec-2002.mdb.

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
Any particular reason for using separate databases rather than different tables?

Do you want to be able to do this on the fly or could you create a separate database with links to the others and create queries that get the information you want?

mlmcc

Author

Commented:
I could use tables instead of databases too.

And i think creating a separate database will be slower, this reports will be printed every month, the info by month is from 600 to 1000 records.

But u tell me what u think its better? and how to do it please.

Thanks

Author

Commented:
I've been thinking and i prefer different databases for each month, becouse if i use tables and database crash, i would lost everything, and the other way its one month.

Author

Commented:
can i use report.database.setdatasource ... to set the path and name of the database?

like

report.database.setdatasource "c:\databases\F-Nov-2002.mdb"

any ideas?

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial