I have created a prototype EXL2K report to figure out how to display a total in the footer of the
spreadsheet. I have most of this working as necessary, but I can't seem to get past this snag.

I'd like to position the text string "Retail" just to the left of the calculated Retail Total (173,204).
At present "Retail" appears in the 1st column (under COUNTRY).

Can anyone help me?

Here is my code:

-* File test_dcost.fex
-SET &ECHO=ALL;

TABLE FILE CAR
SUM
SALES
RCOST
DCOST
BY COUNTRY
BY CAR
-*
ON COUNTRY SUBFOOT
"SUBTOTAL<+0><ST.SALES><+0><ST.RETAIL><ST.DEALER"
HEADING
"WEBFOCUS REPORT"

FOOTING
"RETAIL: <TOT.RCOST "
-*ALER: <TOT.DCOST>"
" "
"THIS IS A TEST FOOTER TO SPAN ACROSS ALL COLUMNS AT THE BOTTOM OF THE REPORT" 
 "
-XFOOT
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
FONT=ARIAL, SIZE=8, GRID=OFF, $
TYPE=SUBFOOT, HEADALIGN=BODY, STYLE=BOLD, JUSTIFY=RIGHT, $
TYPE=SUBFOOT, ITEM=1, COLSPAN=2, POSITION=COUNTRY, JUSTIFY=LEFT, COLOR=ORANGE, $
TYPE=SUBFOOT, ITEM=2, POSITION=SALES, COLOR=RED, $
TYPE=SUBFOOT, ITEM=3, POSITION=RETAIL, COLOR=GREEN, $
TYPE=SUBFOOT, ITEM=4, POSITION=DEALER, COLOR=BLUE, $
-*
TYPE=HEADING, COLOR=BLACK, JUSTIFY=CENTER, POSITION=CAR, $
-*
TYPE=FOOTING, HEADALIGN=BODY, $
TYPE=FOOTING, ITEM=1, COLSPAN=2, POSITION=CAR, JUSTIFY=LEFT, COLOR=BLUE, $
-GOTO EXSTY
-*****
TYPE=FOOTING, LINE=1, OBJECT=TEXT, ITEM=1, COLSPAN=2, POSITION=SALES, COLOR=RED, $
TYPE=FOOTING, LINE=3, OBJECT=TEXT, COLSPAN=6, JUSTIFY=CENTER, $

-EXSTY
ENDSTYLE
END
-RUN

Thank you!

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

Try this:

FOOTING
"<+0>RETAIL: <TOT.RCOST "
. . .
TYPE=FOOTING, HEADALIGN=BODY, $
TYPE=FOOTING, ITEM=2, COLOR=BLUE, $

That should place a blank cell under Country, and RETAIL: under Car.

This does it:

  
TABLE FILE CAR
SUM
SALES
RCOST
DCOST
BY COUNTRY
BY CAR
-*
ON COUNTRY SUBFOOT
"SUBTOTAL<+0><ST.SALES<ST.RETAIL<ST.DEALER"
HEADING
"WEBFOCUS REPORT"
FOOTING
" <+0>RETAIL: <TOT.RCOST "
" "
-*"Property of U.S. OPM-Return To: OPM-FIS, 1900 E ST NW, Washington, DC 20415-4000"
"THIS IS A TEST FOOTER TO SPAN ACROSS ALL COLUMNS AT THE BOTTOM OF THE REPORT"
-XFOOT
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
FONT=ARIAL, SIZE=8, GRID=OFF, $
TYPE=SUBFOOT, HEADALIGN=BODY, STYLE=BOLD, JUSTIFY=RIGHT, $
TYPE=SUBFOOT, ITEM=1, COLSPAN=2, POSITION=COUNTRY, JUSTIFY=LEFT, COLOR=ORANGE, $
TYPE=SUBFOOT, ITEM=2, POSITION=SALES, COLOR=RED, $
TYPE=SUBFOOT, ITEM=3, POSITION=RETAIL, COLOR=GREEN, $
TYPE=SUBFOOT, ITEM=4, POSITION=DEALER, COLOR=BLUE, $
-*
TYPE=HEADING, COLOR=BLACK, JUSTIFY=CENTER, POSITION=CAR, $
-*
TYPE=FOOTING, HEADALIGN=BODY, $
-*TYPE=FOOTING, ITEM=1, COLSPAN=2, POSITION=CAR, JUSTIFY=LEFT, COLOR=BLUE, $
-*GOTO EXSTY
-*****
TYPE=FOOTING,  LINE=1, OBJECT=TEXT, ITEM=1, COLSPAN=2, $
TYPE=FOOTING,  LINE=1, OBJECT=TEXT, ITEM=2, COLOR=RED, justify=right, $

TYPE=FOOTING,  LINE=3, OBJECT=TEXT, COLSPAN=6, JUSTIFY=CENTER, $

-EXSTY
ENDSTYLE
END

Thank you j.gross and Danny. I have not done EXL2K reports in quite some time.

I thought I had this resolved, but I am struggling to get the text:
"THIS IS A TEST FOOTER TO SPAN ACROSS ALL COLUMNS AT THE BOTTOM OF THE REPORT"
to run across the bottom of the report (starting in c1 through c6).

