SAP Knowledge Base Article - Public

1558782 - Error when using Crystal Reports on a Universe with @Variables

Symptom

@Variables in Universes are not resolved when used from Crystal Reports. Depending on the underlying Database subsystem different error messages are displayed.

Oracle DBS: ORA-00936:missing expression

MS SQL: Must declare scalar variable "@Variable". SQL State: 42000 Native Error: 137

Environment

Crystal Reports using a Universe with @Variables

Cause

@Variables are not resolved when the Universe is used from within Crystal Reports. The only supported Variable is @Variable('BOUSER').

Resolution

Behaviour is by design.

See Also

Crystal Reports Universe Support (see attachment)

Keywords

Crystal Reports Universe Variable Variables @Variable BOLANGUAGE BOUSER DBUSER DBPASS DOCNAME DPNAME DPTYPE UNVNAME UNVID PREFERRED_VIEWING_LOCALE DOMINANT_PREFERRED_VIEWING_LOCALE Custom "Operating System" , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports XI R2

Attachments

Crystal_Universe_Support.pdf