Printing Optional/Multiple Number Parameter

[ajxmas]

I'm using Crystal 2008 with Oracle DB

I have an optional number parm that can accept multiple entries. I want to print this in the header or "All" if they didn't enter anything.

This formula works fine if something is entered in the parm but gives me an error when nothing is entered. The error I get is "Parameter has no value"

I've tried putting an if hasvalue check in front but it still does not like it.

Any help is appreciated.

My ultimate goal is to either print the word "All" if no parm is entered or the actual parm values.


numbervar counter;
stringvar display;
for counter := 1 to count({?Fare Instrument}) do (
display := display + totext({?Fare Instrument}[counter],0,"") + ", ");
left(display, len(display)-2);

 

[lbass]

numbervar i;
stringvar x;
if hasvalue({?Fare Instrument}) then
for i := 1 to ubound({?Fare Instrument}) do (
x := x + totext({?Fare Instrument},0,"") + ", "
);
if not hasvalue({?Fare Instrument})
then "All" else
left(x, len(x)-2)

-LB

 

[ajxmas]

Thanks so much, this is exactly what I was trying to do. I guess I had the wrong syntax for the hasvalue when I tried it before. Thanks again for you quick response and expert help.