Command - Multiple Values in Parameter
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=23003
Printed Date: 04 May 2024 at 7:01am
Topic: Command - Multiple Values in Parameter
Posted By: BoltzGirl
Subject: Command - Multiple Values in Parameter
Date 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!
|
Replies:
Posted By: BoltzGirl
Date 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!
|
Posted By: kevlray
Date Posted: 12 May 2022 at 4:27am
It might help someone in the future. Good info.
|
|