Unanswered: Anyone tried the HOTFIX Patch ID:37129394
Patch ID: 37129394
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.
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
For CE10, the registry key is in the following directory: HKEY_LOCAL_MACHINE\SOFTWARE\Crystal
2) Add the command "procreportoptions __noverifydatabase" in the command line of the Pageserver and Jobserver.
Note: the command "procreportoptions __noverifydatabase" has two underscores.
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..