SAP Knowledge Base Article - Public

2786256 - How to limit number of records retrieved from datasource in Crystal Reports for Enterprise

Symptom

  • How to limit number of records retrieved from datasource in Crystal Reports for Enterprise?
  • There is an option to Group and display Top N by surpressing records, but the whole dataset still coming to the client and affects performance. Need to limit on the datasource level

Environment

  • SAP Crystal Reports for Enterprise 4.2

Cause

  • There is no such functionality within Crystal Reports for Enterprise  

Resolution

There are two options:

  1. Create command object connection and add the Top N logic to the Command object
  2. Add a semantic layer and add the logic to the Universe

Keywords

Limit, first 10 , KBA , BI-RA-CRE , Crystal Reports for Enterprise , How To

Product

SAP Crystal Reports 2016