I thought the colspan=6 would do it, but nope. What am I missing ?

Thank you.

I'm getting this from your orignal code: "colspan=5" also works, widening each column so that it fits in 5 columns.

Thanks Doug.

I'm continuing to work on this issue and here is what I find:

When I run the report ths issues are on line 20 and line 22.
See Line 20 below:
208420 173,204 143,794
On line 20 I have three totals. This is what I want, but at
this time, 208420 lines up beneath the Sales column. Perfect.
173,204 lines up beneath the Retail column. Perfect.
However, 143,794 lines up way to the right. Imperfect.

I am trying to get 143,794 to display beneath the Dealer column.

208420 173,204 143,794

See Line 22 below:

THIS IS A TEST FOOTER TO SPAN ACROSS ALL
COLUMNS AT THE BOTTOM OF THE REPPORT.

After the word "ALL", it wraps to the next line.

Bummer

Tom, Could you post your most recent code?

BTW, I am working with MS Excel 2010.

  
SET PRINTPLUS = ON

TABLE FILE CAR
SUM
SALES
RCOST
DCOST
BY COUNTRY
BY CAR
-*
ON COUNTRY SUBFOOT
"SUBTOTAL<+0><ST.SALES><+0><ST.RETAIL<ST.DEALER"
HEADING
"WEBFOCUS REPORT"
""
FOOTING
" <+0>RETAIL: <TOT.RCOST "
" <TOT.SALES<+0><TOT.RCOST><+0><TOT.DCOST"
" "
"THIS IS A TEST FOOTER TO SPAN ACROSS ALL COLUMNS AT THE BOTTOM OF THE REPORT"

-XFOOT
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
FONT=ARIAL, SIZE=8, GRID=OFF, $
TYPE=SUBFOOT, HEADALIGN=BODY, STYLE=BOLD, JUSTIFY=RIGHT, $
TYPE=SUBFOOT, ITEM=1, COLSPAN=2, POSITION=COUNTRY, JUSTIFY=LEFT, COLOR=ORANGE, $
TYPE=SUBFOOT, ITEM=2, POSITION=SALES, COLOR=RED, $
TYPE=SUBFOOT, ITEM=3, POSITION=RETAIL, COLOR=GREEN, $
TYPE=SUBFOOT, ITEM=4, POSITION=DEALER, COLOR=BLUE, $
-*
TYPE=HEADING, COLOR=BLACK, JUSTIFY=CENTER, POSITION=CAR, $
-*
TYPE=FOOTING, HEADALIGN=BODY, $
-GOTO GDSTY
-GDSTY
TYPE=FOOTING, LINE=1, OBJECT=TEXT, ITEM=1, COLSPAN=2, $
TYPE=FOOTING, LINE=1, OBJECT=TEXT, ITEM=2, COLOR=RED, JUSTIFY=LEFT, $
-*
TYPE=FOOTING, LINE=2, OBJECT=TEXT, ITEM=1, COLSPAN=2, COLOR=RED, JUSTIFY=LEFT, $
TYPE=FOOTING, LINE=2, OBJECT=TEXT, ITEM=2, COLSPAN=3, COLOR=BLUE, JUSTIFY=LEFT, $
TYPE=FOOTING, LINE=2, OBJECT=TEXT, ITEM=3, COLSPAN=4, COLOR=ORANGE, JUSTIFY=LEFT, $
-*
-**** STREAM THE TEXT FOOTER ACROSS THE ENTIRE PAGE ... 
TYPE=FOOTING, LINE=3, OBJECT=TEXT, COLSPAN=5, JUSTIFY=CENTER, $

-EXSTY
ENDSTYLE
END
-RUN

just another "gnat in the eye":

-*
-*TYPE=FOOTING, LINE=2, OBJECT=TEXT, ITEM=1, COLSPAN=2, COLOR=RED, JUSTIFY=LEFT, $
-*TYPE=FOOTING, LINE=2, OBJECT=TEXT, ITEM=2, COLSPAN=3, COLOR=BLUE, JUSTIFY=LEFT, $
-*TYPE=FOOTING, LINE=2, OBJECT=TEXT, ITEM=3, COLSPAN=4, COLOR=ORANGE, JUSTIFY=LEFT, $
-*TYPE=FOOTING, LINE=2, OBJECT=TEXT, ITEM=3, COLOR=ORANGE, JUSTIFY=LEFT, $
-*
-**** STREAM THE TEXT FOOTER ACROSS THE ENTIRE PAGE ... 
-*TYPE=FOOTING, LINE=3, OBJECT=TEXT, COLSPAN=5, JUSTIFY=CENTER, $
TYPE=FOOTING, LINE=4, OBJECT=TEXT, COLSPAN=5, JUSTIFY=CENTER, $

It works, Thanks!

You know after a while the eyes go crossed and
you miss which line you're on.

Nevertheless, I still cannot get the dealer total to display under the DEALER column.
drats.

I finally remembered that ON TABLE COLUMN-TOTAL is usually the most effective method to create a report w column totals

My Bad.

Gnats for me.

Thx for your help.