I'm pretty new to webfocus, I'm not sure what to make of this.

We're getting an error of
(FOC037) THE REQUEST IS INCOMPATIBLE WITH TABLEF

but there's nothing here or on IBI's site about this error. Is it something simple?

Here's my .fex if it helps...
JOIN
CUCASUM.CUCASUM.QDENUM IN CUCASUM TO MULTIPLE CUCAEMP.CUCAEMP.QEENUM IN CUCAEMP
AS J2
END
JOIN
CUCASUM.CUCASUM.QDCLOK IN CUCASUM TO MULTIPLE CUCACLK.CUCACLK.QCCLOK IN CUCACLK
AS J3
END
DEFINE FILE CUCASUM ADD
EMP/A60=QDENUM | FullName;
END
TABLEF FILE CUCASUM
PRINT
QDELAP
BY QDDEPT AS 'DEPT'
BY EMP AS 'EMPLOYEE'
ACROSS QDPAYD AS 'DAY'
ACROSS-TOTAL
ON QDDEPT SUBTOTAL AS '*TOTAL'
HEADING
"Overtime Report"
" "
FOOTING
"Report Run "
WHERE ( QDGETP EQ 'Y' );
ON TABLE SET PAGE-NUM OFF
ON TABLE SUMMARIZE CUCASUM.CUCASUM.QDELAP AS 'TOTAL'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=9,
$

quote:

DEFINE FILE CUCASUM ADD
EMP/A60=QDENUM | FullName;
END
TABLEF FILE CUCASUM
PRINT
QDELAP
BY QDDEPT AS 'DEPT'
BY EMP AS 'EMPLOYEE'
ACROSS QDPAYD AS 'DAY'

You can't sort on a defined field with TABLEF

Since you have only one selection, if a real field then do a TABLE instead.

You can't sort on any field when using TABLEF. TABLEF indicates to create the report WITHOUT the internal matrix. BY is only allowed to create breaks for printing.
If you look in help docs, the answer is pretty evident:

TABLEF is a variation of the TABLE command that provides a fast method of retrieving data that is already stored in the order required for printing and requires no additional sorting.

Using TABLEF, records are retrieved in the logical sequence from the data source. The standard report request syntax applies, subject to the following rules:

Any BY phrases must be compatible with the logical sequence of the data source. BY phrases are used only to establish control breaks, not to change the order of the records.

ACROSS phrases are not permitted.

Multiple display commands are not permitted. Only one display command may be used.

After the report is executed, RETYPE, HOLD, and SAVE are not available. However, you can produce an extract file if you include ON TABLE HOLD or ON TABLE SAVE as part of the request.

NOSPLIT is not compatible with the TABLEF command, and produces a FOC037 error message.

TABLEF can be used with HOLD files and other non-FOCUS data sources when the natural sort sequence of both the request and the data are the same.

TABLEF is not supported with SET EMPTYREPORT. When a TABLEF request retrieves zero records, EMPTYREPORT behaves as if it were set to ON.

The DST. prefix operator is not permitted.

So you've broken at least a couple rules for using TABLEF. Help documentation is probably the FIRST place to check for problems like this - even before the Focal Point forum.

Simple answer is to change to TABLE. No reason for TABLEF here.

This message has been edited. Last edited by: Darin Lee,

Thanks!