Mask Parameter

[Khanson82]

I want the parameter to show Yes or No to the User..
"Yes" would be if a number field in the report would be any number greater than 0. "No" would be if that number is 0. How is this done? Thanks again.

 

[lbass]

You can create a string parameter with options 'Yes' and 'No' and then in your record selection formula use:

(
(
{?parm} = 'Yes' and
{table.number} > 0
) or
(
{?parm} = 'No' and
{table.number} = 0
)
)

Unless I'm missing something, I don't think you are in the right forum for this type of question. Please try forum767 or forum149 for questions like this in the future.

-LB

 

[Khanson82]

One last question, if there are null values too how can I have the above parameter pull them back?The code has just left me.. Thanks..

 

[lbass]

(
isnull({table.number}) or
(
{?parm} = 'Yes' and
{table.number} > 0
) or
(
{?parm} = 'No' and
{table.number} = 0
)
)

This would always return nulls.

-LB