I was given a report that was written quite some time ago and by someone else. I was challenged with figuring out why the IPA parameter used in this report, won't accept multiple values. I thought it would be a matter of editing the command, selecting the parameter and marking the box that says "Allow Multiple Values"....well that didn't work! Here is the part of the command I think that is having the problem. Is there something I need to change in this statement also, to allow multiple values to be chosen using this parameter?

WHERE
amv.meh_ipa_id = ipam.ipa_id and
     ipam.ipa_id=ipax.ipa_id and
               amv.auth_number = am.auth_number and
     amv.auth_status in ('OP','NW','HD','CL') and
     amv.admit_date <=
---decode({?date},to_date('1800,01,01', 'YYYY,MM,DD'),sysdate,{?date})
               decode({?Date},to_date('1800,01,01', 'YYYY,MM,DD'),sysdate,
               decode({?Date},to_date('1900,01,01', 'YYYY,MM,DD'),sysdate-1,{?Date}))

and
     (amv.disch_thru_date >=
---decode({?date},to_date('1800,01,01', 'YYYY,MM,DD'),sysdate,{?date})
               decode({?Date},to_date('1800,01,01', 'YYYY,MM,DD'),sysdate,
               decode({?Date},to_date('1900,01,01', 'YYYY,MM,DD'),sysdate-1,{?Date}))
           or amv.disch_thru_date is null) and
     amv.auth_type = '{?AuthType}' and
                 ipax.ipa_parent_id = '{?IPA}') Auths

It is not a dynamic parameter, it's static which I just verified. Should it be dynamic

Yes the issue literally is not being able to select more than one item from the parameter.

I tried that right off the bat and it will not let me change that value to True.

The parameter is created in Crystal, under Parameter Fields yet it also lies within the command.

When I go to edit the command, there are 3 parameters also there and one of them is this IPA one that I wanted to change. That's why I though it was originally something with the command.

One co-worker offered this opinion below:
*****
I don’t know for sure, but it might be a problem with this statement:

and
     (amv.disch_thru_date >=
---decode({?date},to_date('1800,01,01', 'YYYY,MM,DD'),sysdate,{?date})
               decode({?Date},to_date('1800,01,01', 'YYYY,MM,DD'),sysdate,
               decode({?Date},to_date('1900,01,01', 'YYYY,MM,DD'),sysdate-1,{?Date}))
           or amv.disch_thru_date is null) and
     amv.auth_type = '{?AuthType}' and
                 ipax.ipa_parent_id = '{?IPA}') Auths


The line would normally be something like ipax.ipa_parent_id = ‘Value’.   It looks like the way to reference the parameter is {?IPA}….   So if you make it ‘{?IPA}’ then I think it might partially fix your issue—notice there is an extra ending parenthesis right now that I think needs to be removed.

******

However, removing, adding the parens didn't work either from his opinion.

This blog post has a lot of good information about how to use parameters with Commands: https://blogs.sap.com/2015/04/01/best-practices-when-using-commands-with-crystal-reports/.

There are a couple of problems with how the Command is configured:

1. If you have a multiple-select parameter, you don't need the quotes around it.
2. Change "=" to "in"
3. Edit the parameter in the Command Editor - that's where you'll find the option to make it multi-select.

-Dell