SAP Knowledge Base Article - Public

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

Symptom

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

Resolution

  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.

Keywords

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

Product

SAP Crystal Reports XI R2