Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design  
Message Icon Topic: Command - Multiple Values in Parameter Post Reply Post New Topic
Author Message
BoltzGirl
Groupie
Groupie
Avatar

Joined: 22 Jan 2013
Online Status: Offline
Posts: 89
Quote BoltzGirl Replybullet Topic: Command - Multiple Values in Parameter
    Posted: 11 May 2022 at 9:12am
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(+)
Always appreciate the help!
IP IP Logged
BoltzGirl
Groupie
Groupie
Avatar

Joined: 22 Jan 2013
Online Status: Offline
Posts: 89
Quote BoltzGirl Replybullet Posted: 11 May 2022 at 12:59pm
FIGURED IT OUT!!!! I had changed too many places from = to IN, should have only changed the lines with the parameter and then needed (( )) double parens!! I can't remove my post, so replying to it to share!
Always appreciate the help!
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1568
Quote kevlray Replybullet Posted: 12 May 2022 at 4:27am
It might help someone in the future.  Good info.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.