When using the RECAPs below for AHTML and EXCEL, the data displays correctly. When displaying in PDF format, the ON TABLE RECAP does not display. The other RECAPs do. Do I have to do TABLE RECAPS differently for a PDF?
I am using a : and a D to display an extended dollar sign. That is causing the smiley faces.

ON ACCT_RENUM RECAP
BLANK_RS/A1 = ' ' ;
ACCT_DESC_RS/A100 =  IF ACCT_RENUM EQ '60' THEN 'Payroll & Taxes' ELSE IF ACCT_RENUM EQ '65' THEN 'Operating Exp/Inc W/O Payroll & Taxes' ELSE IF DESCRIPTION EQ 'Allocations Out' THEN 'Total Allocations Out' ELSE IF DESCRIPTION EQ 'Allocations In' THEN 'Total Allocations In' ELSE DESCRIPTION;
P01_RS/P12BC = P01;
P02_RS/P12BC = P02;
P03_RS/P12BC = P03;
P04_RS/P12BC = P04;
P05_RS/P12BC = P05;
P06_RS/P12BC = P06;
P07_RS/P12BC = P07;
P08_RS/P12BC = P08;
P09_RS/P12BC = P09;
P10_RS/P12BC = P10;
P11_RS/P12BC = P11;
P12_RS/P12BC = P12;
COMPUTE PD_TOTAL_RS/P12BC = (P01_RS + P02_RS + P03_RS + P04_RS + P05_RS + P06_RS + P07_RS + P08_RS + P09_RS + P10_RS + P11_RS + P12_RS);
BUD_TOTAL_RS/P12BC = BUD_TOTAL;
-*COMPUTE TOTAL_PCT_RS/I3% = (PD_TOTAL/BUD_TOTAL)*100;
WHEN ACCT_RENUM EQ '60';
ON ACCT_RENUM SUBFOOT MULTILINES
"<BLANK_RS<BLANK_RS<ACCT_DESC_RS<P01_RS<P02_RS<P03_RS<P04_RS<P05_RS<P06_RS<P07_RS<P08_RS<P09_RS<P10_RS<P11_RS<P12_RS<PD_TOTAL_RS<BUD_TOTAL_RS"
WHEN ACCT_RENUM EQ '60';

ON RENUM_ACCT RECAP
ACCT_DESC_RSX/A100 =  IF ACCT_RENUM EQ '60' THEN 'Payroll & Taxes' ELSE IF ACCT_RENUM EQ '65' THEN 'Operating Exp/Inc' ELSE IF DESCRIPTION EQ 'Allocations Out' THEN 'Total Allocations Out' ELSE IF DESCRIPTION EQ 'Allocations In' THEN 'Total Allocations In' ELSE DESCRIPTION;
P01_RSX/P12BC = P01;
P02_RSX/P12BC = P02;
P03_RSX/P12BC = P03;
P04_RSX/P12BC = P04;
P05_RSX/P12BC = P05;
P06_RSX/P12BC = P06;
P07_RSX/P12BC = P07;
P08_RSX/P12BC = P08;
P09_RSX/P12BC = P09;
P10_RSX/P12BC = P10;
P11_RSX/P12BC = P11;
P12_RSX/P12BC = P12;
	COMPUTE PD_TOTAL_RSX/P12BC = (P01_RSX + P02_RSX + P03_RSX + P04_RSX + P05_RSX + P06_RSX + P07_RSX + P08_RSX + P09_RSX + P10_RSX + P11_RSX + P12_RSX);
BUD_TOTAL_RSX/P12BC = BUD_TOTAL;
COMPUTE TOTAL_PCT_RSX/I3% = (PD_TOTAL/BUD_TOTAL)*100;
ON RENUM_ACCT SUBFOOT MULTILINES
"<BLANK_RS<BLANK_RS<ACCT_DESC_RSX<P01_RSX<P02_RSX<P03_RSX<P04_RSX<P05_RSX<P06_RSX<P07_RSX<P08_RSX<P09_RSX<P10_RSX<P11_RSX<P12_RSX<PD_TOTAL_RSX<BUD_TOTAL_RSX<TOTAL_PCT_RSX"

ON TABLE RECAP
BLANK_RT/A1 = ' ' ;
ACCT_DESC_RT/A100 = 'Net Operating Exp/Inc';
P01_RT/P12B:D = P01;
P02_RT/P12B:D = P02;
P03_RT/P12B:D = P03;
P04_RT/P12B:D = P04;
P05_RT/P12B:D = P05;
P06_RT/P12B:D = P06;
P07_RT/P12B:D = P07;
P08_RT/P12B:D = P08;
P09_RT/P12B:D = P09;
P10_RT/P12B:D = P10;
P11_RT/P12B:D = P11;
P12_RT/P12B:D = P12;
PD_TOTAL_RT/P12B:D = PD_TOTAL;
BUD_TOTAL_RT/P12B:D = BUD_TOTAL;
TOTAL_PCT_RT/I3% = (PD_TOTAL/BUD_TOTAL)*100;
ON TABLE SUBFOOT
"<BLANK_RT<BLANK_RT<ACCT_DESC_RT<P01_RT<P02_RT<P03_RT<P04_RT<P05_RT<P06_RT<P07_RT<P08_RT<P09_RT<P10_RT<P11_RT<P12_RT<PD_TOTAL_RT<BUD_TOTAL_RT<TOTAL_PCT_RT"

