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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Prompt for Top N??? 1

Status
Not open for further replies.
hneal98

hneal98

Programmer
Joined
Aug 13, 2002
Messages
1,637
Location
US
Does any one know if there is a way to prompt the user for a N for the Top N?

I need to allow the user to decide if they want the top 5, top 10, top 15, etc.

Thanks for any help.
 
Sort by date Sort by votes
Create a number parameter {?topN}. Sort your groups using report->topN/group sort, choosing "All", instead of an N value, and choosing descending order. Then go to the section expert->group header/details/group footer->suppress->x+2 and enter:

groupnumber > {?topN}

-LB
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question Question
Select Top 2 rows where field = 2,3,4 and 5
Replies
1
Views
673
Cpreston
Cpreston
inkbird01
  • Locked
  • Question Question
Filters > Record Selection for dates between
Replies
4
Views
836
pmax9999
pmax9999
supportsvc
  • Locked
  • Question Question
Date prompt use in Formula with DatePart?
2 3
Replies
42
Views
2K
pmax9999
pmax9999
sofseattle
  • Locked
  • Question Question
Crystal formula for barcode display shows extra characters in date format?
Replies
1
Views
662
BobSuruncle
BobSuruncle
chish_nc
  • Locked
  • Question Question
show annivesary dates for next quarter
Replies
3
Views
621
chish_nc
chish_nc

Part and Inventory Search

Sponsor

Back
Top