Using "Set Datasource Location" with COMMANDS

building reports crystal reports
1

CR-XI (R2)
ORACLE 10g

We are retiring one Oracle database - and bringing another one on-line. They each have different TNS names.

I have been asked to take a quick look at some of the RPTs against the new old database, and confirm they will run OK against the new database.

Most of these RPTs are based on the CR-XI “COMMAND” function. I experience an issue when I try to point the existing COMMAND to the new location using the “Set Datasource Location” function.

I can create new RPTs against the COMMAND the new database - so I know it is not a connectivity/SQL issue…but I can’t update the old existing RPTs using the “Set Datasource Location” function in CR-XI to move the COMMAND.

I highlight the Table/Command in the upper “Current Data Source” section (which shows the OLD db name), and “Add Command” in the lower “Replace with:” section (under the NEW db name).

When I click on “Update”, the “Add Command To Report” window opens and I enter my valid SQL (works OK on new RPTs).

Then I click OK…

…and NOTHING happens…

…No Error…

…No Change to the upper “Current Data Source” section…

NOTHING.

Anyone had this issue before…?

I can only assume I am missing a step somewhere, but not sure where.

Thanks in Advance for the Help!

MJRBIM :canada: (BOB member since 2007-03-23)

2

Hi,
I feel your pain.
When I was doing something similar, Business Objects advised us to add all the new commands to the repository and then do the update.
Mind you there are issues with this if you want to have dynamic cascading parameters referenced in your command.
Cheers,
BatCat

BatCat :uk: (BOB member since 2004-05-18)

3

Found a work-around posted on Tek-Tips…

MJRBIM :canada: (BOB member since 2007-03-23)

4

Hi,
we have an application where we can upload crystal reports developed on Views. This application does not support stored proc so we migrated all report from stored proc
to views.
Now there are some reports whose veiw cant be designed and we can not use SP.
Is there a way with which i click on run report after passing parameter which will generate
a view or table required to generate the report.

–how can we use commands to do that
–or by some trigger mechanism . is it possinle.

Kindly let me know ASAP.

Thanks in Advance

BOBisMYjob (BOB member since 2009-01-08)