How to Set the Database to the Crystal Report at runtime [ RESOLVED ]

[satyarao]

Hai,

I am working with Crystal Reports 8.5, VB6.0 with MsAccess2000 database.

I am having the database in various folders (namely FR03, FR04 etc.....)

I want to call the reports from the choosen folder's database only... here in all folders the databases are identical... with the same sturcutes... and same no. of and same type of tables....

while designing the report i have used some DSN based on one folder... and at runtime how can i change to required folder's databse... since there are no. of folders and databases... it is not possible to create that many no. of DSNs...(since those folders and their databases are created at runtime only)

I think it is clear... if not plz inform me... to get it more clear

thanks in advance...

[Ken Bradford]

Look at http://support.crystaldecisions.com/...8-ocxtordc.pdf for both ocx and rdc examples.

[satyarao]

hai...

I got the solution to my problem.. @

http://p2p.wrox.com/archive/crystal_reports/2002-08/

thank you for responders...