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!

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

Use a paramater for a Top N Expert?

Status
Not open for further replies.

Chilly1

Programmer
Jul 24, 2002
7
CA
Is it possible to set a paramater that allows a user to decide the number for the Top N Expert?

For example I would like the user to be able to decide who the top 5 sales people are -- OR -- decide who the top 10 sales people are.

Is there a way the user can select through the paramter screen the number they want???
 
You can't do this with a TopN approach, but you can achieve the same effect by conditionally suppressing the section.

hth,
- Ido CUT & Visual CUT: e-mailing, exporting, bursting, distribution, and scheduling of Crystal Reports:
 
Here's some more detail:

Keep the TopN sort.

Create a Running Total (e.g., "RT_Reps") of type Count that Evaluates on change of group: Sales Person

In the Suppress attribute of the section(s) enter:
------------------------------
{#RT_Reps} > {?your_parameter}
------------------------------

Cheers,
- Ido CUT & Visual CUT: e-mailing, exporting, bursting, distribution, and scheduling of Crystal Reports:
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top