This message has been edited. Last edited by: Jay Potter,

Your code is not enclosed in CODE tags and that makes it difficult to read and try to spot what may be wrong. You have a few RECAP calculations followed by a TABLE SUBFOOT which appears empty in the code.

Are you actually referencing your RECAP values there?

I disabled the html, so that you can see my subfoot code.

Jay, edit your original post and add

[code]

your code here

[/code]

tags.

quote:

I am using a : and a D to display an extended dollar sign. That is causing the smiley faces.

Why not use [ CODE ] tags instead as I suggested previously? It's outlined in the best-practices tips for the forum and believe me, it makes our "job" easier.

In any case, you seem to have quite a significant number of columns there. Do they all fit in your page? Headings/Footings sometimes get messy when paneling is involved.

This works for me in 7.7.05:

DEFINE FILE CAR
P01/P12BC = DEALER_COST;
P02/P12BC = RETAIL_COST;
P03/P12BC = DEALER_COST;
P04/P12BC = RETAIL_COST;
P05/P12BC = DEALER_COST;
P06/P12BC = RETAIL_COST;
P07/P12BC = DEALER_COST;
P08/P12BC = RETAIL_COST;
P09/P12BC = DEALER_COST;
P10/P12BC = RETAIL_COST;
P11/P12BC = DEALER_COST;
P12/P12BC = RETAIL_COST;
PD_TOTAL/P12BC  = (P01 + P03 + P05 + P07 + P09 + P11);
BUD_TOTAL/P12BC = (P02 + P04 + P06 + P08 + P10 + P12);
BLANK/A1 = ' ';
END
TABLE FILE CAR
SUM
        P01 AND P02 AND P03 AND P04 AND P05 AND P06
	P07 AND P08 AND P09 AND P10 AND P11 AND P12
	PD_TOTAL AND BUD_TOTAL
BY BLANK
BY COUNTRY NOPRINT
BY CAR

ON COUNTRY RECAP
BLANK_RTX/A1 = ' ';
ACCT_DESC_RTX/A100 = COUNTRY;
P01_RTX/P12BC = P01;
P02_RTX/P12BC = P02;
P03_RTX/P12BC = P03;
P04_RTX/P12BC = P04;
P05_RTX/P12BC = P05;
P06_RTX/P12BC = P06;
P07_RTX/P12BC = P07;
P08_RTX/P12BC = P08;
P09_RTX/P12BC = P09;
P10_RTX/P12BC = P10;
P11_RTX/P12BC = P11;
P12_RTX/P12BC = P12;
PD_TOTAL_RTX/P12BC = PD_TOTAL;
BUD_TOTAL_RTX/P12C = BUD_TOTAL;
TOTAL_PCT_RTX/I3% = (PD_TOTAL/BUD_TOTAL)*100;

ON COUNTRY SUBFOOT
"<BLANK_RTX<ACCT_DESC_RTX<P01_RTX<P02_RTX<P03_RTX<P04_RTX<P05_RTX<P06_RTX<P07_RTX<P08_RTX<P09_RTX<P10_RTX<P11_RTX<P12_RTX<PD_TOTAL_RTX<BUD_TOTAL_RTX"

-*-----
ON TABLE RECAP
BLANK_RT/A1 = ' ' ;
ACCT_DESC_RT/A100 = 'Net Operating Exp/Inc';
P01_RT/P12BC = P01;
P02_RT/P12BC = P02;
P03_RT/P12BC = P03;
P04_RT/P12BC = P04;
P05_RT/P12BC = P05;
P06_RT/P12BC = P06;
P07_RT/P12BC = P07;
P08_RT/P12BC = P08;
P09_RT/P12BC = P09;
P10_RT/P12BC = P10;
P11_RT/P12BC = P11;
P12_RT/P12BC = P12;
PD_TOTAL_RT/P12BC = PD_TOTAL;
BUD_TOTAL_RT/P12C = BUD_TOTAL;
TOTAL_PCT_RT/I3% = (PD_TOTAL/BUD_TOTAL)*100;

ON TABLE SUBFOOT
"<BLANK_RT<ACCT_DESC_RT<P01_RT<P02_RT<P03_RT<P04_RT<P05_RT<P06_RT<P07_RT<P08_RT<P09_RT<P10_RT<P11_RT<P12_RT<PD_TOTAL_RT<BUD_TOTAL_RT"

ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
UNITS=PTS, PAGESIZE=LETTER, ORIENTATION=LANDSCAPE, LEFTMARGIN=30, SQUEEZE=ON, $
TYPE=REPORT, SIZE=8, LEFTGAP=2, RIGHTGAP=2, $
TYPE=SUBFOOT, BY=COUNTRY, HEADALIGN=BODY, BACKCOLOR=SILVER, $
TYPE=TABFOOTING, HEADALIGN=BODY, STYLE=BOLD, BACKCOLOR='GRAY', $
END

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

I just added code tags to my original post

I will start using the code tags for now on. I was able to attached my code on top of yours and it worked. Now I need to compare my bottom half to your code and see what is different.


Thank You for your assistance.