changing Tables: URGENT!!!

[sslevy]

Hi,

I was doing reports on one table our helpdesk table
now i have to switch the table name to our archive help desk form. Basically both tables are exactly the same except for the name. Is there someway to switch to the new table without wiping out all of what i have done already and having to redo all the reports.

Also is there a back way to do this?
URGENT

Thanks.
Shari Levy
slevy@net2phone.com

 

[tancan74]

Have you tried going into the Database drop down, and selecting "Set Location" and then directing Crystal to your new table?

 

[sslevy]

I have done this. How can i verify that it's pulling from the new table instead of the old one?

 

[tancan74]

Do both the old table and the table you are pulling in have the same number of records? That is normally how I double check.

 

[lalato]

You might also verify that the location is set by checking the SQL statement. Go to Database/Show SQL Query...

--sam

 

[sslevy]

the new form will have all records. the old one will only have currently open records.

is there a way to see which database it's pulling from..Like a field it can print or some way to look it up?

 

[tancan74]

I know that if you just open the Database - Set Location that it will show you in the bottom will show you where from and what table it is pulling data from. Hope that helps.

Tanya