SAP Knowledge Base Article - Public

1265824 - Passing prompt values to Open Document URL for Crystal Reports

Symptom

  • Report called through OpenDocument URL prompts for parameters
  • What is the syntax for specifying prompt values in URL Reporting for Crystal Reports?

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016

Reproducing the Issue

  1. Save Crystal Report with parameters to BI Server
  2. Create an OpenDocument URL to call the report and pass the parameters
  3. Open the URL in IE Browser 

Cause

  • Incorrect syntax used in the URL

Resolution

  • A single prompt value:

lsS[NAME]

Example: openDocument.jsp?iDocID=342& sType=wid&sRefresh=Y&lsSProductName=Cycle

  • Multiple prompt values:

lsM[NAME]

Example: openDocument.jsp?iDocID=345& sType=wid&sRefresh=Y&lsMProductName=Cycle,Car

  • A range of values:

lsR[NAME]

Example: openDocument.jsp?sType=rpt&iDocID=860&lsRparamStringDR=[h..i]

See Also

  • For further code samples and details please see attached whitepaper

Keywords

Parameters, OpenDocument , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports XI R2

Attachments

xi4_opendocument_en.pdf