I'm using "ON field SUBFOOT", "ON TABLE SUBFOOT" AND "FOOTING" in a focexec. Somehow the "ON TABLE SUBFOOT" displayed at the end of the report after the "FOOTING".

What can affect this order? I use the same in another program and all is fine.

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

As it should... "ON TABLE SUBFOOT" means "ON TABLE" (After the TABLE FILE reuest has processed the results) and FOOTING is what will be done there (at the end of the report. "FOOTING" is a page footing...

What order do you want?

The order should be:

1. ON Field SUBFOOT
2. ON TABBLE SUBFOOT
3. PAGE FOOTING (prints on every page)

but the order is:

1. ON Field SUBFOOT
2. PAGE FOOTING (prints on every page)
2. ON TABBLE SUBFOOT

From within Dev Studio, press F1, select "Search" and enter "creating headings and footings", and press enter. See if that lines up with your expectations.

Try SET PRINTPLUS = ON

Good point. PRINTPLUS is good.

Go into the source code and type BOTTOM after FOOTING in the style. So you would end up with FOOTING BOTTOM This will shoot your page footing to the bottom of the page. I use this for page numbers.

Another good point. BOTTOM is good. I forgot that in this post.

I tried using "FOOTING BOTTOM".

The result was the "ON TABLE TOTAL" was on a separate page after the footing.

Waz was correct. "SET PRINTPLUS = ON" did it.

Thank you.

You also need to have PRINTPLUS = ON

Try this car file example;

 
SET PRINTPLUS = ON
TABLE FILE CAR
BY  LOWEST CAR.COMP.CAR
BY  LOWEST CAR.CARREC.MODEL
     
ON CAR.COMP.CAR SUBFOOT
"this is the on by field subfoot"
FOOTING BOTTOM
"<TABPAGENO of <TABLASTPAGE   this is the page footing"
ON TABLE SUBFOOT
"this is the report footing"
ON TABLE SET PAGE-NUM NOLEAD 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
ENDSTYLE
END

 

Thank you MAdams1 it works perfect now.