SAP Knowledge Base Article - Public

1451611 - Not able to retrieve data via Report Instance

Symptom

  • In InfoView, user was not able to retrieve data via Report Instance.
  • Reports were based on Business View Manager.

Environment

  • BusinessObjects Enterprise XI 3.1 with FixPack 1.8
  • Crystal Reports 2008 with FixPack 1.8
  • Oracle Database 10.2.0.1
  • WebSphere Application Server ND 6.0.2

Reproducing the Issue

  1. Open Business View Manager (BVM).
  2. Create Data Connection (DC) based on Oracle data (Create New Connection -> Oracle Server).
  3. Create Data Foundation (DF) based on the newly created DC. Use Add Command to insert table, ensure you include a parameter value within the SQL statement e.g SELECT * FROM xx_Table WHERE field_name = '{?PARAMETER_PROMPT}'.
  4. Create Business Element (BE) based on the newly created DF.
  5. Create Business View based on the newly created BE.
  6. Open Crystal Reports 2008.
  7. Create a new report based on the newly created BVM. Make sure your parameter field has the following option set to editable. Show on (Viewer) Panel = Editable.
  8. Export report to InfoView.
  9. Open InfoView and schedule the report to run.
  10. Open the successful report instance. Click Parameter. The parameter panel appears.
  11. Change the value of the paramter. Click Apply.

Report data will not update as it will remain showing the existing data.

Cause

The issue has been identified and tracked under ID ADAPT01396808.

Resolution

This issue is scheduled to be addressed in a future Fix Pack.

Keywords

BVM, CR2008, BOE , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , BI-RA , Reporting, analysis, and dashboards , Problem

Product

SAP Crystal Reports XI