Infoshare

Is there any way to change table name dynamically in Crystal Report.

I am backing up the daily transactions of a company in a
database 'transactions'. The program is written to backup the data
to a table (say 05-01 for May 2001, 06-01 for June 2001 etc).

These tables were already not created, at the time of backup, the program
checks if there is a month table. If it's found, program writes
data to that table, otherwise create a table using the month and year code.

To build the reports from the backup I had designed a report with an
existing table (for eg. 05-01) in crystal report. At runtime this is
enough for the month May.

The problem is that, I can't access the data from the tables which are
created after the designing of report (for eg. 06-01). How can we
build a report from the table, which is not inserted in the table at
design time.

Can we solve this problem with an 'alias' of the table?

I am using Crystal Report 4.6, MS Access 97 and VB 5.0.


Pls help...