When I add following code in my report I get FOC1400 and FOC1407 error codes.

WHERE AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.WEEKENDING EQ '&WEEKENDING.(FIND WEEKENDING,AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.WEEKENDING IN agg_arbyschool).WEEKENDING.';

Following is the procedure

 TABLE FILE AGG_ARBYSCHOOL
-*BY HIGHEST 1 MAXDATEWE NOPRINT
-*     
SUM 
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.0TO6DEBIT/P8C' AS ''
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.7TO13DEBIT/P8C' AS ''
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.14TO20DEBIT/P8C' AS ''
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.21TO27DEBIT/P8C' AS ''
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.OVER28DEBIT/P8C' AS ''
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.TOTALSPONSORDEBIT/P9C' AS ''
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.AGENCY0TO29DEBIT/P9C' AS ''
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.AGENCY30TO59DEBIT/P9C' AS ''
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.AGENCY60TO89DEBIT/P9C' AS ''
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.AGENCY90TO119DEBIT/P9C' AS ''
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.AGENCYOVER120DEBIT/P9C' AS ''
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.TOTALAGENCYDEBIT/P9C' AS ''
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.TOTALUNRECONCILED/P9C' AS '' OVER 
     COMPUTE NEWCOL/D6.1% = ( 0TO6DEBIT * 100 / TOTALSPONSORDEBIT ); AS ''
     COMPUTE NEWCOL/D6.1% = ( 100 * 7TO13DEBIT ) / TOTALSPONSORDEBIT; AS ''
     COMPUTE NEWCOL/D6.1% = ( 100 * 14TO20DEBIT ) / TOTALSPONSORDEBIT; AS ''
     COMPUTE NEWCOL/D6.1% = ( 100 * 21TO27DEBIT ) / TOTALSPONSORDEBIT; AS ''
     COMPUTE NEWCOL/D6.1% = ( 100 * OVER28DEBIT ) / TOTALSPONSORDEBIT; AS ''
     COMPUTE NEWCOL/D6.1% = ( 100 * TOTALSPONSORDEBIT ) / TOTALSPONSORDEBIT;
 AS ''
     COMPUTE NEWCOL/D6.1% = ( 100 * AGENCY0TO29DEBIT ) / TOTALAGENCYDEBIT;
 AS ''
     COMPUTE NEWCOL/D6.1% = ( 100 * AGENCY30TO59DEBIT ) / TOTALAGENCYDEBIT;
 AS ''
     COMPUTE NEWCOL/D6.1% = ( 100 * AGENCY60TO89DEBIT ) / TOTALAGENCYDEBIT;
 AS ''
     COMPUTE NEWCOL/D6.1% = ( 100 * AGENCY90TO119DEBIT ) / TOTALAGENCYDEBIT;
 AS ''
     COMPUTE NEWCOL/D6.1% = ( 100 * AGENCYOVER120DEBIT ) / TOTALAGENCYDEBIT;
 AS ''
     COMPUTE NEWCOL/D6.1% = ( 100 * TOTALAGENCYDEBIT ) / TOTALAGENCYDEBIT;
 AS ''
BY 'J0.DIM_SCHOOL.DIVISIONNAME' NOPRINT
BY 'J0.DIM_SCHOOL.DISTRICTNAME' AS ''
BY 'J0.DIM_SCHOOL.DISTRICTID' NOPRINT
BY 'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.SCHOOLID' NOPRINT
BY 'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.SCHOOLID' AS ''
-*BY HIGHEST 1 'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.MAXDATEWE' NOPRINT
     
ON J0.DIM_SCHOOL.DISTRICTNAME SUBTOTAL
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.0TO6DEBIT'
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.7TO13DEBIT'
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.14TO20DEBIT'
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.21TO27DEBIT'
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.OVER28DEBIT'
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.TOTALSPONSORDEBIT'
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.AGENCY0TO29DEBIT'
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.AGENCY30TO59DEBIT'
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.AGENCY60TO89DEBIT'
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.AGENCY90TO119DEBIT'
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.AGENCYOVER120DEBIT'
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.TOTALAGENCYDEBIT'
     'AGG_ARBYSCHOOL.AGG_ARBYSCHOOL.TOTALUNRECONCILED' AS ''
HEADING
"Accounts Receivable By School"
-*"<MAX.MAXDATEWE> </1"
" "
" "
"                                     Private                                                                           Agency"
"                                     Pay                                                                                 Pay"
" "
" <+0>District <+0>          School       <+0>0-6 <+0>   <+0>     7-13 <+0>     14-20 <+0>      21-27  <+0>       28+<+0>     Total<+0>        0-29       30-59      60-89 <+0>     90-119<+0>     120+  <+0>  Total <+0>     UNREC "
FOOTING
"Run Date <+0>&DATE <+0> <+0>                                                                                                                                                     Page<TABPAGENO of <TABLASTPAGE"

ON TABLE SET PAGE-NUM OFF 
ON TABLE NOTOTAL
 

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

As FOC1400 and FOC1407 are generic SQL errors, you will need to post the SQL error that comes with them.

If you have client tracing on, may be a good idea to check and post the generated SQL.

This error was caused by Metadate data type usage for two identical fields DATE/ Weekenddate where beign used as YYMD and A10.

So you had to fields names the same in the master, but with different formats ?