GH1:ReportSelect
If {?Center} = 'HOPKINS' then 'HOPKINS'
ELSE
IF {?Center} = 'PORTLAND' THEN 'PORTLAND'
ELSE
IF {?Center} = 'ALL' THEN 'TOTAL SBLC'
ELSE
'MILWAUKEE'
with ?Center being a string of 4 values:HOPKINS,PORTLAND,MILWAUKEE,ALL
GH2: bankstate_number
"BANK" & " " & {ACCOUNTX.BANKSTATE_NUMBER}
GH3:
If {ACCOUNTX.DIVISION_CODE} in [001,002,012,014,015,018,022,619,042,043,044,045,046,047] then 'METRO' else 'COMMUNITY'
GH4:
"RISK RATING " & {RACCOUNT.USER_TEXT_1}
I changed my report to add a PARAMETER so the user could
select data by SITE:
The report selection criteria are:
{ACCOUNTX.OBLIGATION_NUMBER} <> " " and
{RACCTREL.REL_POS} = "1" and
iif({?Center}="Hopkins",({RACCOUNT.REASON_INTO_COL} in ["860","861","862","864"]) or
({RACCOUNT.REASON_INTO_COL}="869" and (({@Division} = 'COMMUNITY' and {ACCOUNTX.BANKSTATE_NUMBER} in ['23','25','60']) or
({@Division} = 'METRO' and {ACCOUNTX.BANKSTATE_NUMBER} = '63') or
({ACCOUNTX.BANKSTATE_NUMBER} in ['03','3','06','6','20','22','24','33','53','54','64','68','88']))),
iif({?Center}="Milwaukee",({RACCOUNT.REASON_INTO_COL} in ["858","863"]) or
({RACCOUNT.REASON_INTO_COL}="869" and (({@Division} = 'METRO' and {ACCOUNTX.BANKSTATE_NUMBER} in ['23','25','60']) or
({ACCOUNTX.BANKSTATE_NUMBER} in ['10','13','30','42','43']))),
iif({?Center}="Portland",({RACCOUNT.REASON_INTO_COL} in ["859","865"]) or
({RACCOUNT.REASON_INTO_COL}="869" and (({@Division} = 'COMMUNITY' and {ACCOUNTX.BANKSTATE_NUMBER} = '63') or
({ACCOUNTX.BANKSTATE_NUMBER} in ['02','2','29','55','59','66','71']))),
{RACCOUNT.REASON_INTO_COL} in ["869", "858", "859", "860", "861", "862", "863", "864", "865"]))) and
{RACCOUNT.USER_TEXT_1} in ["06", "07", "08", "09"]