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 Westi 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
Aug 13, 2002
1,637
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
Select Top 2 rows where field = 2,3,4 and 5
Replies
1
Views
318
Cpreston
Cpreston
inkbird01
  • Locked
  • Question
Filters > Record Selection for dates between
Replies
4
Views
362
pmax9999
pmax9999
supportsvc
  • Locked
  • Question
Date prompt use in Formula with DatePart? 2
2 3
Replies
42
Views
953
pmax9999
pmax9999
sofseattle
  • Locked
  • Question
Crystal formula for barcode display shows extra characters in date format?
Replies
1
Views
315
BobSuruncle
BobSuruncle
chish_nc
  • Locked
  • Question
show annivesary dates for next quarter 1
Replies
3
Views
357
chish_nc
chish_nc

Part and Inventory Search

Sponsor

Back
Top