Auto-update table reference?

[shannonlp]

I have a report that connects to a structure that contains 2006 and 2007 data. In December 2006 the report retrieved 2006 data. In January 2007, the 2006 data was archived to a different table. Specifically, in 2006 the table the report referenced was EXPDIST_INV. The 2006 data has since been moved to a table called EXPDIST_INV_PYR. The structure of the two tables is identical and I need to run reports for 2006 data.

My question is whether there is a process within Crystal that will automatically update the fields on the 2006 report to reference the EXPDIST_INV_PYR table.

Crystal XI/Oracle 9i.

Thanks for any help.

 

[synapsevampire]

Use Database->Set Location to repoint to another table.

-k

 

[shannonlp]

Great - thanks.