SAP Knowledge Base Article - Public

1708942 - Crystal Report crashes when selecting Named Sets in Member Selector from OLAP Expert in CR Designer 2008.

Symptom

Crystal Report crashes when selecting Named Sets in Member Selector from OLAP Expert.

Environment

  • Crystal Reports 2008 Service Pack 5/Crystal Reports 2011
  • MS-SQL Server 2005/2008 R2
  • Microsoft OLEDB provider for Analysis Services 9.0 (SQL 2005)
  • Native OLAP Connector.

Reproducing the Issue

  1. Launch CR Designer.
  2. Go to File->New-> Blank Report.
  3. Database Expert->Create New Connection->OLAP->OLAP Connection Browser
  4. Select and Open the Adventure Works Direct Sales cube from the browser.
  5. From the 'Page Dimension Selector' select the dimension to use in the report.
  6. In the OLAP Expert-> OLAP Data tab, choose the data to be your OLAP source and choose an OLAP server type and then select the cube that contains the data.
  7. In the OLAP Expert-> Go to Rows/Columns tab add rows,columns to the grid from the available dimension, then select members to include.
  8. Under the columns area in OLAP expert-Rows/Columns, click on 'Select Column Members'.
  9. From the 'Member Selector'Open Favourites and then Server and then select Core Product Group.Deselect All Products and click OK.
  10. Under the columns area in OLAP expert-Rows/Columns, click on 'Select Column Members' again.
  11. Crystal Report Crashes with the error message "Crystal Reports has stopped working".

Cause

This issue has been identified and logged under Problem Report ID ADAPT01620899. 

Resolution

This issue is targeted to be fixed in Business Objects Enterprise XI 3.1 Service Pack 6.

Keywords

Crystal Reports OLAP, Named Sets. , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Bug Filed

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011