Moving Command table from one region to another identical region

[Former Member]

Crystal 11, Windows , DB2

I've got a report with a query in the Command table.

I want to run that report on a different region that is identical.

I changed the query to point to the different region, but it won't see it,

I guess because the command table was originally created under the

other region.

The query runs fine in the builder, but Crystal doesn't recognize it.

Ideally, I'd create the query in a Command table under the other region

and then point to that in "Set Database Location", but Command table

only opens inside a report.

Views are not an option.

For instance, the first region is :

TNDB2S and the second is TNDB2T

Any ideas ?

Thanks,

The Panda

[kyle_mcadam · Accepted solution]

Create two different Data Connections, update the connections, instead of the command objects themselves, in the "Set Datasource Location" area.

[Former Member · Accepted solution]

Kyle,

Thanks Kyle,

Actually, views became an option, so we're going that way.

I appreciate your reply.

Thanks,

The Panda