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?