Conversion of a parm into 'Any' 1

[Nansat]

Is there any possibility to convert a user input parameter to ANY?

Scenario :
user can pick one/many products from the product list available as a input parameter.

if user selects 000 (not a valid product, but instead our own code that represents 'All products') , then by using any formula can we make 'select expert' understand that USER wants 'All products' information ??

 

[Turkbear]

Hi,
Sure:

If {?Param} = '000' then
True
else
{table.productid} = {?Param}

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Nansat]

Hi Turkbear,

Thank you very much for the suggestion.

Also, can we have make a parameter 'OPTIONAL' by setting any parameter?.

Thanks

 

[Turkbear]

Hi,
Yes..

Set a default value for the parameter and test for it first ( same logic as testing for '000')..
If the parameter has no default value and none is supplied by user-interaction you must test for Null FIRST:

If 
( IsNull({?Param}) or Trim({?Param}) = "" or {?Param} = 'DefaultValue')
Then
True
Else
{table.Field} = {?Param}

If more than one parameter needs to be handled this way, enclose EACH 'If..Then..else' set in Parens and and/or them as needed to meet you needs..







To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Nansat]

Thank you very much Turkbear. I got around this problem in similar lines suggested by you.