Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

For the life of me I cant figure out why I keep getting thi...


Sharon Nesset

Recommended Posts

For the life of me I cant figure out why I keep getting this error.

ERROR AT OR NEAR LINE 149 IN PROCEDURE PFLADHOCFOCEXEC * (FOC007) THE REQUEST STATEMENT DOES NOT CONTAIN A VERB

This is my foc exec: LINE 149 IS THE LAST LINE "end"

-SET &ECHO = ALL;

-*remove -TYPES and ECHO before moving to Prod

-DEFAULT &SEL_YEAR = 2020

-DEFAULT &Title=

-DEFAULTH &WHFLD=

-DEFAULT &CARRIER_TYPE= _FOC_NULL

-SET &CYEAR = EDIT(&YYMD, 9999);

-SET &LYEAR = &SEL_YEAR - 1;

-SET &MAX_YEAR = &CYEAR - 3;

-SET &CARRIER_TYPE=IF &CARRIER_TYPE.EVAL EQ _FOC_NULL THEN _FOC_NULL ELSE

 

 

IF '&CARRIER_TYPE.EVAL' EQ 'BH' THEN '''2F'' OR ''F'' OR ''BH''' ELSE '''0'' OR ''ARR'' OR ''CC'' OR ''IB'' OR ''ITB'' OR ''LTL'' OR ''LUM'' OR ''PAL'' OR ''PB'' OR ''PD'' OR ''PRO'' OR ''TPB'' OR ''UL'' OR ''UNK''' ;

 

 

 

-SET &LEN = &RP_FN44S_Sum44.LENGTH;

-SET &WHFLD = IF &RP_FN44S_Sum44 EQ _FOC_NULL THEN _FOC_NULL ELSE STRIP(&LEN,&RP_FN44S_Sum44, ,&WHFLD);

--TYPE &WHFLD.EVAL

--TYPE &RP_FN44S_Sum44

-SET &LASTYEAR=IF &WHFLD.EVAL EQ _FOC_NULL THEN &SEL_YEAR ELSE &LYEAR;

-*-TYPE &LASTYEAR

-RUN

DEFINE FILE PFL_MAIN

FEES_CY/P12C:d=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ &SEL_YEAR THEN PFL_MAIN.PFL_LOAD_DTL.FEE_BRIDGED_TOTAL ELSE 0;

FEES_BH_CY/P12C:d=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ &SEL_YEAR THEN PFL_MAIN.PFL_LOAD_DTL.FEE_BRIDGED_BH ELSE 0;

FEES_CC_CY/P12C:d=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ &SEL_YEAR THEN PFL_MAIN.PFL_LOAD_DTL.FEE_BRIDGED_CC ELSE 0;

FEES_LY/P12C:d=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ &LYEAR THEN PFL_MAIN.PFL_LOAD_DTL.FEE_BRIDGED_TOTAL ELSE 0;

FEES_BH_LY/P12C:d=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ &LYEAR THEN PFL_MAIN.PFL_LOAD_DTL.FEE_BRIDGED_BH ELSE 0;

FEES_CC_LY/P12C:d=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ &LYEAR THEN PFL_MAIN.PFL_LOAD_DTL.FEE_BRIDGED_CC ELSE 0;

SAVINGS_CY/P12C:d=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ &SEL_YEAR THEN PFL_MAIN.PFL_LOAD_DTL.SAVINGS_BRIDGED_TOTAL ELSE 0;

SAVINGS_BH_CY/P12C:d=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ &SEL_YEAR THEN PFL_MAIN.PFL_LOAD_DTL.SAVINGS_BRIDGED_BH ELSE 0;

SAVINGS_CC_CY/P12C:d=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ &SEL_YEAR THEN PFL_MAIN.PFL_LOAD_DTL.SAVINGS_BRIDGED_CC ELSE 0;

SAVINGS_LY/P12C:d=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ &LYEAR THEN PFL_MAIN.PFL_LOAD_DTL.SAVINGS_BRIDGED_TOTAL ELSE 0;

SAVINGS_BH_LY/P12C:d=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ &LYEAR THEN PFL_MAIN.PFL_LOAD_DTL.SAVINGS_BRIDGED_BH ELSE 0;

