Hello everyone,

I'm doing some testing before we go live with webFOCUS in a couple of weeks... and I have a question!

I'm trying to pass the user-chosen parameter of "Do Not Mail (DNM)" from the main fex report to an iframe fex report. Hopefully once I get that figured out, I can pass the user-chosen parameters of "Active Alumni" and "Alumni by School"!

I can get it to run, but I can't get the parameter to pass. I tried to make the DNM column invisible in Alumni by Region and pass that from the Country Total which drills down to the Alumni by State report which will be in an iframe on an HTML page. But once I do it, my report hangs and doesn't finish running.

What am I doing wrong with my passing code?

----------------------------
----------------------------
ALUMNI BY REGION:

JOIN
LEFT_OUTER USF_AA_ADDRESS.USF_AA_ADDRESS.PIDM IN USF_AA_ADDRESS TO UNIQUE
USF_AA_GIFT_SUMS.USF_AA_GIFT_SUMS.PIDM IN USF_AA_GIFT_SUMS TAG J3 AS J3
END
JOIN
LEFT_OUTER J3.USF_AA_GIFT_SUMS.PIDM IN USF_AA_ADDRESS TO UNIQUE
USF_AA_DN_DT.USF_AA_DN_DT.PIDM IN USF_AA_DN_DT TAG J4 AS J4
END
JOIN
LEFT_OUTER J4.USF_AA_DN_DT.PIDM IN USF_AA_ADDRESS TO UNIQUE
USF_AA_DEGREE_USF.USF_AA_DEGREE_USF.PERSON_UID IN USF_AA_DEGREE_USF TAG J5
AS J5
END
DEFINE FILE USF_AA_ADDRESS
Region/A20=
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'AUSTRALIA' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'BANGLADESH' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'BRUNEI DARUSSALEM' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'BURMA' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'CAMBODIA' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'CHINA' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'COCOS (KEELING) ISLANDS (AS)' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'FEDERATED STATES OF MICRONESIA' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'FIJI' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'FRENCH POLYNESIA' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'HONG KONG' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'INDIA' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'INDONESIA' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'JAPAN' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'MACAU' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'MALAYSIA' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'MONGOLIA' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'NEPAL' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'NEW CALEDONIA' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'NEW ZEALAND' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'PAPUA NEW GUINEA' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'PHILIPPINES' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'NORTH KOREA' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'SOUTH KOREA' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'SINGAPORE' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'SRI LANKA' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'TAIWAN' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'THAILAND' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'VIETNAM' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'ALGERIA' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'CAMEROON' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'COMOROS' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'EGYPT' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'ETHIOPIA' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'GABON' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'GHANA' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'GUINEA' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'KENYA' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'MALAWI' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'MALI' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'MAURITIUS' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'MOROCCO' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'NIGERIA' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'RWANDA' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'SENEGAL' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'SIERRA LEONE' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'SOUTH AFRICA' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'SUDAN' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'TANZANIA' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'THE GAMBIA' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'TOGO' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'TUNISIA' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'UGANDA' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'ZAMBIA' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'ZIMBABWE' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'BARBADOS' THEN 'CARIBBEAN' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'CAYMAN ISLANDS' THEN 'CARIBBEAN' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'DOMINICAN REPUBLIC' THEN 'CARIBBEAN' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'GUADELOUPE' THEN 'CARIBBEAN' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'HAITI' THEN 'CARIBBEAN' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'JAMAICA' THEN 'CARIBBEAN' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'MARTINIQUE' THEN 'CARIBBEAN' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'NETHERLANDS ANTILLES' THEN 'CARIBBEAN' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'Saint Martin' THEN 'CARIBBEAN' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'TRINIDAD AND TOBAGO' THEN 'CARIBBEAN' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'AUSTRIA' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'AZERBAIJAN' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'BELGIUM' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'BELARUS' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'BOSNIA & HERZEGOVINA' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'BOSNIA-HERZEGOVINA' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'BULGARIA' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'CROATIA' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'CZECH REPUBLIC' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'DENMARK' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'FINLAND' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'FRANCE' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'GERMANY' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'GERMANY, FEDERAL REPUBLIC OF' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'GREECE' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'HUNGARY' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'ICELAND' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'IRELAND' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'ITALY' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'LITHUANIA' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'LUXEMBOURG' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'MACEDONIA' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'MALTA' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'MONTENEGRO (Use MJ)' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'NETHERLANDS' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'NORWAY' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'POLAND' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'PORTUGAL' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'REPUBLIC OF GEORGIA' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'ROMANIA' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'RUSSIA' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'SERBIA' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'SLOVAKIA' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'SPAIN' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'SWEDEN' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'SWITZERLAND' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'UKRAINE' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'UNITED KINGDOM' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'UZBEKISTAN' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'AFGHANISTAN' THEN 'MIDDLE EAST' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'BAHRAIN' THEN 'MIDDLE EAST' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'CYPRUS' THEN 'MIDDLE EAST' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'IRAN' THEN 'MIDDLE EAST' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'ISRAEL' THEN 'MIDDLE EAST' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'JORDAN' THEN 'MIDDLE EAST' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'KAZAKHSTAN' THEN 'MIDDLE EAST' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'KUWAIT' THEN 'MIDDLE EAST' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'LEBANON' THEN 'MIDDLE EAST' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'PAKISTAN' THEN 'MIDDLE EAST' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'QATAR' THEN 'MIDDLE EAST' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'SAUDI ARABIA' THEN 'MIDDLE EAST' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'SYRIA' THEN 'MIDDLE EAST' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'TURKEY' THEN 'MIDDLE EAST' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'UNITED ARAB EMIRATES' THEN 'MIDDLE EAST' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'UNITED ARAB EMIRATES (obsol' THEN 'MIDDLE EAST' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'BELIZE' THEN 'CENTRAL AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'COSTA RICA' THEN 'CENTRAL AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'EL SALVADOR' THEN 'CENTRAL AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'GUATEMALA' THEN 'CENTRAL AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'HONDURAS' THEN 'CENTRAL AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'NICARAGUA' THEN 'CENTRAL AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'PANAMA' THEN 'CENTRAL AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'ARGENTINA' THEN 'SOUTH AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'BOLIVIA' THEN 'SOUTH AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'BRAZIL' THEN 'SOUTH AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'CHILE' THEN 'SOUTH AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'COLOMBIA' THEN 'SOUTH AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'ECUADOR' THEN 'SOUTH AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'GUYANA' THEN 'SOUTH AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'PARAGUAY' THEN 'SOUTH AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'PERU' THEN 'SOUTH AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'SURINAME' THEN 'SOUTH AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'URUGUAY' THEN 'SOUTH AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'VENEZUELA' THEN 'SOUTH AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'AMERICAN SAMOA (US STATE:AS)' THEN 'NORTH AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'CANADA' THEN 'NORTH AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'GUAM (US STATE: GU)' THEN 'NORTH AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'MEXICO' THEN 'NORTH AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'PUERTO RICO (US STATE: PR)' THEN 'NORTH AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'US MINOR OUTLYING ISLANDS (ob' THEN 'NORTH AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'UNITED STATES' THEN 'NORTH AMERICA';
END
TABLE FILE USF_AA_ADDRESS
SUM
CNT.USF_AA_ADDRESS.USF_AA_ADDRESS.PIDM AS 'Region Total'
BY LOWEST USF_AA_ADDRESS.USF_AA_ADDRESS.Region
SUM
CNT.USF_AA_ADDRESS.USF_AA_ADDRESS.PIDM AS 'Country Total'
J4.USF_AA_DN_DT.DNM NOPRINT
BY LOWEST USF_AA_ADDRESS.USF_AA_ADDRESS.Region
BY LOWEST USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY AS 'Country'
WHERE USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY NE 'Unknown';
WHERE USF_AA_ADDRESS.USF_AA_ADDRESS.ID NE MISSING;
WHERE ( USF_AA_ADDRESS.USF_AA_ADDRESS.DECEASED EQ 'N' ) OR ( USF_AA_ADDRESS.USF_AA_ADDRESS.DECEASED EQ MISSING );
WHERE J4.USF_AA_DN_DT.DNC NE 'Y';
WHERE ( J4.USF_AA_DN_DT.ALUMNI_ALL EQ 'Y' ) OR ( J4.USF_AA_DN_DT.LOAN_MTN_ALUMNI EQ 'Y' );
WHERE J4.USF_AA_DN_DT.DNM EQ '&DNM.(,).Exclude Do Not Mail.';
WHERE J3.USF_AA_GIFT_SUMS.ACTIVE_ALUMNI EQ '&ACTIVE_ALUMNI.(,,).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_state_5( \
COUNTRY=N3 \
DNM=N5 \
),
$
ENDSTYLE
END


