A report that works in Crystal Reports client does not work in CMC

5 pts.
Tags:
Central Management Console
Crystal Reports XI
Oracle 10g
Primary keys
Oracle10g / Crystal Reports XIR2 / Central Management Console (CMC) Our Crystal Report fetches the last one week's data from a big table. This report runs weekly, once. To tune this report, we created another table to maintain the primary key value(numeric sequence), of the latest viewed record. Through a stored procedure, we fetch this PK Value and fetch those records , that are greater than this PK Value.Finally we update the new table to maintain the latest PK Value. Testing : Updated the PK Value maintained to a lesser value. Ran the report in Crystal Client. Records that had PK Value greater than the maintained value, were fetched and the table was updated. Updated the PK Value again to the same lesser value. Loaded the Crystal Report into CMC. Ran the report from CMC. No output records were fetched. But the maintained value was updated to the latest max value. Updated the PK Value again to the same lesser value. . Removed the updating code from the procedure and ran the report in CMC. The intended records were fetched. The maintained value was not updated (as the code has been removed now). Why does CMC behave differently? Can you suggest any workaround for this?

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following