SAP Knowledge Base Article - Public

1362764 - Top 'N' in Top 'N' based on user Input in Crystal Reports.


How to get Top 'N' in Top 'N'


  1. Create a report with sample Xtreme database using Customer table
  2. Insert a group on Country and insert summary on Last Year Sales.
  3. Create a Parameter to get Top ‘n’ value from user.
  4. Insert a group on Customer ID and insert summary on Last Year Sales.
  5. Now go in Group Sort Expert and select Top ‘N’ for two groups and select formula editor button and place the parameter.
  6. Suppress the un-necessary sections.


KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To


SAP Crystal Reports XI R2