SAVINGS_CC_LY/P12C:d=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ &LYEAR THEN PFL_MAIN.PFL_LOAD_DTL.SAVINGS_BRIDGED_CC ELSE 0;

FREIGHT_CY/P12C:d=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ &SEL_YEAR THEN PFL_MAIN.PFL_LOAD_DTL.FREIGHT_BRIDGED_TOTAL ELSE 0;

FREIGHT_BH_CY/P12C:d=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ &SEL_YEAR THEN PFL_MAIN.PFL_LOAD_DTL.FREIGHT_BRIDGED_BH ELSE 0;

FREIGHT_CC_CY/P12C:d=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ &SEL_YEAR THEN PFL_MAIN.PFL_LOAD_DTL.FREIGHT_BRIDGED_CC ELSE 0;

FREIGHT_LY/P12C:d=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ &LYEAR THEN PFL_MAIN.PFL_LOAD_DTL.FREIGHT_BRIDGED_TOTAL ELSE 0;

FREIGHT_BH_LY/P12C:d=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ &LYEAR THEN PFL_MAIN.PFL_LOAD_DTL.FREIGHT_BRIDGED_BH ELSE 0;

FREIGHT_CC_LY/P12C:d=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ &LYEAR THEN PFL_MAIN.PFL_LOAD_DTL.FREIGHT_BRIDGED_CC ELSE 0;

CASES_CY/P12C=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ &SEL_YEAR THEN PFL_MAIN.PFL_LOAD_DTL.CASES ELSE 0;

CASES_LY/P12C=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ &LYEAR THEN PFL_MAIN.PFL_LOAD_DTL.CASES ELSE 0;

WEIGHT_CY/P12C=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ &SEL_YEAR THEN PFL_MAIN.PFL_LOAD_DTL.WEIGHT ELSE 0;

WEIGHT_LY/P12C=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ &LYEAR THEN PFL_MAIN.PFL_LOAD_DTL.WEIGHT ELSE 0;

LOAD_COUNT_CY/P12C=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ &SEL_YEAR THEN PFL_MAIN.PFL_LOAD_DTL.LOAD_COUNT_TOTAL ELSE 0;

LOAD_COUNT_BH_CY/P12C=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ &SEL_YEAR THEN PFL_MAIN.PFL_LOAD_DTL.LOAD_COUNT_BH ELSE 0;

LOAD_COUNT_CC_CY/P12C=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ &SEL_YEAR THEN PFL_MAIN.PFL_LOAD_DTL.LOAD_COUNT_CC ELSE 0;

LOAD_COUNT_LY/P12C=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ &LYEAR THEN PFL_MAIN.PFL_LOAD_DTL.LOAD_COUNT_TOTAL ELSE 0;

LOAD_COUNT_BH_LY/P12C=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ &LYEAR THEN PFL_MAIN.PFL_LOAD_DTL.LOAD_COUNT_BH ELSE 0;

LOAD_COUNT_CC_LY/P12C=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ &LYEAR THEN PFL_MAIN.PFL_LOAD_DTL.LOAD_COUNT_CC ELSE 0;

PO_COUNT_CY/P12C=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ &SEL_YEAR THEN PFL_MAIN.PFL_LOAD_DTL.PO_COUNT_TOTAL ELSE 0;

PO_COUNT_BH_CY/P12C=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ &SEL_YEAR THEN PFL_MAIN.PFL_LOAD_DTL.PO_COUNT_BH ELSE 0;

PO_COUNT_CC_CY/P12C=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ &SEL_YEAR THEN PFL_MAIN.PFL_LOAD_DTL.PO_COUNT_CC ELSE 0;

PO_COUNT_LY/P12C=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ &LYEAR THEN PFL_MAIN.PFL_LOAD_DTL.PO_COUNT_TOTAL ELSE 0;

PO_COUNT_BH_LY/P12C=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ &LYEAR THEN PFL_MAIN.PFL_LOAD_DTL.PO_COUNT_BH ELSE 0;

PO_COUNT_CC_LY/P12C=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ &LYEAR THEN PFL_MAIN.PFL_LOAD_DTL.PO_COUNT_CC ELSE 0;

ALLOW_CY/P12C:d = SAVINGS_CY + FREIGHT_CY + FEES_CY;

