SAP Knowledge Base Article - Public

1203163 - Error: 'The number of rows or columns is too big. Try limiting the number of unique group values' in Crystal Reports

Symptom

  • Refreshing a Crystal Report within the Crystal Reports Designer or within the Crystal Reports Viewer or within Crystal Reports ALV Integration the following error message appears:

2015-03-09- 14-29-18.png

 

Environment

  • Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports Viewer
  • Crystal Reports ALV Viewer

Cause

  • The report has a crosstab. Crosstabs have a limitation on the amount of rows and/or columns that can be displayed within the crosstab object. This limitation is 65,535.
  • By default the Crystal Reports Viewer addon for SAP Business Suite Apps using a crosstab to display the results.

Resolution

  • To workaround this limitation, use grouping within the crosstab to limit the amount of rows/columns displayed.

Keywords

cross tab, limit, 65535 , 6568256, CRV, Crystal Reports Viewer, Crystal Reports ALV Integration, CRV 2008, Crystal Reports Advanced List Viewer (ALV) , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , BC-SRV-ALV , SAP List Viewer , BC-WD-CMP-ALV-ABA , ALV for ABAP , Problem

Product

Crystal Reports 2008 V1 ; Crystal Reports Viewer 2008 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016