HP Intelligent Management Center Standard Software Platform - Manual (Page 247)

Selecting top or bottom groups or percentages
conditionally
If you want your users to choose their own value for a Top N, a Bottom N,
or a top or bottom percentage, create a parameter to prompt for the value
that Crystal Reports can then pass to a conditional selection formula.
Note:
• For groups, the top or bottom N value must be between 1 and 32,766.
• For percentages, the top or bottom N value must be between 0 and 100.
To select a conditional number of groups or percentage value
1. Open or create the report that you want to use for the conditional value
or percentage selection.
Note:
This report must contain a group and summary information as described
in
Selecting top or bottom N groups or percentages .
2.
In the Field Explorer, select Parameter Fields, and click New.
3. Create a number parameter.
Tip:
For information about how to create parameters, see Creating a parameter
with a static prompt .
4. Click OK to save your parameter.
5.
On the Report menu, click Group Sort Expert.
6. In the Group Sort Expert, select the type of group sort that you want.
Choose any option except No Sort or All.
7.
Click the Conditional Formula button next to the N or Percentage
value field.
8. In the Formula Workshop, enter the parameter field that you created in
step 3.
9. Click Save and close to return to your report.
Crystal Reports 2008 SP3 User's Guide 247
10 Sorting, Grouping, and Totaling
Summarizing grouped data