odbc data question CR 11 1

[mawh]

I use CR 11 with MS ODBC for Visual Fox Pro.
I have 3 different databases against which I need the same format. For example, one report runs against a table called arcust02 from datasource data02. The format of the elements in the table are arcust02.custno; arcust02.company etc.

I need to run the same report against arcust01 from datasource data01 which has the same layout as arcust02. I do not want to rewrite any reports which fall into this category. How can I change the reports to access a different datasource without rewriting the reports?

Thanks in advance for any help.

 

[synapsevampire]

Save the report under another name and use Database->Set Location and point to the other database.

-k

 

[mawh]

That works - the only gotcha is that when I change the datasource from data02 to data01 and then the table arcust02 to arcust01 - it keeps the name of the table to arcust02 but if you click properties, it says it is arcust01 from data01. I'm sure this will confuse me one day or confuse someone who works with the reports other than me, but for now, it meets my objective. Thanks.

 

[synapsevampire]

Highlight the table and select F2 or right click it and select rename and change the name.

-k

 

[mawh]

You have saved me hours of work. Many thanks.