UPDATE: Found a solution for this by googling for hours:

1. Create the following formulas:
@Formula1
WhilePrintingRecords;
NumberVar Number := 0;

@Formula2
WhilePrintingRecords;
NumberVar Number;
Number := Number + 1;

2. Place @Formula1 in the Group Header. Format the formula to Suppress.

3. Place @Formula2 in Details A. Format the formula to Suppress.

4. Format the Details A section to conditionally Suppress by selecting the X+2 button.

5. Enter this formula:
If {?SummaryMode} = "Summary"
Then
{@formula2} > 1
Else
If {?SummaryMode} = "Last 5"
Then
{@formula2} > 5
Else
If {?SummaryMode} = "Last 25"
Then
{@formula2} > 25
Else
If {?SummaryMode} = "Last 50"
Then
{@formula2} > 50
Else
If {?SummaryMode} = "All Available"
Then
{@formula2} > 1000
Else
{@formula2} > 5

6. Create a Parameter called "SummaryMode" that has the options that are listed in the forumla in step 5.

Thanks to everyone who read this.

Here is the original Post:
I have a report that displays alot of data using a group.

I would like to create a parameter that the report user can set to display X number of records per group.

I have a suppression forumla, but it is suppressing the total number of records, instead of suppressing that number of records in each group:

If {?SummaryMode} = "Summary"
Then
RecordNumber > 1
Else
If {?SummaryMode} = "Last 5"
Then
RecordNumber > 5
Else
If {?SummaryMode} = "Last 25"
Then
RecordNumber > 25
Else
If {?SummaryMode} = "Last 50"
Then
RecordNumber > 50
Else
If {?SummaryMode} = "All Available"
Then
RecordNumber > 1000
Else
RecordNumber > 5


Help

Edited by mburris - 20 Dec 2009 at 7:38pm