Two tables with the same structure as one.

[Former Member]

I have two tables using the same structure.  One is current data and one is archived data.  I would like to access the data in each as if it were one table.  Is there any way to do this?  I am using CR 9 but this would most likely be run using CR 2011.

Thanks,

Jim

[DellSC]

You will need to either create a view in the database that will UNION the two tables together or create a command in your report to do the UNION.  If you use a command, you should add ALL of the data that you need for the report and do the filtering in the "where" clause of the command - there will be a big performance hit if you don't because Crystal will pull all of the data into memory and join/filter it there instead of pushing that work to the database.

-Dell