Skip to Content
avatar image
Former Member

Moving Command table from one region to another identical region

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 22, 2008 at 04:21 PM

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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Kyle,

      Thanks Kyle,

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

      I appreciate your reply.

      Thanks,

      The Panda