n/a

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

quote:

JOIN INC_REPORT_NUMBER IN ISCDATA TO CRNUMBER IN VW_CALLS_FOR_SERVICE AS J3

Check your understanding of the JOIN statement.

T

quote:

Originally posted by Tony A:

quote:

JOIN INC_REPORT_NUMBER IN ISCDATA TO CRNUMBER IN VW_CALLS_FOR_SERVICE AS J3

Check your understanding of the JOIN statement.

T

Ok, I will do. Could you please provide me with the correct syntax to this

 CNT.DST.CRNUMBER/I9C AS 'CASECNT3' 

CRNUMBER IS A VARCHAR and I believe 'I9C' works with numbers, I tried CNT.DST.CRNUMBER/A8 AS 'CASECNT3', but am getting an error. What would be the correct syntax to count distinct Varchar variables. Thank you

quote:

JOIN INC_REPORT_NUMBER IN ISCDATA TO CRNUMBER IN VW_CALLS_FOR_SERVICE AS J3

It should be:

  
JOIN INC_REPORT_NUMBER IN PSBASSGN TO CRNUMBER IN VW_CALLS_FOR_SERVICE AS J3

quote:

CNT.DST.CRNUMBER/I9C AS 'CASECNT3'

What error did you get?

quote:

What error did you get?

I get the below error the field is not recognized:

(FOC003) THE FIELDNAME IS NOT RECOGNIZED: CASECNT3
BYPASSING TO END OF COMMAND
(FOC009) INCOMPLETE REQUEST STATEMENT

Here is the new updated code:

 

TABLE
ON TABLE HOLD AS CALLS
END

TABLE FILE CALLS
SUM
CNT.DST.CASENUMBER/A8 AS 'CASECNT3'
BY EVENTNUMBER
ON TABLE HOLD AS CALLS  FORMAT FOCUS INDEX CASENUMBER
END



SET ALL=ON
JOIN CAD_EMP_ID IN PSBASSGN TO CAD_EMP_ID IN OFFNSDAT AS J1
JOIN OFFNSDAT.CAD_EMP_ID IN PSBASSGN TO CAD_EMP_ID IN ISCDATA AS J2
JOIN INC_REPORT_NUMBER IN PSBASSGN TO CASENUMBER IN CALLS AS J3




DEFINE FILE PSBASSGN
APPROVAL_DATE1/YYMD = HDATE(APPROVAL_DATE,'YYMD');
DISPLAYDATE/YYMD=APPROVAL_DATE1;
END




TABLE FILE  PSBASSGN
HEADING CENTER
"&SUB_ASG"

PRINT UPLASTNAME AS ''

CASECNT AS 'Cases'
CASECNT2 AS 'Pending'
CASECNT3 AS 'Overdue'
INC_REPORT_NUMBER NOPRINT
CAD_EMP_ID NOPRINT
COMPUTE RANDOM_FOR_DRILLDOWN/D9.6 = RDNORM(RANDOM_FOR_DRILLDOWN); NOPRINT
INCIDENT_ID NOPRINT
BY RANK_ORDER NOPRINT
BY RANK_ABRV AS ''
WHERE REGION_ABRV_CH EQ '&DIVISION';
WHERE SUB_ASSIGNMENT EQ '&SUB_ASG';
WHERE RANK_ABRV NE 'CPT' OR 'LT';
 

1. Read the Manual



2. Read the Manual