Hello Dear Babu,
Nice to meet you through this forum. I am developing some Crystal Reports in Version 8.
These are not ordinary reports where we can connect to one database from report and so on...

My problem is i have many databases, in them more than one table in each database.
R:\\2000\WM5.mdb
R:\\2001\WM5.mdb
R:\\2002\WM5.mdb and so on for each year.
I have one database of each type for every year in R drive. and i designed my reports accordiing to Client.
Now from VB 6.0 front end interface i have to select Year(2002,2003 etc) , DatabaseName and product number etc. When i click display report it has to search in the particular MDB i selected and should display corresponding data of the record(given product number).
Simply this is a Dynamic report generation.
PLease help me in doing this.
I have designed reports and GUI also.
Now i need code from which i can generate reports according to the user selection of Year, database, table name and product number.
NOTE: the database has same structure for all years.
The tables has same no.of fields and names of the fields are also same...

Thanks in advance.
Preetham