ALLOW_LY/P12C:d = SAVINGS_LY + FREIGHT_LY + FEES_LY;

ALLOW_VAR/P12C:d = ALLOW_CY - ALLOW_LY;

SAVINGS_VAR/P12C:d = SAVINGS_CY - SAVINGS_LY;

FREIGHT_VAR/P12C:d = FREIGHT_CY - FREIGHT_LY;

FEES_VAR/P12C:d = FEES_CY - FEES_LY;

LOAD_COUNT_VAR/P12C:d = LOAD_COUNT_CY - LOAD_COUNT_LY;

PO_COUNT_VAR/P12C:d = PO_COUNT_CY - PO_COUNT_LY;

CASES_VAR/P12C:d = CASES_CY - CASES_LY;

WEIGHT_VAR/P12C:d = WEIGHT_CY - WEIGHT_LY;

CarrierType/A3=IF PFL_MAIN.CARRIER_DIMENSION.CARRIER_TYPE EQ F OR 2F OR BH THEN BH ELSE CC;

END

TABLE FILE PFL_MAIN

SUM

&RP_FN36S_Sum36.(AND(<All,_FOC_NULL>,<Allowance,PFL_MAIN.DATE_DIMENSION.ALLOW_CY>,<Savings,PFL_MAIN.DATE_DIMENSION.SAVINGS_CY>,<Freight,PFL_MAIN.DATE_DIMENSION.FREIGHT_CY>,<Fees,PFL_MAIN.DATE_DIMENSION.FEES_CY>,<Load Count,PFL_MAIN.DATE_DIMENSION.LOAD_COUNT_CY>,<PO Count,PFL_MAIN.DATE_DIMENSION.PO_COUNT_CY>,<Cases,PFL_MAIN.DATE_DIMENSION.CASES_CY>,<Weight,PFL_MAIN.DATE_DIMENSION.WEIGHT_CY>)).Current Year.

&RP_FN44S_Sum44.(AND(<All,_FOC_NULL>,<Allowance,PFL_MAIN.DATE_DIMENSION.ALLOW_LY>,<Savings,PFL_MAIN.DATE_DIMENSION.SAVINGS_LY>,<Freight,PFL_MAIN.DATE_DIMENSION.FREIGHT_LY>,<Fees,PFL_MAIN.DATE_DIMENSION.FEES_LY>,<Load Count,PFL_MAIN.DATE_DIMENSION.LOAD_COUNT_LY>,<PO Count,PFL_MAIN.DATE_DIMENSION.PO_COUNT_LY>,<Cases,PFL_MAIN.DATE_DIMENSION.CASES_LY>,<Weight,PFL_MAIN.DATE_DIMENSION.WEIGHT_LY>)).Last Year.

&RP_FN52S_Sum52.(AND(<All,_FOC_NULL>,<Allowance,PFL_MAIN.DATE_DIMENSION.ALLOW_VAR>,<Savings,PFL_MAIN.DATE_DIMENSION.SAVINGS_VAR>,<Freight,PFL_MAIN.DATE_DIMENSION.FREIGHT_VAR>,<Fees,PFL_MAIN.DATE_DIMENSION.FEES_VAR>,<Load Count,PFL_MAIN.DATE_DIMENSION.LOAD_COUNT_VAR>,<PO Count,PFL_MAIN.DATE_DIMENSION.PO_COUNT_VAR>,<Cases,PFL_MAIN.DATE_DIMENSION.CASES_VAR>,<Weight,PFL_MAIN.DATE_DIMENSION.WEIGHT_VAR>)).Variance.

