I apologize in advance for the size of this. Here is the record selector:
If IsNull({?FunctionalArea}) Then
(
({APPROVAL.GROUP_ID} In ['XXX-CHGCOM','XXX-BWSUPPORT','XXX-BWAPPROVAL','XXX-DrillingSup','XXX-DrillApprov','XXX-FISUPPORT','XXX-FIAPPROVAL','XXX-HRSUPPORT','XXX-HRAPPROVAL','XXX-MMPMSUPPORT','XXX-MMPMAPPROVE','XXX-PRASUPPORT','XXX-PRAAPPROVAL','XXX-PROJAPPROVE','XXX-SECSUPPORT','XXX-SECAPPROVAL','XXX-TECHSUPPORT','XXX-TECHAPPROVE','XXX-TERASSUP','XXX-TERASAPPROV','XXX-TOBINAPPSUP','XXX-TOBINAPPROV','XXX-TOWSUPPORT','XXX-TOWAPPROVAL'] Or
{CHANGE.ASSIGNEE_GROUP} In ['XXX-CHGCOM','XXX-BWSUPPORT','XXX-BWAPPROVAL','XXX-DrillingSup','XXX-DrillApprov','XXX-FISUPPORT','XXX-FIAPPROVAL','XXX-HRSUPPORT','XXX-HRAPPROVAL','XXX-MMPMSUPPORT','XXX-MMPMAPPROVE','XXX-PRASUPPORT','XXX-PRAAPPROVAL','XXX-PROJAPPROVE','XXX-SECSUPPORT','XXX-SECAPPROVAL','XXX-TECHSUPPORT','XXX-TECHAPPROVE','XXX-TERASSUP','XXX-TERASAPPROV','XXX-TOBINAPPSUP','XXX-TOBINAPPROV','XXX-TOWSUPPORT','XXX-TOWAPPROVAL'] Or
{CHANGE.REQUESTER_GROUP} In ['XXX-CHGCOM','XXX-BWSUPPORT','XXX-BWAPPROVAL','XXX-DrillingSup','XXX-DrillApprov','XXX-FISUPPORT','XXX-FIAPPROVAL','XXX-HRSUPPORT','XXX-HRAPPROVAL','XXX-MMPMSUPPORT','XXX-MMPMAPPROVE','XXX-PRASUPPORT','XXX-PRAAPPROVAL','XXX-PROJAPPROVE','XXX-SECSUPPORT','XXX-SECAPPROVAL','XXX-TECHSUPPORT','XXX-TECHAPPROVE','XXX-TERASSUP','XXX-TERASAPPROV','XXX-TOBINAPPSUP','XXX-TOBINAPPROV','XXX-TOWSUPPORT','XXX-TOWAPPROVAL']) And
(
{CHANGE.RECORD_STATUS} = 'CLOSED' And
(
{CHANGE.START_DATE} In LastFullMonth
)
Or
{CHANGE.CLOSED_DATE} In LastFullMonth
)
)
Or
(
{CHANGE.RECORD_STATUS} <> 'CLOSED' And
{CHANGE.START_DATE} In LastYearMTD
)
Else If {?FunctionalArea} = 'TERAS' Then
(
({APPROVAL.GROUP_ID} In ['XXX-TERASSUP','XXX-TERASAPPROV'] Or
{CHANGE.ASSIGNEE_GROUP} In ['XXX-TERASSUP','XXX-TERASAPPROV'] Or
{CHANGE.REQUESTER_GROUP} In ['XXX-TERASSUP','XXX-TERASAPPROV']) And
(
{CHANGE.RECORD_STATUS} = 'CLOSED' And
(
{CHANGE.START_DATE} In LastFullMonth
)
Or
{CHANGE.CLOSED_DATE} In LastFullMonth
)
)
Or
(
{CHANGE.RECORD_STATUS} <> 'CLOSED' And
{CHANGE.START_DATE} In LastYearMTD
)
Here is the SQL:
SELECT
CHANGE."CHANGE_ID", CHANGE."RISK_CODE", CHANGE."NAME", CHANGE."PLAN_ST_DATE", CHANGE."PLAN_ST_TIME", CHANGE."START_DATE", CHANGE."START_TIME", CHANGE."ASSIGNEE_GROUP", CHANGE."CLOSED_DATE", CHANGE."CLOSED_TIME", CHANGE."ESTIMATED_DURATION", CHANGE."RECORD_STATUS", CHANGE."REQUESTER_GROUP",
PEOPLE."LAST_NAME", PEOPLE."FIRST_NAME",
APPROVAL."APPROVAL_DATE", APPROVAL."APPROVAL_TIME", APPROVAL."GROUP_ID"
FROM
"IGSVIEW"."CHANGE" CHANGE INNER JOIN "IGSVIEW"."APPROVAL" APPROVAL ON
CHANGE."CHANGE_ID" = APPROVAL."CHANGE_ID" LEFT JOIN "IGSVIEW"."PEOPLE" PEOPLE ON
CHANGE."ASSIGNED_TO" = PEOPLE."PEOPLE_ID"
WHERE
(CHANGE."ASSIGNEE_GROUP" In ('XXX-CHGCOM','XXX-BWSUPPORT','XXX-BWAPPROVAL','XXX-DrillingSup','XXX-DrillApprov','XXX-FISUPPORT','XXX-FIAPPROVAL','XXX-HRSUPPORT','XXX-HRAPPROVAL','XXX-MMPMSUPPORT','XXX-MMPMAPPROVE','XXX-PRASUPPORT','XXX-PRAAPPROVAL','XXX-PROJAPPROVE','XXX-SECSUPPORT','XXX-SECAPPROVAL','XXX-TECHSUPPORT','XXX-TECHAPPROVE','XXX-TERASSUP','XXX-TERASAPPROV','XXX-TOBINAPPSUP','XXX-TOBINAPPROV','XXX-TOWSUPPORT','XXX-TOWAPPROVAL') Or APPROVAL."GROUP_ID" In ('XXX-CHGCOM','XXX-BWSUPPORT','XXX-BWAPPROVAL','XXX-DrillingSup','XXX-DrillApprov','XXX-FISUPPORT','XXX-FIAPPROVAL','XXX-HRSUPPORT','XXX-HRAPPROVAL','XXX-MMPMSUPPORT','XXX-MMPMAPPROVE','XXX-PRASUPPORT','XXX-PRAAPPROVAL','XXX-PROJAPPROVE','XXX-SECSUPPORT','XXX-SECAPPROVAL','XXX-TECHSUPPORT','XXX-TECHAPPROVE','XXX-TERASSUP','XXX-TERASAPPROV','XXX-TOBINAPPSUP','XXX-TOBINAPPROV','XXX-TOWSUPPORT','XXX-TOWAPPROVAL') Or CHANGE."REQUESTER_GROUP" In ('XXX-CHGCOM','XXX-BWSUPPORT','XXX-BWAPPROVAL','XXX-DrillingSup','XXX-DrillApprov','XXX-FISUPPORT','XXX-FIAPPROVAL','XXX-HRSUPPORT','XXX-HRAPPROVAL','XXX-MMPMSUPPORT','XXX-MMPMAPPROVE','XXX-PRASUPPORT','XXX-PRAAPPROVAL','XXX-PROJAPPROVE','XXX-SECSUPPORT','XXX-SECAPPROVAL','XXX-TECHSUPPORT','XXX-TECHAPPROVE','XXX-TERASSUP','XXX-TERASAPPROV','XXX-TOBINAPPSUP','XXX-TOBINAPPROV','XXX-TOWSUPPORT','XXX-TOWAPPROVAL'))
ORDER BY
CHANGE."START_DATE" ASC,
CHANGE."START_TIME" ASC,
CHANGE."CHANGE_ID" ASC
Thanks again for your help.