[SOLVED] subfoot split into pages

Hi

I am working on a report with subfoot. I display fields in subfoot bases on a sort field. Everything works as expected but I am trying to avoid one thing and I am not sure of the mistake Im doing. Can someone please help me?

 

TABLE FILE HT
PRINT
	F1 AS 'FIELD1'
	F2 AS 'FIELD2'
BY	C_NUMBER NOPRINT
BY	P_NUMBER AS 'P NUM'
HEADING
"LINE1"
"LINE2"
"DATE: <+0>&DATEMDYY <+0> "
" "
"<C_NUMBER"
FOOTING
"Page <TABPAGENO  of<TABLASTPAGE"

ON P_NUMBER SUBFOOT
""
"Comments1"
"<COMMENTS1"
""
"Comments2"
"<COMMENTS2"
"______________________________________________"
ON C_NUMBER PAGE-BREAK
ON P_NUMBER SKIP-LINE
ON TABLE PCHOLD FORMAT PDF
END

SAMPLE OUTPUT:

P NUM    FIELD1   FIELD2
DATA     DATA     DATA

COMMENTS1
DATA

COMMENTS2
DATA
______________________________________________
DATA     DATA     DATA

COMMENTS1
DATA

COMMENTS2
DATA
_______________________________________________

[B]DATA     DATA     DATA[/B]


PAGE 1 OF 2

P NUM    FIELD1   FIELD2

COMMENTS1
DATA

COMMENTS2
DATA
_______________________________________________
DATA     DATA     DATA

COMMENTS1
DATA

COMMENTS2
DATA
_______________________________________________

[B]DATA     DATA     DATA[/B]

PAGE 2 of 2

In the above sample output, in the third set of data, fields from table request (in bold) are printed at end of page and rest is printed on next page. How can I make sure they come on same page?

let me know of any questions.

thank you

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

8.1.05
HTML,PDF,EXL2K, Active, All

Posts: 484 | Registered: February 03, 2009