BY LOWEST &RP_FN01B_Sort5.(BY(<All,_FOC_NULL>,<Member Name,PFL_MAIN.MEMBER_BRANCHES_DIMENSION_1.MbrName>,<Member #,PFL_MAIN.MEMBER_BRANCHES_DIMENSION_1.MbrNbr>,<Member Branch #,PFL_MAIN.MEMBER_BRANCHES_DIMENSION_1.MbrBrchNbr>,<License Code,PFL_MAIN.PFL_LOAD_DTL.LICENSE_CODE>,<License Name,PFL_MAIN.LICENSE_DIMENSION.LICENSE_NAME>,<Owner Code,PFL_MAIN.PFL_LOAD_DTL.OWNER_CODE>,<Owner Name,PFL_MAIN.PFL_LOAD_DTL.OWNER_NAME>)).Members.

BY LOWEST &RP_FN08B_Sort18.(BY(<All,_FOC_NULL>,<Load ID,PFL_MAIN.PFL_LOAD_DTL.LOAD_ID>,<Carrier Type,PFL_MAIN.CARRIER_DIMENSION.CARRIER_TYPE>,<Cashless Flag,PFL_MAIN.CARRIER_DIMENSION.CASHLESS_FLAG>,<Carrier Code,PFL_MAIN.CARRIER_DIMENSION.CARRIER_CODE>,<Carrier Name,PFL_MAIN.CARRIER_DIMENSION.CARRIER_NAME>,<Carrier City,PFL_MAIN.CARRIER_DIMENSION.CARRIER_CITY>,<Carrier State,PFL_MAIN.CARRIER_DIMENSION.CARRIER_STATE>,<Carrier Zip,PFL_MAIN.CARRIER_DIMENSION.CARRIER_ZIP>,<Trailer Type,PFL_MAIN.PFL_LOAD_DTL.TRAILER_TYPE>,<Temperature Type,PFL_MAIN.PFL_LOAD_DTL.TEMPERATURE_TYPE>)).Carriers.

BY LOWEST &RP_FN18B_Sort18.(BY(<All,_FOC_NULL>,<Vendor #,PFL_MAIN.PFL_LOAD_DTL.VENDOR_CODE>,<Vendor Name,PFL_MAIN.PFL_LOAD_DTL.VENDOR_NAME>)).Vendors.

BY LOWEST &RP_FN20B_Sort20.(BY(<All,_FOC_NULL>,<Consignee Name,PFL_MAIN.PFL_LOAD_DTL.CONSIGNEE_NAME>,<Consignee City,PFL_MAIN.PFL_LOAD_DTL.CONSIGNEE_CITY>,<Consignee State,PFL_MAIN.PFL_LOAD_DTL.CONSIGNEE_STATE>,<Consignee Zip,PFL_MAIN.PFL_LOAD_DTL.CONSIGNEE_ZIP>)).Consignees.

BY LOWEST &RP_FN24B_Sort24.(BY(<All,_FOC_NULL>,<Facility Name,PFL_MAIN.PFL_LOAD_DTL.FACILITY_NAME>,<Facility City,PFL_MAIN.PFL_LOAD_DTL.FACILITY_CITY>,<Facility State,PFL_MAIN.PFL_LOAD_DTL.FACILITY_STATE>,<Facility Zip,PFL_MAIN.PFL_LOAD_DTL.FACILITY_ZIP>)).Facilities.

BY LOWEST &RP_FN28B_Sort28.(BY(<All,_FOC_NULL>,<RLM,PFL_MAIN.RLM_DIMENSION.RLM_NAME>,<Year,PFL_MAIN.DATE_DIMENSION.PTYEAR>,<Month,PFL_MAIN.DATE_DIMENSION.PTPERIOD>,<Week,PFL_MAIN.DATE_DIMENSION.PTWEEK>,<Due Date,PFL_MAIN.PFL_LOAD_DTL.DUE_DATE>,<Invoice Date,PFL_MAIN.PFL_LOAD_DTL.INVOICE_DATE>,<Audit Date,PFL_MAIN.PFL_LOAD_DTL.AUDIT_DATE>,<PO #,PFL_MAIN.PFL_LOAD_DTL.PO_NUMBER>)).Miscellaneous.

-*ACROSS LOWEST &RP_FN01A_SortAcross1.(ACROSS(<Year,PFL_MAIN.DATE_DIMENSION.PTYEAR>)).Year Across.

-*WHERE RECORDLIMIT EQ 1000

-*WHERE READLIMIT EQ 1000

ON TABLE SUBHEAD

&Title

ON TABLE SUBFOOT

&SEL_YEAR &PTPERIOD &PTWEEK &RLM_NAME &CARRIER_TYPE

WHERE ( PFL_MAIN.DATE_DI

Link to comment
Share on other sites

BTW VERSION 8205 - Here is the echo - ty

WebFOCUS Error Executing body { font-family: Tahoma, Geneva, sans-serif; color: #464C57; margin: 0; text-align: center; } .errorContainer { display: block; flex-direction: column; justify-items: center; justify-content: flex-start; align-items: center; max-width: 600px; margin: auto; } .errorTitle { font-size: 20px; display: block; margin: 30px 20px 0 } .errorMain { font-size: 18px; display: block; margin: 30px 20px 0 } .errorMore { font-size: 14px; text-align: left } .errorMsg { font-size: 14px } .errorList { font-size: 14px } .errorDetail { font-size: 14px; display: block; margin: 0 20px 10px; flex-direction: column; text-align: left } pre { text-align: left; color: #666; font-size: 12px; font-weight: normal; margin: 5px 0 10px } pre b { font-weight: normal; } .showDetail { font-size: 14px; margin-top:10px } a:link, a:visited, a:active { color: #337ab7; text-decoration: none } a:hover { text-decoration: underline } h5 { text-align: left; margin: 10px 0 0; }

-DEFAULT &SEL_YEAR = 2020 -DEFAULT &Title= -DEFAULTH &WHFLD= -DEFAULT &CARRIER_TYPE= _FOC_NULL -SET &CYEAR = EDIT(20210817, 9999); -SET &LYEAR = 2020 - 1; -SET &MAX_YEAR = 2021 - 3; -SET &CARRIER_TYPE=IF _FOC_NULL EQ _FOC_NULL THEN _FOC_NULL ELSE - IF _FOC_NULL EQ BH THEN 2F OR F OR BH ELSE 0 OR ARR OR CC OR IB OR ITB OR LTL OR LUM OR PAL OR PB OR PD OR PRO OR TPB OR UL OR UNK ; -SET &LEN = 09; -SET &WHFLD = IF _FOC_NULL EQ _FOC_NULL THEN _FOC_NULL ELSE STRIP(09,_FOC_NULL, ,&WHFLD); --TYPE &WHFLD.EVAL --TYPE &RP_FN44S_Sum44 -SET &LASTYEAR=IF _FOC_NULL EQ _FOC_NULL THEN 2020 ELSE 2019; -*-TYPE &LASTYEAR -RUN DEFINE FILE PFL_MAIN FEES_CY/P12C:d=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ 2020 THEN PFL_MAIN.PFL_LOAD_DTL.FEE_BRIDGED_TOTAL ELSE 0; FEES_BH_CY/P12C:d=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ 2020 THEN PFL_MAIN.PFL_LOAD_DTL.FEE_BRIDGED_BH ELSE 0; FEES_CC_CY/P12C:d=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ 2020 THEN PFL_MAIN.PFL_LOAD_DTL.FEE_BRIDGED_CC ELSE 0; FEES_LY/P12C:d=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ 2019 THEN PFL_MAIN.PFL_LOAD_DTL.FEE_BRIDGED_TOTAL ELSE 0; FEES_BH_LY/P12C:d=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ 2019 THEN PFL_MAIN.PFL_LOAD_DTL.FEE_BRIDGED_BH ELSE 0; FEES_CC_LY/P12C:d=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ 2019 THEN PFL_MAIN.PFL_LOAD_DTL.FEE_BRIDGED_CC ELSE 0; SAVINGS_CY/P12C:d=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ 2020 THEN PFL_MAIN.PFL_LOAD_DTL.SAVINGS_BRIDGED_TOTAL ELSE 0; SAVINGS_BH_CY/P12C:d=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ 2020 THEN PFL_MAIN.PFL_LOAD_DTL.SAVINGS_BRIDGED_BH ELSE 0; SAVINGS_CC_CY/P12C:d=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ 2020 THEN PFL_MAIN.PFL_LOAD_DTL.SAVINGS_BRIDGED_CC ELSE 0; SAVINGS_LY/P12C:d=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ 2019 THEN PFL_MAIN.PFL_LOAD_DTL.SAVINGS_BRIDGED_TOTAL ELSE 0; SAVINGS_BH_LY/P12C:d=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ 2019 THEN PFL_MAIN.PFL_LOAD_DTL.SAVINGS_BRIDGED_BH ELSE 0; SAVINGS_CC_LY/P12C:d=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ 2019 THEN PFL_MAIN.PFL_LOAD_DTL.SAVINGS_BRIDGED_CC ELSE 0; FREIGHT_CY/P12C:d=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ 2020 THEN PFL_MAIN.PFL_LOAD_DTL.FREIGHT_BRIDGED_TOTAL ELSE 0; FREIGHT_BH_CY/P12C:d=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ 2020 THEN PFL_MAIN.PFL_LOAD_DTL.FREIGHT_BRIDGED_BH ELSE 0; FREIGHT_CC_CY/P12C:d=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ 2020 THEN PFL_MAIN.PFL_LOAD_DTL.FREIGHT_BRIDGED_CC ELSE 0; FREIGHT_LY/P12C:d=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ 2019 THEN PFL_MAIN.PFL_LOAD_DTL.FREIGHT_BRIDGED_TOTAL ELSE 0; FREIGHT_BH_LY/P12C:d=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ 2019 THEN PFL_MAIN.PFL_LOAD_DTL.FREIGHT_BRIDGED_BH ELSE 0; FREIGHT_CC_LY/P12C:d=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ 2019 THEN PFL_MAIN.PFL_LOAD_DTL.FREIGHT_BRIDGED_CC ELSE 0; CASES_CY/P12C=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ 2020 THEN PFL_MAIN.PFL_LOAD_DTL.CASES ELSE 0; CASES_LY/P12C=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ 2019 THEN PFL_MAIN.PFL_LOAD_DTL.CASES ELSE 0; WEIGHT_CY/P12C=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ 2020 THEN PFL_MAIN.PFL_LOAD_DTL.WEIGHT ELSE 0; WEIGHT_LY/P12C=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ 2019 THEN PFL_MAIN.PFL_LOAD_DTL.WEIGHT ELSE 0; LOAD_COUNT_CY/P12C=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ 2020 THEN PFL_MAIN.PFL_LOAD_DTL.LOAD_COUNT_TOTAL ELSE 0; LOAD_COUNT_BH_CY/P12C=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ 2020 THEN PFL_MAIN.PFL_LOAD_DTL.LOAD_COUNT_BH ELSE 0; LOAD_COUNT_CC_CY/P12C=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ 2020 THEN PFL_MAIN.PFL_LOAD_DTL.LOAD_COUNT_CC ELSE 0; LOAD_COUNT_LY/P12C=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ 2019 THEN PFL_MAIN.PFL_LOAD_DTL.LOAD_COUNT_TOTAL ELSE 0; LOAD_COUNT_BH_LY/P12C=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ 2019 THEN PFL_MAIN.PFL_LOAD_DTL.LOAD_COUNT_BH ELSE 0; LOAD_COUNT_CC_LY/P12C=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ 2019 THEN PFL_MAIN.PFL_LOAD_DTL.LOAD_COUNT_CC ELSE 0; PO_COUNT_CY/P12C=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ 2020 THEN PFL_MAIN.PFL_LOAD_DTL.PO_COUNT_TOTAL ELSE 0; PO_COUNT_BH_CY/P12C=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ 2020 THEN PFL_MAIN.PFL_LOAD_DTL.PO_COUNT_BH ELSE 0; PO_COUNT_CC_CY/P12C=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ 2020 THEN PFL_MAIN.PFL_LOAD_DTL.PO_COUNT_CC ELSE 0; PO_COUNT_LY/P12C=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ 2019 THEN PFL_MAIN.PFL_LOAD_DTL.PO_COUNT_TOTAL ELSE 0; PO_COUNT_BH_LY/P12C=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ 2019 THEN PFL_MAIN.PFL_LOAD_DTL.PO_COUNT_BH ELSE 0; PO_COUNT_CC_LY/P12C=IF PFL_MAIN.DATE_DIMENSION.PTYEAR EQ 2019 THEN PFL_MAIN.PFL_LOAD_DTL.PO_COUNT_CC ELSE 0; ALLOW_CY/P12C:d = SAVINGS_CY + FREIGHT_CY + FEES_CY; ALLOW_LY/P12C:d = SAVINGS_LY + FREIGHT_LY + FEES_LY; ALLOW_VAR/P12C:d = ALLOW_CY - ALLOW_LY; SAVINGS_VAR/P12C:d = SAVINGS_CY - SAVINGS_LY; FREIGHT_VAR/P12C:d = FREIGHT_CY - FREIGHT_LY; FEES_VAR/P12C:d = FEES_CY - FEES_LY; LOAD_COUNT_VAR/P12C:d = LOAD_COUNT_CY - LOAD_COUNT_LY; PO_COUNT_VAR/P12C:d = PO_COUNT_CY - PO_COUNT_LY; CASES_VAR/P12C:d = CASES_CY - CASES_LY; WEIGHT_VAR/P12C:d = WEIGHT_CY - WEIGHT_LY; CarrierType/A3=IF PFL_MAIN.CARRIER_DIMENSION.CARRIER_TYPE EQ F OR 2F OR BH THEN BH ELSE CC; END TABLE FILE PFL_MAIN SUM _FOC_NULL _FOC_NULL _FOC_NULL BY LOWEST _FOC_NULL BY LOWEST _FOC_NULL BY LOWEST _FOC_NULL BY LOWEST _FOC_NULL BY LOWEST _FOC_NULL BY LOWEST _FOC_NULL -*ACROSS LOWEST &RP_FN01A_SortAcross1.(ACROSS(<Year,PFL_MAIN.DATE_DIMENSION.PTYEAR>)).Year Across. -*WHERE RECORDLIMIT EQ 1000 -*WHERE READLIMIT EQ 1000 ON TABLE SUBHEAD " " ON TABLE SUBFOOT 2020 _FOC_NULL _FOC_NULL _FOC_NULL _FOC_NULL WHERE ( PFL_MAIN.DATE_DIMENSION.PTYEAR EQ 2020 )OR( PFL_MAIN.DATE_DIMENSION.PTYEAR EQ 2020); WHERE ( PFL_MAIN.RLM_DIMENSION.RLM_NAME EQ _FOC_NULL); WHERE ( PFL_MAIN.CARRIER_DIMENSION.CarrierType EQ _FOC_NULL ); WHERE ( PFL_MAIN.DATE_DIMENSION.PTPERIOD EQ _FOC_NULL ); WHERE ( PFL_MAIN.DATE_DIMENSION.PTWEEK EQ _FOC_NULL ); WHERE ( PFL_MAIN.PFL_LOAD_DTL.LICENSE_CODE EQ 101); -WHERE ( PFL_MAIN.MEMBER_BRANCHES_DIMENSION_1.MbrStatus EQ A); ON TABLE SET ONFIELD IGNORE ON TABLE SET PAGE-NUM NOLEAD ON TABLE SET ASNAMES ON ON TABLE SET BYDISPLAY ON ON TABLE COLUMN-TOTAL ON TABLE PCHOLD FORMAT AHTML ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * -INCLUDE ENOrange_Medium2 $ Copyright 1996-2015 Information Builders, Inc. All rights reserved. - $Revision: 1.7 $ TYPE=REPORT, OBJECT=STATUS-AREA,COLOR=white,BACKCOLOR=RGB(247 150 70),$ TYPE=REPORT, OBJECT=CURRENT-ROW,HOVER-BACKCOLOR=RGB(247 150 70),BACKCOLOR=yellow,$ TYPE=REPORT, GRAPHCOLOR=green,GRAPHCOLORNEG=red,$ TYPE=REPORT, OBJECT=CALC-AREA, COLOR=white,BACKCOLOR=RGB(247 150 70), $ TYPE=REPORT, OBJECT=MENU, COLOR=white,BACKCOLOR=RGB(247 150 70),BORDER-COLOR=white,HOVER-COLOR=RGB(247 150 70),HOVER-BACKCOLOR=white,$ TYPE=REPORT, ARICONSET=WHITE, ARSTYLESET=biporange,$ *TABLE_STYLE TYPE=REPORT,FONT=TREBUCHET MS,SIZE=9,COLOR=BLACK,BACKCOLOR=WHITE,SQUEEZE=ON,GRID=OFF,$ TYPE=DATA,BACKCOLOR=(RGB(217 217 217) WHITE),$ TYPE=TITLE,BORDER-TOP=light,BORDER-BOTTOM=light,BORDER-TOP-COLOR=white,BORDER-BOTTOM-COLOR=white,STYLE=-UNDERLINE+BOLD,BACKCOLOR=RGB(247 150 70),COLOR=WHITE,$ TYPE=TABHEADING,SIZE=14,JUSTIFY=CENTER,COLOR=RGB(#484e57),$ TYPE=TABFOOTING,SIZE=12,JUSTIFY=CENTER,COLOR=RGB(#484e57),$ TYPE=HEADING,SIZE=12,JUSTIFY=CENTER,COLOR=RGB(#484e57),$ TYPE=FOOTING,SIZE=10,JUSTIFY=CENTER,COLOR=RGB(#484e57),$ TYPE=SUBHEAD,BORDER-TOP=light,BORDER-BOTTOM=light,BORDER-TOP-COLOR=white,BORDER-BOTTOM-COLOR=white,SIZE=10,STYLE=BOLD,BACKCOLOR=RGB(247 150 70),COLOR=WHITE,$ TYPE=SUBFOOT,BORDER-TOP=light,BORDER-BOTTOM=light,BORDER-TOP-COLOR=white,BORDER-BOTTOM-COLOR=white,SIZE=10,STYLE=BOLD,BACKCOLOR=RGB(247 150 70),COLOR=WHITE,$ TYPE=SUBTOTAL,BORDER-TOP=light,BORDER-TOP-COLOR=white,BACKCOLOR=RGB(247 150 70),COLOR=WHITE,STYLE=BOLD,$ TYPE=ACROSSVALUE,STYLE=BOLD,BACKCOLOR=RGB(247 150 70),COLOR=WHITE,$ TYPE=ACROSSTITLE,SIZE=9,STYLE=-UNDERLINE+BOLD,border-top=light, BORDER-TOP-COLOR=white,BACKCOLOR=RGB(247 150 70),COLOR=WHITE,$ TYPE=PAGENUM,SIZE=6,STYLE=ITALIC,JUSTIFY=RIGHT,$ TYPE=GRANDTOTAL,BORDER-TOP=LIGHT,BORDER-BOTTOM=HEAVY, BORDER-TOP-STYLE=SOLID,BORDER-BOTTOM-STYLE=DOUBLE,BORDER-COLOR=white,BACKCOLOR=RGB(247 150 70),COLOR=WHITE,STYLE=BOLD,$ *GRAPH_SCRIPT setFontStyle(getPieLabel(),2); setFillColor(getPieLabel(),new Color(#484e57)); setFillColor(getSeries(0),new Color(#E6833A)); setFillColor(getSeries(1),new Color(#E6C83A)); setFillColor(getSeries(2),new Color(#9CD335)); setFillColor(getSeries(3),new Color(#3199C4)); setFillColor(getSeries(4),new Color(#5331C4)); setFillColor(getSeries(5),new Color(#CE347E)); setSeriesLooping(6); setColorMode(4); setAutoColorLerpFactor(0.8); setTransparentBorderColor(getSeries(0),true); setTransparentBorderColor(getSeries(1),true); setTransparentBorderColor(getSeries(2),true); setTransparentBorderColor(getSeries(3),true); setTransparentBorderColor(getSeries(4),true); setTransparentBorderColor(getSeries(5),true); setTransparentBorderColor(getSeries(6),true); setTransp

Link to comment
Share on other sites

Hi Sharon

Looks like the message really should say

The Request Statement Does Not Contain a Verb Object (meaning a Fieldname).

APP PATH PREPENDPATH IBISAMP

TABLE FILE CAR

SUM

_FOC_NULL

BY _FOC_NULL

END

If I run this in 8207, I get the same error.

Id suggest adding a bogus field and NOPRINT it so your request always has one field in it.

See if that works for you. Or force the user to make at least one selection to avoid having all _FOC_NULLs.

Hope that helps.

Link to comment
Share on other sites

sharon.nesset:

 

TABLE FILE PFL_MAIN SUM _FOC_NULL _FOC_NULL _FOC_NULL BY LOWEST _FOC_NULL BY LOWEST _FOC_NULL BY LOWEST _FOC_NULL BY LOWEST _FOC_NULL BY LOWEST _FOC_NULL BY LOWEST _FOC_NULL

 

 

All your selection are _FOC_NULL

As stated by Toby, should force at least one selection ideally in the SUM & BY section

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...