Crystal Report parameter mismatch

Modified on Mon, 2 Mar at 5:09 AM

The issue will occur when clients use a standard report selection screen with a site report copy.

This can result in a mismatch of parameters similar to the following error:

image.png

The resolution is to either:

  1. Add parameter placeholders in the report (this may confuse people when they are expecting those parameters to have some effect in the report!), 
  2. Copy the selection screen to a site interface and remove the non-essential parameters,
  3. Take a new instance of the standard report and make any required changes, or
  4. Use the standard report.
  5. If the report is using a stored procedure, make sure that the Crystal Report database role that is running the report has execute permission for the stored procedure, eg. GRANT EXEC ON crsp_myproc TO Synergetic_report_finance_ReservedDBRole
    1. Note: The database role/user executing the report may differ per client/program/schema, e.g. Synergetic_report_dbo_ReservedDBRole, Synergetic_report_finance_ReservedDBRole, Synergetic_report_extrafinance_ReservedDBRole

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article