I'm still in the testing phase of webFOCUS and have a question about passing 2 different parameters from the parent report into the child report.

I have two parameters that the user can choose in the parent report:
Exclude Do Not Mail?: Yes / No (drop down)
Include Active Alumni Only?: Yes / No (drop down)

When I click on the column options for the drill down (COUNTRY TOTAL), I am trying to pass COUNTRY (this field passes & is not a parameter that the user can choose from a drop down), DO NOT MAIL, and ACTIVE ALUMNI. Here is part of the code:

.
.
.
WHERE J4.USF_AA_DN_DT.DNM EQ '&DNM.({No,_FOC_NULL},{Yes,N}).Exclude Do Not Mail.';
WHERE J3.USF_AA_GIFT_SUMS.ACTIVE_ALUMNI EQ '&ACTIVE_ALUMNI.({No,_FOC_NULL},{Active,Y},{Inactive,N}).Active Alumni.';
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET EXPANDABLE ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
TYPE=DATA,
COLUMN=N4,
TARGET='iframe1',
FOCEXEC=app/alumni_by_geo_state_1( \
COUNTRY=N3 \
DNM='&DNM' \
ACTIVE_ALUMNI='&ACTIVE_ALUMNI' \

For DNM and ACTIVE_ALUMNI, I chose 'Parameter Value: Constant Value' in the Drill Down Parameter (I'm unable to save it as 'Parameter Value: Variable').

Should I be including some code in the child report (alumni_by_geo_state_1)?

HELP!!


EDIT: I replaced the <> with {} since it was making some of the code disappear. The reason why I didn't use [ code ] [ / code ] was so I can still BOLD the two parameters I want to pass.

This message has been edited. Last edited by: Aimee,

If the fex alumni_by_geo_state_1 has this data, and the drill down requires the filtered data, then yes.

Jeeze, I thought I did have it in the child report, but when I checked the Text View, I didn't indicate the &DNM and &ACTIVE_ALUMNI

THANK YOU WAZ! I'm pretty sure this is the 2nd report you've helped me get through!
** Gold Star **