Focal Point
PDF Alinement issue

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5291020852

November 19, 2007, 04:25 PM
tlbrydie2
PDF Alinement issue


*

Could someone please help me out with my allignment issue. I need the this information...My code is attached below.


(
PPLANAMT under the amount column
EXPENSES under the expense column
PINCOME undwer the income column
PYTDAMT under the amount column




Change/Update/Add
-* Date By EMR enhancement/Description
-* ---------- ------------------- -------------------------------------------
-* 11/12/2007 Timothy Brydie Initial creation of the report
-******************************************************************************
-*
FILEDEF E711ACCT2 DISK emr_work/e711acct2.ftm
-*-DEFAULTS &BYCLAUSE = ' ';
DEFINE FILE E711ACCT2
CATEGORY/A50 = category;
splancnt/D12BC = plancnt;
APLANCNT/A15 = IF EDIT(yorn,'9') EQ 'N' THEN ' ' ELSE FTOA(plancnt,'(D12BC)',APLANCNT);
splanamt/D15.2BM = planamt;
APLANAMT/A30 = IF EDIT(yorn,'$9') EQ 'N' THEN ' ' ELSE FTOA(planamt,'(D15.2B)',APLANAMT);
sexpense/D15.2BM = expense;
AEXPENSE/A30 = IF EDIT(yorn,'$$9') EQ 'N' THEN ' ' ELSE FTOA(expense,'(D15.2B)',AEXPENSE);
sincome/D15.2BM = income;
AINCOME/A30 = IF EDIT(yorn,'$$$9') EQ 'N' THEN ' ' ELSE FTOA(income,'(D15.2B)',AINCOME);
sytdamt/D15.2BM = ytdamt;
AYTDAMT/A30 = IF EDIT(yorn,'$$$$9') EQ 'N' THEN ' ' ELSE FTOA(ytdamt,'(D15.2B)',AYTDAMT);
TITL/A6 ='Total:';
DUM/A1 WITH category = ' ';
D_endofrpt/A170 = '-- End of Report --';
END
-IF &FOCERRNUM NE 0 GOTO GETOUTNOW;
-RUN
TABLE FILE E711ACCT2
SUM planamt NOPRINT
expense NOPRINT
income NOPRINT
ytdamt NOPRINT

PRINT
CATEGORY AS ''
APLANCNT AS 'Count'
APLANAMT AS 'Amount'
AEXPENSE AS 'Expense'
AINCOME AS 'Income'
AYTDAMT AS 'YTD Amount'


splancnt NOPRINT
splanamt NOPRINT
sexpense NOPRINT
sincome NOPRINT
sytdamt NOPRINT
-*
COMPUTE ZPLANAMT/D15.2 = planamt; NOPRINT
COMPUTE XPLANAMT/A20 = FTOA(ZPLANAMT,'(D15.2B)',XPLANAMT); NOPRINT
COMPUTE PPLANAMT/A30 = '$'||LJUST(20,XPLANAMT,'A20'); NOPRINT
-*
COMPUTE ZEXPENSE/D15.2 = expense; NOPRINT
COMPUTE XEXPENSE/A20 = FTOA(ZEXPENSE,'(D15.2B)',XEXPENSE); NOPRINT
COMPUTE PEXPENSE/A30 = '$'||LJUST(20,XEXPENSE,'A20'); NOPRINT
-*
COMPUTE ZINCOME/D15.2 = income; NOPRINT
COMPUTE XINCOME/A20 = FTOA(ZINCOME,'(D15.2B)',XINCOME); NOPRINT
COMPUTE PINCOME/A30 = '$'||LJUST(20,XINCOME,'A20'); NOPRINT
-*
COMPUTE ZYTDAMT/D15.2 = ytdamt; NOPRINT
COMPUTE XYTDAMT/A20 = FTOA(ZYTDAMT,'(D15.2B)',XYTDAMT); NOPRINT
COMPUTE PYTDAMT/A30 = '$'||LJUST(20,XYTDAMT,'A20'); NOPRINT
-*
BY DUM NOPRINT
-*&BYCLAUSE.EVAL
-*-IF &RECS EQ 0 GOTO SKIPSUB;
ON DUM SUBFOOT
" "
"-*"-GOTO HAVERECS
-SKIPSUB
ON DUM SUBFOOT
"" "
"-HAVERECS
-*
FOOTING BOTTOM
"Page -*
-**** NOLEAD eliminates three lines of blank at the top of the output.
-**** Requires LINES to be < 1000.
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=REPORT,SIZE=8,FONT=HELVETICA,ORIENTATION=LANDSCAPE,SQUEEZE=ON,$
TYPE=FOOTING, JUSTIFY=CENTER,$
TYPE=TITLE,JUSTIFY=RIGHT,$
TYPE=TABHEADING,LINE=1,JUSTIFY=RIGHT,$
TYPE=TABHEADING,LINE=2,JUSTIFY=RIGHT,$
-*TYPE=DATA,COLUMN=APLANCNT,JUSTIFY=RIGHT,$
-*TYPE=DATA,COLUMN=APLANAMT,JUSTIFY=RIGHT,$
-*TYPE=DATA,COLUMN=AEXPENSE,JUSTIFY=RIGHT,$
-*TYPE=DATA,COLUMN=AINCOME,JUSTIFY=RIGHT,$
TYPE=DATA,COLUMN=ytdamt,JUSTIFY=RIGHT,$

-*TYPE=SUBFOOT,BY=DUM,LINE=1,ITEM=1,OBJECT=FIELD,JUSTIFY=RIGHT,POSITION=C6,$
TYPE=SUBFOOT,BY=DUM,LINE=1,ITEM=1,POSITION=Amount,$
TYPE=SUBFOOT,BY=DUM,LINE=1,ITEM=2,OBJECT=FIELD,JUSTIFY=RIGHT,POSITION=Amount,$
TYPE=SUBFOOT,BY=DUM,LINE=1,ITEM=3,OBJECT=FIELD,JUSTIFY=RIGHT,POSITION=Expense,$
TYPE=SUBFOOT,BY=DUM,LINE=1,ITEM=4,JUSTIFY=RIGHT,POSITION=ytdamt,$
-*TYPE=SUBFOOT,BY=DUM,LINE=1,ITEM=6,OBJECT=FIELD,JUSTIFY=RIGHT,POSITION=C11,$
-*TYPE=SUBFOOT,BY=DUM,LINE=1,ITEM=7,OBJECT=FIELD,JUSTIFY=RIGHT,POSITION=C12,$
-*TYPE=SUBFOOT,BY=DUM,LINE=1,ITEM=8,OBJECT=FIELD,JUSTIFY=RIGHT,POSITION=C13,$
-*TYPE=SUBFOOT,BY=DUM,LINE=3,JUSTIFY=CENTER,$
ENDSTYLE
-*
END
-RUN
-IF &FOCERRNUM NE 0 GOTO GETOUTNOW;
-RUN
-*
-GOTO NOMORE
-GETOUTNOW
-*-INCLUDE emr_error
-EXIT
-NOMORE





Prod: WebFOCUS 7.6.10 MRE
Oracle/Sybase
Test: DevStudio 7.6.6
WF Server 7.6.6
Report Caster 7.6.6
Web Server - Tomcat
MS Windows XP SP2
Output: HTML, Excel 2000 , PDF, CSV, DOC

November 19, 2007, 05:38 PM
Leah
You might try

SET PRINTPLUS = ON

You don't really say what the alignment issue is though?


Leah
November 19, 2007, 05:51 PM
Francis Mariani
Your POSITION tags should be on real report column names, not on their AS names:

POSITION=Amount should be POSITION=APLANAMT, etc.

As well, you have two POSITION=Amount clauses - this will not work for one of the SUBFOOT fields.


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
November 19, 2007, 05:55 PM
tlbrydie2
MY totals are not aligned under the correct columns.
I need to have the alignment as follows:


PPLANAMT under the amount column
EXPENSES under the expense column
PINCOME undwer the income column
PYTDAMT under the amount column





Prod: WebFOCUS 7.6.10 MRE
Oracle/Sybase
Test: DevStudio 7.6.6
WF Server 7.6.6
Report Caster 7.6.6
Web Server - Tomcat
MS Windows XP SP2
Output: HTML, Excel 2000 , PDF, CSV, DOC

November 20, 2007, 12:16 AM
Leah
I don't see the column-total in your posted code. Are you calculating totals to print in a subfoot? Hard to align those you have to play with spot markers (posistioning with the greater than and less than symbols in the code).


Leah
November 20, 2007, 07:41 AM
tlbrydie2
The section of my code where I am totaling did not print. that section is included here

COMPUTE ZPLANAMT/D15.2 = planamt; NOPRINT
COMPUTE XPLANAMT/A20 = FTOA(ZPLANAMT,'(D15.2B)',XPLANAMT); NOPRINT
COMPUTE PPLANAMT/A30 = '$'||LJUST(20,XPLANAMT,'A20'); NOPRINT
-*
COMPUTE ZEXPENSE/D15.2 = expense; NOPRINT
COMPUTE XEXPENSE/A20 = FTOA(ZEXPENSE,'(D15.2B)',XEXPENSE); NOPRINT
COMPUTE PEXPENSE/A30 = '$'||LJUST(20,XEXPENSE,'A20'); NOPRINT
-*
COMPUTE ZINCOME/D15.2 = income; NOPRINT
COMPUTE XINCOME/A20 = FTOA(ZINCOME,'(D15.2B)',XINCOME); NOPRINT
COMPUTE PINCOME/A30 = '$'||LJUST(20,XINCOME,'A20'); NOPRINT
-*
COMPUTE ZYTDAMT/D15.2 = ytdamt; NOPRINT
COMPUTE XYTDAMT/A20 = FTOA(ZYTDAMT,'(D15.2B)',XYTDAMT); NOPRINT
COMPUTE PYTDAMT/A30 = '$'||LJUST(20,XYTDAMT,'A20'); NOPRINT
-*
BY DUM NOPRINT
-*&BYCLAUSE.EVAL
-*-IF &RECS EQ 0 GOTO SKIPSUB;
ON DUM SUBFOOT
" "
"-*"-GOTO HAVERECS
-SKIPSUB
ON DUM SUBFOOT
"" "
"-HAVERECS
-*
FOOTING BOTTOM
"Page -*
-**** NOLEAD eliminates three lines of blank at the top of the output.
-**** Requires LINES to be < 1000.
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=REPORT,SIZE=8,FONT=HELVETICA,ORIENTATION=LANDSCAPE,SQUEEZE=ON,$
TYPE=FOOTING, JUSTIFY=CENTER,$
TYPE=TITLE,JUSTIFY=RIGHT,$
TYPE=TABHEADING,LINE=1,JUSTIFY=RIGHT,$
TYPE=TABHEADING,LINE=2,JUSTIFY=RIGHT,$
-*TYPE=DATA,COLUMN=APLANCNT,JUSTIFY=RIGHT,$
-*TYPE=DATA,COLUMN=APLANAMT,JUSTIFY=RIGHT,$
-*TYPE=DATA,COLUMN=AEXPENSE,JUSTIFY=RIGHT,$
-*TYPE=DATA,COLUMN=AINCOME,JUSTIFY=RIGHT,$
TYPE=DATA,COLUMN=ytdamt,JUSTIFY=RIGHT,$

-*TYPE=SUBFOOT,BY=DUM,LINE=1,ITEM=1,OBJECT=FIELD,JUSTIFY=RIGHT,POSITION=C6,$
TYPE=SUBFOOT,BY=DUM,LINE=1,ITEM=1,POSITION=ytdamt,$
TYPE=SUBFOOT,BY=DUM,LINE=1,ITEM=2,OBJECT=FIELD,JUSTIFY=RIGHT,POSITION=Amount,$
TYPE=SUBFOOT,BY=DUM,LINE=1,ITEM=3,OBJECT=FIELD,JUSTIFY=RIGHT,POSITION=Expense,$
TYPE=SUBFOOT,BY=DUM,LINE=1,ITEM=4,JUSTIFY=RIGHT,POSITION=ytdamt,$
-*TYPE=SUBFOOT,BY=DUM,LINE=1,ITEM=6,OBJECT=FIELD,JUSTIFY=RIGHT,POSITION=C11,$
-*TYPE=SUBFOOT,BY=DUM,LINE=1,ITEM=7,OBJECT=FIELD,JUSTIFY=RIGHT,POSITION=C12,$
-*TYPE=SUBFOOT,BY=DUM,LINE=1,ITEM=8,OBJECT=FIELD,JUSTIFY=RIGHT,POSITION=C13,$
-*TYPE=SUBFOOT,BY=DUM,LINE=3,JUSTIFY=CENTER,$
ENDSTYLE
-*
END
-RUN
-IF &FOCERRNUM NE 0 GOTO GETOUTNOW;
-RUN





Prod: WebFOCUS 7.6.10 MRE
Oracle/Sybase
Test: DevStudio 7.6.6
WF Server 7.6.6
Report Caster 7.6.6
Web Server - Tomcat
MS Windows XP SP2
Output: HTML, Excel 2000 , PDF, CSV, DOC

November 20, 2007, 07:44 AM
tlbrydie2
Thanks Francis, although I believe I've tried using the real names and recieved the same results...I'll try this again.

BTW. My totaling section of the code did not post...it is included here:

COMPUTE ZPLANAMT/D15.2 = planamt; NOPRINT
COMPUTE XPLANAMT/A20 = FTOA(ZPLANAMT,'(D15.2B)',XPLANAMT); NOPRINT
COMPUTE PPLANAMT/A30 = '$'||LJUST(20,XPLANAMT,'A20'); NOPRINT
-*
COMPUTE ZEXPENSE/D15.2 = expense; NOPRINT
COMPUTE XEXPENSE/A20 = FTOA(ZEXPENSE,'(D15.2B)',XEXPENSE); NOPRINT
COMPUTE PEXPENSE/A30 = '$'||LJUST(20,XEXPENSE,'A20'); NOPRINT
-*
COMPUTE ZINCOME/D15.2 = income; NOPRINT
COMPUTE XINCOME/A20 = FTOA(ZINCOME,'(D15.2B)',XINCOME); NOPRINT
COMPUTE PINCOME/A30 = '$'||LJUST(20,XINCOME,'A20'); NOPRINT
-*
COMPUTE ZYTDAMT/D15.2 = ytdamt; NOPRINT
COMPUTE XYTDAMT/A20 = FTOA(ZYTDAMT,'(D15.2B)',XYTDAMT); NOPRINT
COMPUTE PYTDAMT/A30 = '$'||LJUST(20,XYTDAMT,'A20'); NOPRINT
-*
BY DUM NOPRINT
-*&BYCLAUSE.EVAL
-*-IF &RECS EQ 0 GOTO SKIPSUB;
ON DUM SUBFOOT
" "
"-*"-GOTO HAVERECS
-SKIPSUB
ON DUM SUBFOOT
"" "
"-HAVERECS
-*
FOOTING BOTTOM
"Page -*
-**** NOLEAD eliminates three lines of blank at the top of the output.
-**** Requires LINES to be < 1000.
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=REPORT,SIZE=8,FONT=HELVETICA,ORIENTATION=LANDSCAPE,SQUEEZE=ON,$
TYPE=FOOTING, JUSTIFY=CENTER,$
TYPE=TITLE,JUSTIFY=RIGHT,$
TYPE=TABHEADING,LINE=1,JUSTIFY=RIGHT,$
TYPE=TABHEADING,LINE=2,JUSTIFY=RIGHT,$
-*TYPE=DATA,COLUMN=APLANCNT,JUSTIFY=RIGHT,$
-*TYPE=DATA,COLUMN=APLANAMT,JUSTIFY=RIGHT,$
-*TYPE=DATA,COLUMN=AEXPENSE,JUSTIFY=RIGHT,$
-*TYPE=DATA,COLUMN=AINCOME,JUSTIFY=RIGHT,$
TYPE=DATA,COLUMN=ytdamt,JUSTIFY=RIGHT,$

-*TYPE=SUBFOOT,BY=DUM,LINE=1,ITEM=1,OBJECT=FIELD,JUSTIFY=RIGHT,POSITION=C6,$
TYPE=SUBFOOT,BY=DUM,LINE=1,ITEM=1,POSITION=ytdamt,$
TYPE=SUBFOOT,BY=DUM,LINE=1,ITEM=2,OBJECT=FIELD,JUSTIFY=RIGHT,POSITION=Amount,$
TYPE=SUBFOOT,BY=DUM,LINE=1,ITEM=3,OBJECT=FIELD,JUSTIFY=RIGHT,POSITION=Expense,$
TYPE=SUBFOOT,BY=DUM,LINE=1,ITEM=4,JUSTIFY=RIGHT,POSITION=ytdamt,$
-*TYPE=SUBFOOT,BY=DUM,LINE=1,ITEM=6,OBJECT=FIELD,JUSTIFY=RIGHT,POSITION=C11,$
-*TYPE=SUBFOOT,BY=DUM,LINE=1,ITEM=7,OBJECT=FIELD,JUSTIFY=RIGHT,POSITION=C12,$
-*TYPE=SUBFOOT,BY=DUM,LINE=1,ITEM=8,OBJECT=FIELD,JUSTIFY=RIGHT,POSITION=C13,$
-*TYPE=SUBFOOT,BY=DUM,LINE=3,JUSTIFY=CENTER,$
ENDSTYLE
-*
END
-RUN
-IF &FOCERRNUM NE 0 GOTO GETOUTNOW;
-RUN





Prod: WebFOCUS 7.6.10 MRE
Oracle/Sybase
Test: DevStudio 7.6.6
WF Server 7.6.6
Report Caster 7.6.6
Web Server - Tomcat
MS Windows XP SP2
Output: HTML, Excel 2000 , PDF, CSV, DOC

November 20, 2007, 08:40 AM
GamP
Timothy,

If you put your code between the code brackets (the red
</>
icon) you will see that all code will be posted correctly.
Your complete code would then look like:

FILEDEF E711ACCT2 DISK emr_work/e711acct2.ftm
DEFINE FILE E711ACCT2
 CATEGORY/A50          = category;
 splancnt/D12BC         = plancnt;
 APLANCNT/A15          = IF EDIT(yorn,'9') EQ 'N' THEN ' ' ELSE FTOA(plancnt,'(D12BC)',APLANCNT);
 splanamt/D15.2BM      = planamt;
 APLANAMT/A30          = IF EDIT(yorn,'$9') EQ 'N' THEN ' ' ELSE FTOA(planamt,'(D15.2B)',APLANAMT);
 sexpense/D15.2BM      = expense;
 AEXPENSE/A30          = IF EDIT(yorn,'$$9') EQ 'N' THEN ' '  ELSE FTOA(expense,'(D15.2B)',AEXPENSE);
 sincome/D15.2BM       = income;
 AINCOME/A30           = IF EDIT(yorn,'$$$9') EQ 'N' THEN ' '  ELSE FTOA(income,'(D15.2B)',AINCOME);
 sytdamt/D15.2BM        = ytdamt;
 AYTDAMT/A30            = IF EDIT(yorn,'$$$$9') EQ 'N' THEN ' ' ELSE FTOA(ytdamt,'(D15.2B)',AYTDAMT);
 TITL/A6               ='Total:';
 DUM/A1 WITH category  = ' ';
 D_endofrpt/A170       = '-- End of Report --';
END
-IF &FOCERRNUM NE 0 GOTO GETOUTNOW;
-RUN
TABLE FILE E711ACCT2
SUM planamt  NOPRINT
    expense  NOPRINT
    income   NOPRINT
    ytdamt   NOPRINT

PRINT
   CATEGORY   AS ''
   APLANCNT   AS 'Count'
   APLANAMT   AS 'Amount'
   AEXPENSE   AS 'Expense'
   AINCOME    AS 'Income'
   AYTDAMT    AS 'YTD Amount'

   splancnt    NOPRINT
   splanamt    NOPRINT
   sexpense    NOPRINT
   sincome     NOPRINT
   sytdamt     NOPRINT
-*
COMPUTE ZPLANAMT/D15.2 = planamt; NOPRINT
COMPUTE XPLANAMT/A20  = FTOA(ZPLANAMT,'(D15.2B)',XPLANAMT); NOPRINT
COMPUTE PPLANAMT/A30 = '$'||LJUST(20,XPLANAMT,'A20'); NOPRINT
-*
COMPUTE ZEXPENSE/D15.2 = expense; NOPRINT
COMPUTE XEXPENSE/A20  = FTOA(ZEXPENSE,'(D15.2B)',XEXPENSE); NOPRINT
COMPUTE PEXPENSE/A30 = '$'||LJUST(20,XEXPENSE,'A20'); NOPRINT
-*
COMPUTE ZINCOME/D15.2 = income; NOPRINT
COMPUTE XINCOME/A20  = FTOA(ZINCOME,'(D15.2B)',XINCOME); NOPRINT
COMPUTE PINCOME/A30 = '$'||LJUST(20,XINCOME,'A20'); NOPRINT
-*
COMPUTE ZYTDAMT/D15.2 = ytdamt; NOPRINT
COMPUTE XYTDAMT/A20  = FTOA(ZYTDAMT,'(D15.2B)',XYTDAMT); NOPRINT
COMPUTE PYTDAMT/A30 = '$'||LJUST(20,XYTDAMT,'A20'); NOPRINT
-*
BY DUM  NOPRINT
ON DUM SUBFOOT
" "
"<TITL<TOT.PPLANAMT<TOT.PEXPENSE<TOT.PINCOME<TOT.PYTDAMT"
-GOTO HAVERECS
-SKIPSUB
ON DUM SUBFOOT
"<TITL"
" "
"<D_endofrpt"
-HAVERECS
-*
FOOTING BOTTOM
"Page <TABPAGENO "
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=REPORT,SIZE=8,FONT=HELVETICA,ORIENTATION=LANDSCAPE,SQUEEZE=ON,$
TYPE=FOOTING, JUSTIFY=CENTER,$
TYPE=TITLE,JUSTIFY=RIGHT,$
TYPE=TABHEADING,LINE=1,JUSTIFY=RIGHT,$
TYPE=TABHEADING,LINE=2,JUSTIFY=RIGHT,$
TYPE=DATA,COLUMN=ytdamt,JUSTIFY=RIGHT,$

TYPE=SUBFOOT,BY=DUM,LINE=1,ITEM=1,POSITION=Amount,$
TYPE=SUBFOOT,BY=DUM,LINE=1,ITEM=2,OBJECT=FIELD,JUSTIFY=RIGHT,POSITION=Amount,$
TYPE=SUBFOOT,BY=DUM,LINE=1,ITEM=3,OBJECT=FIELD,JUSTIFY=RIGHT,POSITION=Expense,$
TYPE=SUBFOOT,BY=DUM,LINE=1,ITEM=4,JUSTIFY=RIGHT,POSITION=ytdamt,$
ENDSTYLE
-*
END
-RUN
-IF &FOCERRNUM NE 0 GOTO GETOUTNOW;
-RUN
-*
-GOTO NOMORE
-GETOUTNOW
-*-INCLUDE emr_error
-EXIT
-NOMORE

I took the liberty of removing comment lines.
Why don't you just use the column-total for your numeric columns? These will always be alined...


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
November 20, 2007, 08:50 AM
tlbrydie2
this was not written using the GUI..could youexplain how I would that kfor this fex




Prod: WebFOCUS 7.6.10 MRE
Oracle/Sybase
Test: DevStudio 7.6.6
WF Server 7.6.6
Report Caster 7.6.6
Web Server - Tomcat
MS Windows XP SP2
Output: HTML, Excel 2000 , PDF, CSV, DOC

November 20, 2007, 09:09 AM
Leah
The syntax is

ON TABLE COLUMN-TOTAL AS 'Totals'

This puts totals on line at the bottom of your data columns, then you could add your

ON TABLE SUBFOOT

To print the 'end of report' line.


Leah
November 20, 2007, 09:30 AM
mgrackin
The easiest thing to do would be to use the appropriate SUBTOTAL or SUB-TOTAL command instead of doing this in a SUBFOOT. Using SUBTOTAL or SUB-TOTAL or even COLUMN-TOTAL as Leah indicated would automatically calculate the total values and position the total values in the appropriate column.

If you insist on using SUBFOOT, read the following two articles which explain a lot about positioning.

http://www.informationbuilders.com/support/developers/htmlpdf.html

http://www.informationbuilders.com/support/developers/htmlpdf_part2.html


Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011
November 20, 2007, 10:48 AM
tlbrydie2
I am still getting the same results. I am obviously doing someting wrong. My new code is as follows
TABLE FILE E711ACCT2
SUM planamt  NOPRINT
    expense  NOPRINT
    income   NOPRINT
    ytdamt   NOPRINT

PRINT
   CATEGORY   AS ''
   APLANCNT   AS 'Count'
   APLANAMT   AS 'Amount'
   AEXPENSE   AS 'Expense'
   AINCOME    AS 'Income'
   AYTDAMT    AS 'YTD Amount'


   splancnt    NOPRINT
   splanamt    NOPRINT
   sexpense    NOPRINT
   sincome     NOPRINT
   sytdamt     NOPRINT
-*
COMPUTE ZPLANAMT/D15.2 = planamt; NOPRINT
COMPUTE XPLANAMT/A20  = FTOA(ZPLANAMT,'(D15.2B)',XPLANAMT); NOPRINT
COMPUTE PPLANAMT/A30 = '$'||LJUST(20,XPLANAMT,'A20'); NOPRINT
-*
COMPUTE ZEXPENSE/D15.2 = expense; NOPRINT
COMPUTE XEXPENSE/A20  = FTOA(ZEXPENSE,'(D15.2B)',XEXPENSE); NOPRINT
COMPUTE PEXPENSE/A30 = '$'||LJUST(20,XEXPENSE,'A20'); NOPRINT
-*
COMPUTE ZINCOME/D15.2 = income; NOPRINT
COMPUTE XINCOME/A20  = FTOA(ZINCOME,'(D15.2B)',XINCOME); NOPRINT
COMPUTE PINCOME/A30 = '$'||LJUST(20,XINCOME,'A20'); NOPRINT
-*
COMPUTE ZYTDAMT/D15.2 = ytdamt; NOPRINT
COMPUTE XYTDAMT/A20  = FTOA(ZYTDAMT,'(D15.2B)',XYTDAMT); NOPRINT
COMPUTE PYTDAMT/A30 = '$'||LJUST(20,XYTDAMT,'A20'); NOPRINT
-*
BY DUM  NOPRINT
-*&BYCLAUSE.EVAL
-*-IF &RECS EQ 0 GOTO SKIPSUB;
-*ON TABLE COLUMN-TOTAL AS 'Totals'
-*ON DUM SUBFOOT
ON TABLE SUBFOOT
" "
"<TITL<TOT.PPLANAMT<TOT.PEXPENSE<TOT.PINCOME<TOT.PYTDAMT"
-*
-**** NOLEAD eliminates three lines of blank at the top of the output.
-**** Requires LINES to be < 1000.
-*-*-*ON TABLE COLUMN-TOTAL AS 'Totals'
-*ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=REPORT,SIZE=8,FONT=HELVETICA,ORIENTATION=LANDSCAPE,SQUEEZE=ON,$
TYPE=FOOTING, JUSTIFY=CENTER,$
TYPE=TITLE,JUSTIFY=RIGHT,$
TYPE=TABHEADING,LINE=1,JUSTIFY=RIGHT,$
TYPE=TABHEADING,LINE=2,JUSTIFY=RIGHT,$
TYPE=SUBFOOT,LINE=1, OBJECT=FIELD, ITEM=1, POSITION=CATEGORY,$
TYPE=SUBFOOT,LINE=1, OBJECT=FIELD, ITEM=2, POSITION=APLANAMT,$
TYPE=SUBFOOT,LINE=1, OBJECT=FIELD, ITEM=3, POSITION=AEXPENSE,$
TYPE=SUBFOOT,LINE=1, OBJECT=FIELD, ITEM=4, POSITION=AINCOME,$
TYPE=SUBFOOT,LINE=1, OBJECT=FIELD, ITEM=5, POSITION=AYTDAMT,$  





Prod: WebFOCUS 7.6.10 MRE
Oracle/Sybase
Test: DevStudio 7.6.6
WF Server 7.6.6
Report Caster 7.6.6
Web Server - Tomcat
MS Windows XP SP2
Output: HTML, Excel 2000 , PDF, CSV, DOC

November 20, 2007, 10:51 AM
Tom Flynn
 
ON TABLE SUBFOOT
" "
"<TITL<TOT.PPLANAMT<TOT.PEXPENSE<TOT.PINCOME<TOT.PYTDAMT"
 

Your SUBFOOT is on LINE 2:

TYPE=SUBFOOT,LINE=1, OBJECT=FIELD, ITEM=1, POSITION=CATEGORY,$
TYPE=SUBFOOT,LINE=1, OBJECT=FIELD, ITEM=2, POSITION=APLANAMT,$
TYPE=SUBFOOT,LINE=1, OBJECT=FIELD, ITEM=3, POSITION=AEXPENSE,$
TYPE=SUBFOOT,LINE=1, OBJECT=FIELD, ITEM=4, POSITION=AINCOME,$
TYPE=SUBFOOT,LINE=1, OBJECT=FIELD, ITEM=5, POSITION=AYTDAMT,$

Not LINE=1...
  



Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
November 20, 2007, 11:01 AM
tlbrydie2
your correct...made change totals still bunched together not under their correct columns




Prod: WebFOCUS 7.6.10 MRE
Oracle/Sybase
Test: DevStudio 7.6.6
WF Server 7.6.6
Report Caster 7.6.6
Web Server - Tomcat
MS Windows XP SP2
Output: HTML, Excel 2000 , PDF, CSV, DOC

November 20, 2007, 11:07 AM
Tom Flynn
S/B
ON DUM SUBFOOT

Not ON TABLE SUBFOOT

Also, change the OBJECT stuff to JUSTIFY=RIGHT,


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
November 20, 2007, 11:18 AM
tlbrydie2
Thanks Tom and every one else for your help !!!




Prod: WebFOCUS 7.6.10 MRE
Oracle/Sybase
Test: DevStudio 7.6.6
WF Server 7.6.6
Report Caster 7.6.6
Web Server - Tomcat
MS Windows XP SP2
Output: HTML, Excel 2000 , PDF, CSV, DOC

November 20, 2007, 12:02 PM
Tom Flynn
I guess that means it is now working for you???


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
November 20, 2007, 12:55 PM
tlbrydie2
Yes...thanks again




Prod: WebFOCUS 7.6.10 MRE
Oracle/Sybase
Test: DevStudio 7.6.6
WF Server 7.6.6
Report Caster 7.6.6
Web Server - Tomcat
MS Windows XP SP2
Output: HTML, Excel 2000 , PDF, CSV, DOC