Patch ID: 37129394
Description:
When users view reports on demand or schedule reports that are based on a Sybase- stored procedure, using an ODBC
custom database logon in the CMC, the stored procedure runs more than once.
New Behavior:
To fix this problem, users must install this Hot Fix patch, and then do the following:
1) Ensure the registry key "VerifyStoredProceduresOnSetLocation" is set to “No.”
For CE9, the registry key is in the following directory: HKEY_LOCAL_MACHINE\SOFTWARE\Crystal
Decisions\9.0\Crystal Reports\DatabaseOptions\
For CE10, the registry key is in the following directory: HKEY_LOCAL_MACHINE\SOFTWARE\Crystal
Decisions\10.0\Crystal Reports\DatabaseOptions\
2) Add the command "procreportoptions __noverifydatabase" in the command line of the Pageserver and Jobserver.
Note: the command "procreportoptions __noverifydatabase" has two underscores.
Known Limitations:
This fix is for the ODBC driver only.
This fix won't work for the RAS server or the Native driver
Does this problem occur in higher versions of Crystal Reports as well?
I am using Crystal 10 and i am having problem scheduling a report in CMC that has a call to the stored procedure as it exectues the stored procedure twice..