Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to show only the top 20 groups

Status
Not open for further replies.
JSeidel

JSeidel

Technical User
Joined
Jan 10, 2003
Messages
77
Location
US
I have a report where I only want to graph and show in table format the top twenty. For example, I have a field which can list any number of results, but I want to aggregate the results into groups and show only the twenty that have the most records.

thanks
 
Sort by date Sort by votes
You need to look at the TopN Expert. It is designed for the case you mention. Steve Phillips, Crystal Consultant
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

tlbrown88
  • Locked
  • Question Question
How does one get the results of a Calculation (SharedVar) on the same line as the Sub Report?
Replies
4
Views
969
tlbrown88
tlbrown88
D
  • Locked
  • Question Question
Running total from a subreport only showing last value
Replies
4
Views
1K
doodledump
D
Cpreston
  • Locked
  • Question Question
Select Top 2 rows where field = 2,3,4 and 5
Replies
1
Views
681
Cpreston
Cpreston
Cpreston
  • Locked
  • Question Question
Only Select certain rows
Replies
7
Views
984
Cpreston
Cpreston
socalvelo
  • Locked
  • Question Question
Limiting the number of records in groups and sub-reports
Replies
2
Views
486
socalvelo
socalvelo

Part and Inventory Search

Sponsor

Back
Top