SAP Knowledge Base Article - Public

1660659 - Parameter List of Values is static in Live Office when the source is a BEx Query

Symptom

  • Missing values
  • Not all values are listed for the parameter
  • When using Live Office, it shows a static list of values for the parameter
  • Live Office based off a BEx Query doesn't display a dynamic list of values for the parameter

 

Environment

  • Live Office
  • Crystal Reports XI R2
  • Crystal Reports 2008
  • Crystal Reports 2011
  • BusinessObjects Enterprise XI R2
  • BusinessObjects Enterprise XI 3.1
  • BusinessObjects Enterprise 4.0

Reproducing the Issue

  1. In Crystal Reports, create a report based off an SAP BEx Query that use one or more variables. ( Parameter )
  2. Save the report to BusinessObjects Enterprise
  3. In MS Excel, create a Live Office document using the report created in step 1
  4. You will be prompted by the BEx Query parameter, but the list of values is static

Cause

  • When reporting off an SAP BEx Query that contains variables in Crystal Reports, the variables are converted into static parameter.
  • The parameter will only be dynamic when the report is viewed in BusinessObjects Enterprise when the report is published to BusinessObjects Enterprise using the SAP BW Publisher. For more information, see the SAP Knowledge Base Article 1356122
  • In Crystal Reports designer, and in Live Office, the BEx Query parameter have static list of values.

Keywords

KBA , BI-BIP-LO , Live Office , Problem

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports 2011, feature pack 03 ; SAP Crystal Reports XI R2