----------------------------
----------------------------

ALUMNI BY STATE:

JOIN
LEFT_OUTER USF_AA_ADDRESS.USF_AA_ADDRESS.PIDM IN USF_AA_ADDRESS TO UNIQUE
USF_AA_GIFT_SUMS.USF_AA_GIFT_SUMS.PIDM IN USF_AA_GIFT_SUMS TAG J1 AS J1
END
JOIN
LEFT_OUTER J1.USF_AA_GIFT_SUMS.PIDM IN USF_AA_ADDRESS TO UNIQUE
USF_AA_DN_DT.USF_AA_DN_DT.PIDM IN USF_AA_DN_DT TAG J2 AS J2
END
JOIN
LEFT_OUTER J2.USF_AA_DN_DT.PIDM IN USF_AA_ADDRESS TO UNIQUE
USF_AA_DEGREE_USF.USF_AA_DEGREE_USF.PERSON_UID IN USF_AA_DEGREE_USF TAG J3
AS J3
END
DEFINE FILE USF_AA_ADDRESS
State/A60=
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'AA' THEN 'MILITARY AMERICAS' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'AE' THEN 'MILITARY EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'AK' THEN 'ALASKA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'AL' THEN 'ALABAMA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'AP' THEN 'MILITARY PACIFIC' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'AR' THEN 'ARKANSAS' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'AS' THEN 'AMERICAN SAMOA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'AZ' THEN 'ARIZONA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'CA' THEN 'CALIFORNIA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'CO' THEN 'COLORADO' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'CT' THEN 'CONNECTICUT' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'DC' THEN 'WASHINGTON DC' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'DE' THEN 'DELAWARE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'FL' THEN 'FLORIDA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'FM' THEN 'FEDERATED STATES OF MICRONESIA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'GA' THEN 'GEORGIA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'GU' THEN 'GUAM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'HI' THEN 'HAWAII' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'IA' THEN 'IOWA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'ID' THEN 'IDAHO' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'IL' THEN 'ILLINOIS' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'IN' THEN 'INDIANA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'KS' THEN 'KANSAS' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'KY' THEN 'KENTUCKY' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'LA' THEN 'LOUISIANA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'MA' THEN 'MASSACHUSETTS' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'MD' THEN 'MARYLAND' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'ME' THEN 'MAINE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'MI' THEN 'MICHIGAN' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'MN' THEN 'MINNESOTA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'MO' THEN 'MISSOURI' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'MP' THEN 'NORTHERN MARIANA ISLANDS' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'MS' THEN 'MISSISSIPPI' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'MT' THEN 'MONTANA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'NC' THEN 'NORTH CAROLINA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'ND' THEN 'NORTH DAKOTA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'NE' THEN 'NEBRASKA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'NH' THEN 'NEW HAMPSHIRE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'NJ' THEN 'NEW JERSEY' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'NM' THEN 'NEW MEXICO' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'NV' THEN 'NEVADA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'NY' THEN 'NEW YORK' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'OH' THEN 'OHIO' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'OK' THEN 'OKLAHOMA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'OR' THEN 'OREGON' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'PA' THEN 'PENNSYLVANIA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'PR' THEN 'PUERTO RICO' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'RI' THEN 'RHODE ISLAND' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'SC' THEN 'SOUTH CAROLINA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'SD' THEN 'SOUTH DAKOTA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'TN' THEN 'TENNESSEE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'TX' THEN 'TEXAS' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'UT' THEN 'UTAH' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'VA' THEN 'VIRGINIA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'VI' THEN 'VIRGIN ISLANDS' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'VT' THEN 'VERMONT' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'WA' THEN 'WASHINGTON' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'WI' THEN 'WISCONSIN' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'WV' THEN 'WEST VIRGINIA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'WY' THEN 'WYOMING' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.STATE EQ 'XX' THEN 'UNKNOWN';
Region/A40=
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'AUSTRALIA' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'BANGLADESH' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'BRUNEI DARUSSALEM' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'BURMA' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'CAMBODIA' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'CHINA' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'COCOS (KEELING) ISLANDS (AS)' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'FEDERATED STATES OF MICRONESIA' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'FIJI' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'FRENCH POLYNESIA' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'HONG KONG' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'INDIA' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'INDONESIA' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'JAPAN' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'MACAU' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'MALAYSIA' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'MONGOLIA' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'NEPAL' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'NEW CALEDONIA' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'NEW ZEALAND' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'PAPUA NEW GUINEA' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'PHILIPPINES' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'NORTH KOREA' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'SOUTH KOREA' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'SINGAPORE' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'SRI LANKA' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'TAIWAN' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'THAILAND' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'VIETNAM' THEN 'ASIAN PACIFIC RIM' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'ALGERIA' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'CAMEROON' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'COMOROS' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'EGYPT' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'ETHIOPIA' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'GABON' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'GHANA' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'GUINEA' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'KENYA' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'MALAWI' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'MALI' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'MAURITIUS' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'MOROCCO' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'NIGERIA' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'RWANDA' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'SENEGAL' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'SIERRA LEONE' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'SOUTH AFRICA' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'SUDAN' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'TANZANIA' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'THE GAMBIA' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'TOGO' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'TUNISIA' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'UGANDA' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'ZAMBIA' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'ZIMBABWE' THEN 'AFRICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'CAYMAN ISLANDS' THEN 'CARIBBEAN' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'DOMINICAN REPUBLIC' THEN 'CARIBBEAN' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'GUADELOUPE' THEN 'CARIBBEAN' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'HAITI' THEN 'CARIBBEAN' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'JAMAICA' THEN 'CARIBBEAN' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'MARTINIQUE' THEN 'CARIBBEAN' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'NETHERLANDS ANTILLES' THEN 'CARIBBEAN' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'Saint Martin' THEN 'CARIBBEAN' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'TRINIDAD AND TOBAGO' THEN 'CARIBBEAN' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'AUSTRIA' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'AZERBAIJAN' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'BELGIUM' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'BELARUS' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'BOSNIA & HERZEGOVINA' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'BOSNIA-HERZEGOVINA' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'BULGARIA' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'CROATIA' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'CZECH REPUBLIC' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'DENMARK' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'FINLAND' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'FRANCE' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'GERMANY' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'GERMANY, FEDERAL REPUBLIC OF' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'GREECE' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'HUNGARY' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'ICELAND' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'IRELAND' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'ITALY' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'LITHUANIA' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'LUXEMBOURG' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'MACEDONIA' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'MALTA' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'MONTENEGRO (Use MJ)' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'NETHERLANDS' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'NORWAY' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'POLAND' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'PORTUGAL' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'REPUBLIC OF GEORGIA' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'ROMANIA' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'RUSSIA' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'SERBIA' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'SLOVAKIA' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'SPAIN' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'SWEDEN' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'SWITZERLAND' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'UKRAINE' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'UNITED KINGDOM' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'UZBEKISTAN' THEN 'EUROPE' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'AFGHANISTAN' THEN 'MIDDLE EAST' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'BAHRAIN' THEN 'MIDDLE EAST' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'CYPRUS' THEN 'MIDDLE EAST' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'IRAN' THEN 'MIDDLE EAST' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'ISRAEL' THEN 'MIDDLE EAST' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'JORDAN' THEN 'MIDDLE EAST' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'KAZAKHSTAN' THEN 'MIDDLE EAST' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'KUWAIT' THEN 'MIDDLE EAST' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'LEBANON' THEN 'MIDDLE EAST' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'PAKISTAN' THEN 'MIDDLE EAST' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'QATAR' THEN 'MIDDLE EAST' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'SAUDI ARABIA' THEN 'MIDDLE EAST' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'SYRIA' THEN 'MIDDLE EAST' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'TURKEY' THEN 'MIDDLE EAST' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'UNITED ARAB EMIRATES' THEN 'MIDDLE EAST' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'UNITED ARAB EMIRATES (obsol' THEN 'MIDDLE EAST' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'BELIZE' THEN 'CENTRAL AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'COSTA RICA' THEN 'CENTRAL AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'EL SALVADOR' THEN 'CENTRAL AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'GUATEMALA' THEN 'CENTRAL AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'HONDURAS' THEN 'CENTRAL AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'NICARAGUA' THEN 'CENTRAL AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'PANAMA' THEN 'CENTRAL AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'ARGENTINA' THEN 'SOUTH AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'BOLIVIA' THEN 'SOUTH AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'BRAZIL' THEN 'SOUTH AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'CHILE' THEN 'SOUTH AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'COLOMBIA' THEN 'SOUTH AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'ECUADOR' THEN 'SOUTH AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'GUYANA' THEN 'SOUTH AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'PARAGUAY' THEN 'SOUTH AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'PERU' THEN 'SOUTH AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'SURINAME' THEN 'SOUTH AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'URUGUAY' THEN 'SOUTH AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'VENEZUELA' THEN 'SOUTH AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'AMERICAN SAMOA (US STATE:AS)' THEN 'NORTH AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'CANADA' THEN 'NORTH AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'GUAM (US STATE: GU)' THEN 'NORTH AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'MEXICO' THEN 'NORTH AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'PUERTO RICO (US STATE: PR)' THEN 'NORTH AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'US MINOR OUTLYING ISLANDS (ob' THEN 'NORTH AMERICA' ELSE
IF USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTRY EQ 'UNITED STATES' THEN 'NORTH AMERICA';
END
-IF &COUNTRY EQ 'UNITED STATES' THEN GOTO USA
- ELSE IF &COUNTRY NE 'UNITED STATES' THEN GOTO NONUSA
- ELSE GOTO FINISH;
-USA
TABLE FILE USF_AA_ADDRESS
SUM
CNT.USF_AA_ADDRESS.USF_AA_ADDRESS.PIDM AS 'State Total'
BY USF_AA_ADDRESS.USF_AA_ADDRESS.State
SUM
CNT.USF_AA_ADDRESS.USF_AA_ADDRESS.PIDM AS 'County Total'
BY USF_AA_ADDRESS.USF_AA_ADDRESS.State
BY USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTY AS 'County'
SUM
CNT.USF_AA_ADDRESS.USF_AA_ADDRESS.PIDM AS 'City Total'
BY USF_AA_ADDRESS.USF_AA_ADDRESS.State
BY USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTY AS 'County'
BY USF_AA_ADDRESS.USF_AA_ADDRESS.CITY AS 'City'
WHERE USF_AA_ADDRESS.USF_AA_ADDRESS.ID NE MISSING;
WHERE USF_AA_ADDRESS.USF_AA_ADDRESS.STATE NE 'Unknown';
WHERE USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTY NE 'Unknown';
WHERE USF_AA_ADDRESS.USF_AA_ADDRESS.CITY NE 'Unknown';
WHERE ( USF_AA_ADDRESS.USF_AA_ADDRESS.DECEASED EQ 'N' ) OR ( USF_AA_ADDRESS.USF_AA_ADDRESS.DECEASED EQ MISSING );
WHERE COUNTRY EQ '&COUNTRY';
WHERE J2.USF_AA_DN_DT.DNC NE 'Y';
WHERE ( J2.USF_AA_DN_DT.ALUMNI_ALL EQ 'Y' ) OR ( J2.USF_AA_DN_DT.LOAN_MTN_ALUMNI EQ 'Y' );
WHERE J4.USF_AA_DN_DT.DNM EQ '&DNM.(,).Exclude Do Not Mail.';
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,
$
ENDSTYLE
END
-GOTO FINISH
-NONUSA
TABLE FILE USF_AA_ADDRESS
SUM
CNT.USF_AA_ADDRESS.USF_AA_ADDRESS.PIDM AS 'City Total'
BY USF_AA_ADDRESS.USF_AA_ADDRESS.CITY AS 'City'
WHERE COUNTRY EQ '&COUNTRY.(FIND COUNTRY IN USF_AA_ADDRESS).Select a Country.';
WHERE USF_AA_ADDRESS.USF_AA_ADDRESS.ID NE MISSING;
WHERE USF_AA_ADDRESS.USF_AA_ADDRESS.STATE NE 'Unknown';
WHERE USF_AA_ADDRESS.USF_AA_ADDRESS.COUNTY NE 'Unknown';
WHERE USF_AA_ADDRESS.USF_AA_ADDRESS.CITY NE 'Unknown';
WHERE ( USF_AA_ADDRESS.USF_AA_ADDRESS.DECEASED EQ 'N' ) OR ( USF_AA_ADDRESS.USF_AA_ADDRESS.DECEASED EQ MISSING );
WHERE COUNTRY EQ '&COUNTRY';
WHERE J2.USF_AA_DN_DT.DNC NE 'Y';
WHERE ( J2.USF_AA_DN_DT.ALUMNI_ALL EQ 'Y' ) OR ( J2.USF_AA_DN_DT.LOAN_MTN_ALUMNI EQ 'Y' );
WHERE J2.USF_AA_DN_DT.DNM EQ '&DNM.(,).Exclude Do Not Mail.';
ON TABLE SET PAGE-NUM OFF
ON TABLE SET EXPANDABLE ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
ENDSTYLE
END
-GOTO FINISH
-FINISH

----------------------------
----------------------------
I also tried removing:

WHERE J2.USF_AA_DN_DT.DNM EQ '&DNM.(,).Exclude Do Not Mail.';

from Alumni by State, but it didn't work either.



Thanks!
Aimee

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

7702, WinXP
Excel, HTML

Could you please, keep it Simple ?

You need to play with this piece of code only,

TYPE=DATA,
COLUMN=N4,
TARGET='iframe1',
FOCEXEC=app/alumni_by_state_5( \
COUNTRY=N3 \
DNM=N5 \
),
$

Just Type the variables &COUNTRY and &DNM, in alumni_by_state_5 fex and see what values are getting passed.

HOLY IF !!

I can't be helpful with the passing of variables issue, but you might find it much easier to map your countries to areas with DECODE and a separate file to hold the pair values.

TYPE=DATA,
COLUMN=N4,
TARGET='iframe1',
FOCEXEC=app/alumni_by_state_5( \
COUNTRY=N3 \
DNM=N5 \
),
$

Ensure that N4, N3 and N5 address the report columns you think they are - I prefer using the real column names rather than these positional ones.

Since it appears you're retrieving data from a relational database, I suggest you ask the powers that be to create two new tables - one for the Geographic Region and another for US States, then join to these two tables instead of using DEFINE.