Multiple values option in Parameter not working

[kamkaro]

Hi All,

Requirement:
Created one String parameter {?status_flg} where user can chose multiple values.

Using:
After created the String parameter, I selected the "Allows multiple values" check box, but when I am calling this parameter {?status_flg} in my Command(SQL expert), getting error 'right parenthesis is missing'.

code:
[highlight #204A87]WHERE SA.SA_STATUS_FLG in (join('{?status_flg}','','') )[/highlight]

Suggestion:
Please look at the above code, and let me know where I am doing wrong.

Appreciate that.

Thanks.

 

[briangriffin]

Multiple value parameter already exist as arrays, so this should work:

where SA.SA_STATUS in {?status_flg}

I just did a quick test with sample data and it worked as expected.

 

[kamkaro]

Hi,
Code: where SA.SA_STATUS in {?status_flg}
The above code is working perfectly fine. I can chose more than one values.

Now I am using the following code for default value (If user does not enter anything then crystal report use default);

Code: WHERE SA.SA_STATUS_FLG in decode({?Status_Flg},null,'40','','40',{?Status_Flg})

In the above code, either blank or multiple values not working. Only single value is working. For auto scheduling, I have to provide default value.

Please suggest me where I am wrong.


Thanks.

 

[briangriffin]

I think this would probably be handled best in the command/stored procedure logic, rather than make the parameter do all the work.