on 10-15-2008 3:37 PM
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
Create two different Data Connections, update the connections, instead of the command objects themselves, in the "Set Datasource Location" area.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.