Hi Dell, For the report thats not showing up any Data i think probably there might be a restriction in the formula in the record selection formula that i am using.
SELECT
"CHECKS"."PAYMENT_FROM", "CHECKS"."CHECK_AMOUNT", "CHECKS"."ENTRY_DATE", "CHECKS"."NON_CASH_CHECK_NUMBER", "CHECKS_DISBURSEMENT"."RECOVERY_TRANSACTION_INTERNAL", "EVENT"."EVENT_ID", "EVENT_CASE"."DAMAGED_PARTY_LAST_NAME", "EVENT_CASE"."DAMAGED_PARTY_FIRST_NAME", "CLIENT"."CLIENT_NAME", "EVENT_END_USER"."ACTIVE_FLAG", "EVENT_END_USER"."OWNER_FLAG", "END_USER"."USER_REAL_NAME"
FROM
"IBC1_OWNER"."CHECKS" "CHECKS",
"IBC1_OWNER"."CHECKS_DISBURSEMENT" "CHECKS_DISBURSEMENT",
"IBC1_OWNER"."EVENT" "EVENT",
"IBC1_OWNER"."EVENT_CASE" "EVENT_CASE",
"IBC1_OWNER"."CLIENT" "CLIENT",
"IBC1_OWNER"."EVENT_END_USER" "EVENT_END_USER",
"IBC1_OWNER"."END_USER" "END_USER"
WHERE
"CHECKS"."PAYMENT_FROM" = "CHECKS_DISBURSEMENT"."PAYMENT_FROM"(+) AND
"CHECKS"."CHECK_NUMBER" = "CHECKS_DISBURSEMENT"."CHECK_NUMBER"(+) AND
"CHECKS_DISBURSEMENT"."EVENT_ID" = "EVENT"."EVENT_ID"(+) AND
"CHECKS_DISBURSEMENT"."EVENT_CASE_ID" = "EVENT_CASE"."EVENT_CASE_ID"(+) AND
"CHECKS_DISBURSEMENT"."EVENT_ID" = "EVENT_CASE"."EVENT_ID"(+) AND
"EVENT"."CLIENT_ID" = "CLIENT"."CLIENT_ID"(+) AND
"EVENT"."EVENT_ID" = "EVENT_END_USER"."EVENT_ID"(+) AND
"EVENT_END_USER"."END_USER_ID" = "END_USER"."END_USER_ID" AND
"CHECKS_DISBURSEMENT"."RECOVERY_TRANSACTION_INTERNAL" = '17' AND
"EVENT_END_USER"."OWNER_FLAG" = 'Y' AND
"EVENT_END_USER"."ACTIVE_FLAG" = 'Y' AND
"CHECKS"."ENTRY_DATE" >= TO_DATE ('31-08-2009 00:00:00', 'DD-MM-YYYY HH24:MI:SS') AND
"CHECKS"."ENTRY_DATE" <= TO_DATE ('01-09-2009 23:59:59', 'DD-MM-YYYY HH24:MI:SS')
ORDER BY
"CHECKS_DISBURSEMENT"."RECOVERY_TRANSACTION_INTERNAL" ASC
Thanks,
Nav