Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Error: Display a total in footer of EXL2K report [SOLVED]

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Error: Display a total in footer of EXL2K report [SOLVED]
 Login/Join
 
Master
posted
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! Confused

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


Tomsweb
WebFOCUS 8.1.05M, 8.2.x
APP Studio, Developer Studio, InfoAssist, Dashboards, charts & reports
Apache Tomcat/8.0.36
 
Posts: 573 | Location: Baltimore, MD | Registered: July 06, 2006Report This Post
Virtuoso
posted Hide Post
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.
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Report This Post
Virtuoso
posted Hide Post
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


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
Master
posted Hide Post
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.


Tomsweb
WebFOCUS 8.1.05M, 8.2.x
APP Studio, Developer Studio, InfoAssist, Dashboards, charts & reports
Apache Tomcat/8.0.36
 
Posts: 573 | Location: Baltimore, MD | Registered: July 06, 2006Report This Post
Expert
posted Hide Post
I'm getting this from your orignal code:
"colspan=5" also works, widening each column so that it fits in 5 columns.
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Master
posted Hide Post
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


Tomsweb
WebFOCUS 8.1.05M, 8.2.x
APP Studio, Developer Studio, InfoAssist, Dashboards, charts & reports
Apache Tomcat/8.0.36
 
Posts: 573 | Location: Baltimore, MD | Registered: July 06, 2006Report This Post
Expert
posted Hide Post
Tom, Could you post your most recent code?
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Master
posted Hide Post
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


Tomsweb
WebFOCUS 8.1.05M, 8.2.x
APP Studio, Developer Studio, InfoAssist, Dashboards, charts & reports
Apache Tomcat/8.0.36
 
Posts: 573 | Location: Baltimore, MD | Registered: July 06, 2006Report This Post
Expert
posted Hide Post
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, $
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Master
posted Hide Post
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.


Tomsweb
WebFOCUS 8.1.05M, 8.2.x
APP Studio, Developer Studio, InfoAssist, Dashboards, charts & reports
Apache Tomcat/8.0.36
 
Posts: 573 | Location: Baltimore, MD | Registered: July 06, 2006Report This Post
Master
posted Hide Post
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.


Tomsweb
WebFOCUS 8.1.05M, 8.2.x
APP Studio, Developer Studio, InfoAssist, Dashboards, charts & reports
Apache Tomcat/8.0.36
 
Posts: 573 | Location: Baltimore, MD | Registered: July 06, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Error: Display a total in footer of EXL2K report [SOLVED]

Copyright © 1996-2020 Information Builders