Switching Tables in a report

[GCL2007]

I have an application where I need to report multiple versions of the same table. For example, an inventory application where I have TABLE1, TABLE2, TABLE3, TABLE4 which contain the same structure, but contain different data because of different physical inventories which may have been run. It can be a nuisance in my crystal reports if I want to substitute in a different table to recreate links, etc... I was told of an approach where I can go into SET DATASOURCE LOCATION and basically swap out tables, without rebuilding half the report. I'd replace Table1 with Table2,etc... Works great, but the tables in the report still look like they are the original table, which can be very confusing... Any thoughts on a better way to handle? Thanks

 

[hilfy]

After you finish with Set Datasource Location, the table is named with an alias of the original table name. You can go to the Database Expert and rename the table whatever you want.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.