SQL Command not running in CMC

[former_member675883]

I designed a CR with two SQL Commands (not in the repository) to select different page headers in the report.
When I preview the report from the designer the commands are executed and report works as ecpected.

When I upload the report to the server aus use CMC to preview it, the reportdoes not run.

Without SQL Commands report is running well from CMC

[venkateswaran_k · Accepted solution]

Dear Linus

Perform / Check the following

1. Go to the Folders Management in CMC

2. Select your report object

3. Select Manage -> Database settings

4. In the Default settings box, - select Database configuration

5. Perform the database settings (as defined in CMC) - i) either the same database settings as in crystal report or ii) other database settings defined in CMC

6. Save and Close

Then run your report.

Regards,

Venkat

[DellSC]

Did you configure the data source(s) in the report's "Database Configuration" in the CMC? When you're developing the report, are you connected to the same database as your BOBJ system connects to when running the report? Do your commands have parameters? If so, are they dynamic? Have you read this blog about working with commands?

-Dell