paramater (number field) , can i use non-number field as an 'ALL'

[ss7415]

instead of entering 0 or another number to get all the data for the parameter, is there a way i can use '%' or 'All'?

(if {?Class} <> 0 then
{Command.CLASS} = {?Class}
else
if {?Class}= 0 then
true) and
(if {?Department} <> 0 then
{Command.DEPT} = {?Department}
else
if {?Department} = 0 then
true) and
(if {?Sub_Class} <> 0 then
{Command.SUBCLASS} = {?Sub_Class}
else
if {?Sub_Class} = 0 then
true)

 

[synapsevampire]

Your topic says it's a numeric, and then it says can you use a non-numeric field = "all"

Perhaps my confusion stems from poor English.

If a parameter is a numeric, then you must enter numerics, right?

What you might do is set up default values of -999999 for the value, and All as the description for the parameter, and select show description only.

The user then sees "All" as a choice, yet you can code for the default numeric.

-k