I have a pdf format report not showing footer information. I am not able to figure out why am I not gettign footer information in my report.

-PDF
TABLE FILE WKRVAGG6
SUM AMTF/fmt AS ''
-* Arifs Heading Add
HEADING
"Weekly Revenue & Enrollment Report"
-*-*
-*-*FOOTING
-*"-*"<+0> Run Date: &DATEMDYY"
-* heading End
&SORT
BY UNIT1 NOPRINT
BY UNIT2 NOPRINT
ON UNIT2 SUBHEAD
"&UNIT1_TITLE "&UNIT2_TITLE ACROSS
HIGHEST CP_DESC AS ''
ACROSS COLENT NOPRINT
ACROSS COLTITLE AS ''
BY LITMORD NOPRINT
BY HIGHEST LITM1 NOPRINT
BY HIGHEST LITM1D AS ''
BY L2 NOPRINT
BY LITM2D AS ''
BY LITM3D NOPRINT
BY LITM3 AS ''
BY LITM2 NOPRINT
WHERE FLAG EQ 0;
WHERE COLCONCAT NE ' W';
WHERE SCHOOLID EQ '0001' OR '0002'
OR '0003' OR
'0004' OR
'0005' OR '0007'

ON UNIT2 PAGE-BREAK
ON TABLE SET LINES 999999
ON TABLE SET HTMLCSS ON
ON TABLE SET PAGE NOLEAD
ON TABLE SET BYPANEL ON
ON TABLE SET SQUEEZE ON
ON TABLE SET ACROSSLINE OFF
ON TABLE PCHOLD FORMAT &WFFMT
ON TABLE SET STYLE *
INCLUDE=BLUEGRAY,$
UNITS=IN,
PAGESIZE='Legal',
LEFTMARGIN=0.250000,
RIGHTMARGIN=0.000000,
TOPMARGIN=0.250000,
BOTTOMMARGIN=0.250000,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=6,
COLOR='BLACK',
STYLE=NORMAL,
RIGHTGAP=0.027778,
LEFTGAP=0.027778,
$
TYPE=DATA,
SIZE=6,
$
TYPE=REPORT,SIZE=6,ORIENTATION=LANDSCAPE,PAGESIZE='Legal',$
TYPE=TITLE, SIZE=8, COLOR=RGB(140 140 140),$
TYPE=ACROSSVALUE, JUSTIFY=CENTER, BACKCOLOR=RGB(230 230 240),$
TYPE=ACROSSVALUE, ACROSS=1,JUSTIFY=CENTER,$
TYPE=DATA, WHEN=LITM3 EQ ' ', STYLE=BOLD,$
TYPE=SUBTOTAL, STYLE=BOLD,$
TYPE=DATA, WHEN=LITM2 EQ ' ', BACKCOLOR=RGB(200 200 200),
BORDER-TOP=LIGHT, BORDER-TOP-COLOR=RGB(90 90 90),
BORDER-BOTTOM=LIGHT, BORDER-BOTTOM-COLOR=RGB(90 90 90),$
TYPE=SUBTOTAL,BACKCOLOR=RGB(200 200 200),
BORDER-TOP=LIGHT, BORDER-TOP-COLOR=RGB(90 90 90),
BORDER-BOTTOM=LIGHT, BORDER-BOTTOM-COLOR=RGB(90 90 90),$
-* TYPE=FOOTING,
-* LINE=1,
-* JUSTIFY=RIGHT,
-*$
-* ENDSTYLE
END
-RUN
-THEEND

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

sorry following is the correct code:

-PDF
TABLE FILE WKRVAGG6
SUM AMTF/fmt AS ''
-* Arifs Heading Add
HEADING
"Weekly Revenue & Enrollment Report"
-*-*
FOOTING
"-*"<+0> Run Date: &DATEMDYY"
-* heading End
&SORT
BY UNIT1 NOPRINT
BY UNIT2 NOPRINT
ON UNIT2 SUBHEAD
"&UNIT1_TITLE "&UNIT2_TITLE ACROSS
HIGHEST CP_DESC AS ''
ACROSS COLENT NOPRINT
ACROSS COLTITLE AS ''
BY LITMORD NOPRINT
BY HIGHEST LITM1 NOPRINT
BY HIGHEST LITM1D AS ''
BY L2 NOPRINT
BY LITM2D AS ''
BY LITM3D NOPRINT
BY LITM3 AS ''
BY LITM2 NOPRINT
WHERE FLAG EQ 0;
WHERE COLCONCAT NE ' W';
WHERE SCHOOLID EQ '0001' OR '0002'
OR '0003' OR
'0004' OR
'0005' OR '0007'

ON UNIT2 PAGE-BREAK
ON TABLE SET LINES 999999
ON TABLE SET HTMLCSS ON
ON TABLE SET PAGE NOLEAD
ON TABLE SET BYPANEL ON
ON TABLE SET SQUEEZE ON
ON TABLE SET ACROSSLINE OFF
ON TABLE PCHOLD FORMAT &WFFMT
ON TABLE SET STYLE *
INCLUDE=BLUEGRAY,$
UNITS=IN,
PAGESIZE='Legal',
LEFTMARGIN=0.250000,
RIGHTMARGIN=0.000000,
TOPMARGIN=0.250000,
BOTTOMMARGIN=0.250000,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=6,
COLOR='BLACK',
STYLE=NORMAL,
RIGHTGAP=0.027778,
LEFTGAP=0.027778,
$
TYPE=DATA,
SIZE=6,
$
TYPE=REPORT,SIZE=6,ORIENTATION=LANDSCAPE,PAGESIZE='Legal',$
TYPE=TITLE, SIZE=8, COLOR=RGB(140 140 140),$
TYPE=ACROSSVALUE, JUSTIFY=CENTER, BACKCOLOR=RGB(230 230 240),$
TYPE=ACROSSVALUE, ACROSS=1,JUSTIFY=CENTER,$
TYPE=DATA, WHEN=LITM3 EQ ' ', STYLE=BOLD,$
TYPE=SUBTOTAL, STYLE=BOLD,$
TYPE=DATA, WHEN=LITM2 EQ ' ', BACKCOLOR=RGB(200 200 200),
BORDER-TOP=LIGHT, BORDER-TOP-COLOR=RGB(90 90 90),
BORDER-BOTTOM=LIGHT, BORDER-BOTTOM-COLOR=RGB(90 90 90),$
TYPE=SUBTOTAL,BACKCOLOR=RGB(200 200 200),
BORDER-TOP=LIGHT, BORDER-TOP-COLOR=RGB(90 90 90),
BORDER-BOTTOM=LIGHT, BORDER-BOTTOM-COLOR=RGB(90 90 90),$
-* TYPE=FOOTING,
-* LINE=1,
-* JUSTIFY=RIGHT,
-*$
-* ENDSTYLE
END
-RUN
-THEEND

Its not pasting Code correctly its
FOOTING
"

Enclose you code within

[code]

tags.

quote:

FOOTING
"-*"<+0> Run Date: &DATEMDYY"

I'm not surprised!

But then the code you are trying to insert is -

FOOTING
"<TABPAGENO of <TABLASTPAGE"

So look at the styling and try and replicate against one of the sample files such as CAR.

T

try this way

 
FOOTING
"Run Date: &DATEMDYY" 

Also Check Report Style...

Unbalanced quotes? There's three of them in this line of code (which I copied from above).

"-*"<+0> Run Date: &DATEMDYY"