Hi guru's HELP!
Working a report with 2 types of utilization data, online services and case data. Key fields in each table are a client number which is joined to a third organization table containing client info.
I have a couple of parameter fields to pass in the client number value and then a date range.
Now my selection criteria primarily keys on the online services table:
{@online_services_date} = {?Date_Range} and
{online_services.EMP_NO} = {?Employer};
I can produce an online services summary on this boolean field I created:
local booleanvar curr_ol_services_type := {@online_services_date} = {?Date_range} and
{online_services.PRODUCT_ID} in [100002,100006,200006,200012];
if curr_EAP_type then 1 else 0;
Now! The problem happens when I try to use any of the data from the other case table. I created a boolean value to count similar to the one above:
local booleanvar test_EAP_cases :=
Date({CASE.CASE_OPENED_DATE}) = {?Date_Range}
and {CASE.SERVICE_ID} = 1 TO 22;
if test_EAP_cases then 1 else 0;
Now when I try to lay a summary field for this other case table onto the report with data already showing from the online services table, the report data blanks out? The joins are only inner from the online services table to the organization and the cases table to the organization through the client number, client division number and client location. Here's a copy of the query...
SELECT "ONLINE_SERVICES"."EVENT_DATE",
"ONLINE_SERVICES"."CLIENT_NO",
"ONLINE_SERVICES"."PRODUCT_ID"
FROM "ONLINE_SERVICES"
WHERE "ONLINE_SERVICES"."CLIENT_NO"='1428'
What's also totally weird about this obviously is that the third table I mention (CASES) doesn't even show up.
Where in the heck am I going wrong? Thanks in advance for any help!
The path up and down is one and the same.
-Heraclitus
Working a report with 2 types of utilization data, online services and case data. Key fields in each table are a client number which is joined to a third organization table containing client info.
I have a couple of parameter fields to pass in the client number value and then a date range.
Now my selection criteria primarily keys on the online services table:
{@online_services_date} = {?Date_Range} and
{online_services.EMP_NO} = {?Employer};
I can produce an online services summary on this boolean field I created:
local booleanvar curr_ol_services_type := {@online_services_date} = {?Date_range} and
{online_services.PRODUCT_ID} in [100002,100006,200006,200012];
if curr_EAP_type then 1 else 0;
Now! The problem happens when I try to use any of the data from the other case table. I created a boolean value to count similar to the one above:
local booleanvar test_EAP_cases :=
Date({CASE.CASE_OPENED_DATE}) = {?Date_Range}
and {CASE.SERVICE_ID} = 1 TO 22;
if test_EAP_cases then 1 else 0;
Now when I try to lay a summary field for this other case table onto the report with data already showing from the online services table, the report data blanks out? The joins are only inner from the online services table to the organization and the cases table to the organization through the client number, client division number and client location. Here's a copy of the query...
SELECT "ONLINE_SERVICES"."EVENT_DATE",
"ONLINE_SERVICES"."CLIENT_NO",
"ONLINE_SERVICES"."PRODUCT_ID"
FROM "ONLINE_SERVICES"
WHERE "ONLINE_SERVICES"."CLIENT_NO"='1428'
What's also totally weird about this obviously is that the third table I mention (CASES) doesn't even show up.
Where in the heck am I going wrong? Thanks in advance for any help!
The path up and down is one and the same.
-Heraclitus