ALL for a number parameter

[shelby55]

Hi

I have a parameter for a report that selects on a number field but want the user to be able to select "ALL". When the parameter field is string, I can include ({?parameter} = "ALL" or {field} = {?paramter}). What do I do if the field is a numeric field and I want the user to be able to select all at once?

Thanks for any and all assistance!

Shelby

 

[rhinok]

[ol][li]Within the parameter options, add a parameter value of 999 with a description of 'All'. Select 'Description' from the Display drop-down list. The user will see and be able to select 'All' even though the actual value is a Number. If you have other numbers in the list (5, 10, 15, etc...) then you'll need to create a description that is equal to the value so that the users will see both 'All' and numeric values in the pick list.[/li]

[li]Create a Record Selection similar to the following statement:

//Record Select Statement will return 'all' values ({?parameter} = 999)
(
If
{?parameter} <> 999
Then
{table.numberfield} In {?parameter}
Else If
{?parameter} = 999
Then True
}[/li][/ol]