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.
This message has been edited. Last edited by: Jay Potter,
WebFocus 8.1.5 iSeries/Windows DB2/SQL/Access Dev Studio App Studio Maintain ReportCaster
December 16, 2013, 01:47 PM
njsden
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.
WebFocus 8.1.5 iSeries/Windows DB2/SQL/Access Dev Studio App Studio Maintain ReportCaster
December 16, 2013, 03:41 PM
Francis Mariani
Jay, edit your original post and add
[code]
your code here
[/code]
tags.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
December 16, 2013, 04:19 PM
njsden
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,
WebFocus 8.1.5 iSeries/Windows DB2/SQL/Access Dev Studio App Studio Maintain ReportCaster
December 17, 2013, 12:05 PM
Jay Potter
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.
WebFocus 8.1.5 iSeries/Windows DB2/SQL/Access Dev Studio App Studio Maintain ReportCaster