SAP Knowledge Base Article - Preview

1558782 - Error when refreshing a report based of a Universe using @Variables in Crystal Reports

Symptom

  • Error when refreshing a report based on a Universe.
  • When refreshing a report based on a Universe that uses @Variables, Crystal Reports fails.
  • Depending on the data source the Universe connect to, different error messages will display like:
    • For Oracle: "ORA-00936:missing expression."
    • For MS SQL Server: "Must declare scalar variable "@Variable". SQL State: 42000 Native Error: 137"


Read more...

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020 

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020

Keywords

CR, UNV , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.