06-08-2001, 03:12 AM
Crystal Report Problem
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
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.