I have a Crystal report built off a command (below) and I need to change the IPA parameter to accept multiple values.

I have already changed that in the command parameter by modifying and marking the box that says 'Allows multiple values' and it still does not work.

I have changed the command below in the WHERE statements using IPA to "like", "in" and neither of those work either. Any suggestions?

SELECT

auths.ipa_parent_id,
     auths.member_name,
     auths.auth_type,
     auths.dates_user_defined_1,
     auths.ipa_name,
     auths.amv_lob,
     auths.mm_date_of_birth,
     auths.intake_user_defined_2
FROM
(SELECT
     ipax.ipa_parent_id,
     amv.member_name,
     amv.disch_thru_date,
     amv.auth_type,
     amv.dates_user_defined_1,
     ipam.name as ipa_name,
     decode(SUBSTR(amv.meh_line_of_business,2,2), '01', 'Comm', '02', 'MCare', '03','MCaid', amv.meh_line_of_business) as amv_lob,
     amv.mm_date_of_birth,
     amv.intake_user_defined_2
FROM
     xrpt_auth_master_vw          amv,
     xrpt_ipa_master_xref          ipax,
     hsd_ipa_master               ipam

WHERE
        amv.meh_ipa_id = ipam.ipa_id and
     ipam.ipa_id = ipax.ipa_id and
     amv.auth_type = '{?AuthType}' and
        ipax.ipa_parent_id ='{?IPA}')Auths,

(SELECT
     ilv_imx.ipa_id               mms_ipa,
     count(ilv_meh.seq_memb_id)     mms_cnt
FROM
     xrpt_ipa_master_xref          ilv_imx

WHERE
        ilv_imx.ipa_id in ilv_meh.ipa_id and
     ilv_meh.term_date is null and
     ilv_imx.ipa_parent_id ='{?IPA}'

(SELECT
     amp.prov_code as ap_prov_code,
     pm.short_name as prov_short_name
FROM     
hsd_auth_provider     amp,
hsd_prov_master          pm     

WHERE
     amp.seq_prov_id=pm.seq_prov_id and
     amp.prov_code = 'IN' )inst

WHERE
auths.meh_ipa_id = mms.mms_ipa(+) and
auths.amv_lob in mms.mms_lob(+)

It might help someone in the future.  Good info.