SAP Knowledge Base Article - Public

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


  • 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



  • 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


  • 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.


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


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