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     Subtotal Borders [SOLVED]

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Subtotal Borders [SOLVED]
 Login/Join
 
VinceCSW
Member
posted
I am creating a procedure and running into a problem with borders. The output
is HTML.

When I have borders (top, bottom, left, and write) around all of the data, the
borders are all there.

When I added a subtotal based on a sort field, I lose the bottom border of the
last detail record.

When I add a subfooting on the sort field, the bottom border of the last detail
reappears as it should

Next I go to add borders and background color to the subtotal lines. Again,
only the left, top, and right borders appear.

I'm not sure what other options would prevent the bottom border from appearing
even though it is specified in the code and can be seen in the GUI options as
well.

*****************************************************************
Here is my source:

SET BYDISPLAY = ON
DEFINE FILE CAR
SORT_FIELD/A1=' ';
END
TABLE FILE CAR
PRINT
'CAR.COMP.CAR'
'CAR.BODY.SEATS'
'CAR.BODY.DEALER_COST'
'CAR.BODY.RETAIL_COST'
'CAR.BODY.SALES'
'CAR.SPECS.LENGTH'
'CAR.SPECS.WIDTH'
'CAR.SPECS.HEIGHT'
'CAR.SPECS.WEIGHT'
'CAR.SPECS.WHEELBASE'
'CAR.SPECS.FUEL_CAP'
'CAR.SPECS.BHP'
'CAR.SPECS.RPM'
'CAR.SPECS.MPG'
BY SORT_FIELD NOPRINT
BY 'CAR.ORIGIN.COUNTRY'

ON SORT_FIELD SUBTOTAL AS '*TOTAL'
ON SORT_FIELD SUBFOOT WITHIN
" "
HEADING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=8,
$
TYPE=DATA,
COLUMN=N4,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
$
TYPE=DATA,
COLUMN=N9,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
$
TYPE=DATA,
COLUMN=N10,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
$
TYPE=DATA,
COLUMN=N11,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
$
TYPE=DATA,
COLUMN=N12,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
$
TYPE=DATA,
COLUMN=N5,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BACKCOLOR=RGB(229 229 229),
$
TYPE=DATA,
COLUMN=N6,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BACKCOLOR=RGB(229 229 229),
$
TYPE=DATA,
COLUMN=N7,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BACKCOLOR=RGB(229 229 229),
$
TYPE=DATA,
COLUMN=N8,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BACKCOLOR=RGB(229 229 229),
$
TYPE=DATA,
COLUMN=N13,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BACKCOLOR=RGB(229 229 229),
$
TYPE=DATA,
COLUMN=N14,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BACKCOLOR=RGB(229 229 229),
$
TYPE=DATA,
COLUMN=N15,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BACKCOLOR=RGB(229 229 229),
$
TYPE=DATA,
COLUMN=N16,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BACKCOLOR=RGB(229 229 229),
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N4,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=OFF,
BORDER-RIGHT=OFF,
$
TYPE=SUBTOTAL,
BY=1,
COLUMN=N4,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
$
TYPE=SUBTOTAL,
BY=1,
COLUMN=N9,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
$
TYPE=SUBTOTAL,
BY=1,
COLUMN=N10,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
$
TYPE=SUBTOTAL,
BY=1,
COLUMN=N11,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
$
TYPE=SUBTOTAL,
BY=1,
COLUMN=N12,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
$
TYPE=SUBTOTAL,
BY=1,
COLUMN=N5,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BACKCOLOR=RGB(229 229 229),
$
TYPE=SUBTOTAL,
BY=1,
COLUMN=N6,
BORDER-BOTTOM=LIGHT,
BACKCOLOR=RGB(229 229 229),
$
TYPE=SUBTOTAL,
BY=1,
COLUMN=N7,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BACKCOLOR=RGB(229 229 229),
$
TYPE=SUBTOTAL,
BY=1,
COLUMN=N8,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BACKCOLOR=RGB(229 229 229),
$
TYPE=SUBTOTAL,
BY=1,
COLUMN=N13,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BACKCOLOR=RGB(229 229 229),
$
TYPE=SUBTOTAL,
BY=1,
COLUMN=N14,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BACKCOLOR=RGB(229 229 229),
$
TYPE=SUBTOTAL,
BY=1,
COLUMN=N15,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BACKCOLOR=RGB(229 229 229),
$
TYPE=SUBTOTAL,
BY=1,
COLUMN=N16,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BACKCOLOR=RGB(229 229 229),
$
ENDSTYLE
END
*******************************************************************************

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


WebFocus 8.2.01
Windows 2016
XLSX, HTML, PDF
 
Posts: 9 | Registered: October 12, 2011Report This Post
Francis Mariani
Expert
posted Hide Post
Here's a variation that gets you the bottom border, but unfortunately also on the first two columns.

SET BYDISPLAY = ON
DEFINE FILE CAR
SORT_FIELD/A1=' ';
END
TABLE FILE CAR
PRINT
'CAR.COMP.CAR'
'CAR.BODY.SEATS'
'CAR.BODY.DEALER_COST'
'CAR.BODY.RETAIL_COST'
'CAR.BODY.SALES'
'CAR.SPECS.LENGTH'
'CAR.SPECS.WIDTH'
'CAR.SPECS.HEIGHT'
'CAR.SPECS.WEIGHT'
'CAR.SPECS.WHEELBASE'
'CAR.SPECS.FUEL_CAP'
'CAR.SPECS.BHP'
'CAR.SPECS.RPM'
'CAR.SPECS.MPG'
BY SORT_FIELD NOPRINT
BY 'CAR.ORIGIN.COUNTRY'

ON SORT_FIELD SUBTOTAL AS '*TOTAL'
ON SORT_FIELD SUBFOOT WITHIN
" "
HEADING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=8,
$
TYPE=DATA,
COLUMN=N4,
BORDER=LIGHT,
$
TYPE=DATA,
COLUMN=N9,
BORDER=LIGHT,
$
TYPE=DATA,
COLUMN=N10,
BORDER=LIGHT,
$
TYPE=DATA,
COLUMN=N11,
BORDER=LIGHT,
$
TYPE=DATA,
COLUMN=N12,
BORDER=LIGHT,
$
TYPE=DATA,
COLUMN=N5,
BORDER=LIGHT,
BACKCOLOR=RGB(229 229 229),
$
TYPE=DATA,
COLUMN=N6,
BORDER=LIGHT,
BACKCOLOR=RGB(229 229 229),
$
TYPE=DATA,
COLUMN=N7,
BORDER=LIGHT,
BACKCOLOR=RGB(229 229 229),
$
TYPE=DATA,
COLUMN=N8,
BORDER=LIGHT,
BACKCOLOR=RGB(229 229 229),
$
TYPE=DATA,
COLUMN=N13,
BORDER=LIGHT,
BACKCOLOR=RGB(229 229 229),
$
TYPE=DATA,
COLUMN=N14,
BORDER=LIGHT,
BACKCOLOR=RGB(229 229 229),
$
TYPE=DATA,
COLUMN=N15,
BORDER=LIGHT,
BACKCOLOR=RGB(229 229 229),
$
TYPE=DATA,
COLUMN=N16,
BORDER=LIGHT,
BACKCOLOR=RGB(229 229 229),
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N4,
BORDER=OFF,
$

TYPE=SUBTOTAL,
BY=1,
BORDER=LIGHT,
$

TYPE=SUBTOTAL,
BY=1,
COLUMN=N2,
BORDER=0,
$
TYPE=SUBTOTAL,
BY=1,
COLUMN=N3,
BORDER=0,
BORDER-RIGHT=LIGHT,
$

TYPE=SUBTOTAL,
BY=1,
COLUMN=N5,
BACKCOLOR=RGB(229 229 229),
$
TYPE=SUBTOTAL,
BY=1,
COLUMN=N6,
BACKCOLOR=RGB(229 229 229),
$
TYPE=SUBTOTAL,
BY=1,
COLUMN=N7,
BACKCOLOR=RGB(229 229 229),
$
TYPE=SUBTOTAL,
BY=1,
COLUMN=N8,
BACKCOLOR=RGB(229 229 229),
$
TYPE=SUBTOTAL,
BY=1,
COLUMN=N13,
BACKCOLOR=RGB(229 229 229),
$
TYPE=SUBTOTAL,
BY=1,
COLUMN=N14,
BACKCOLOR=RGB(229 229 229),
$
TYPE=SUBTOTAL,
BY=1,
COLUMN=N15,
BACKCOLOR=RGB(229 229 229),
$
TYPE=SUBTOTAL,
BY=1,
COLUMN=N16,
BACKCOLOR=RGB(229 229 229),
$
ENDSTYLE
END


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Greg G
Member
posted Hide Post
here is my version, I have added SET DROPBLNKLINES=ALL to the top, removed the ON SORTFIELD SUBTOTAL, SUBFOOT and used ON TABLE SUBTOTAL. Within the styling section I changed the TYPE=SUBTOTAL to GRANDTOTAL and removed the BY= in each one as well.

SET DROPBLNKLINES=ALL
SET BYDISPLAY = ON
DEFINE FILE CAR
SORT_FIELD/A1=' ';
END
TABLE FILE CAR
PRINT
'CAR.COMP.CAR'
'CAR.BODY.SEATS'
'CAR.BODY.DEALER_COST'
'CAR.BODY.RETAIL_COST'
'CAR.BODY.SALES'
'CAR.SPECS.LENGTH'
'CAR.SPECS.WIDTH'
'CAR.SPECS.HEIGHT'
'CAR.SPECS.WEIGHT'
'CAR.SPECS.WHEELBASE'
'CAR.SPECS.FUEL_CAP'
'CAR.SPECS.BHP'
'CAR.SPECS.RPM'
'CAR.SPECS.MPG'
BY SORT_FIELD NOPRINT
BY 'CAR.ORIGIN.COUNTRY'

-*ON SORT_FIELD SUBTOTAL AS '*TOTAL'
ON TABLE SUBTOTAL
-*ON SORT_FIELD SUBFOOT WITHIN
-*" "
-*HEADING
-*""
ON TABLE SET PAGE-NUM OFF
-*ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=8,
$
TYPE=DATA,
COLUMN=N4,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
$
TYPE=DATA,
COLUMN=N9,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
$
TYPE=DATA,
COLUMN=N10,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
$
TYPE=DATA,
COLUMN=N11,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
$
TYPE=DATA,
COLUMN=N12,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
$
TYPE=DATA,
COLUMN=N5,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BACKCOLOR=RGB(229 229 229),
$
TYPE=DATA,
COLUMN=N6,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BACKCOLOR=RGB(229 229 229),
$
TYPE=DATA,
COLUMN=N7,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BACKCOLOR=RGB(229 229 229),
$
TYPE=DATA,
COLUMN=N8,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BACKCOLOR=RGB(229 229 229),
$
TYPE=DATA,
COLUMN=N13,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BACKCOLOR=RGB(229 229 229),
$
TYPE=DATA,
COLUMN=N14,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BACKCOLOR=RGB(229 229 229),
$
TYPE=DATA,
COLUMN=N15,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BACKCOLOR=RGB(229 229 229),
$
TYPE=DATA,
COLUMN=N16,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BACKCOLOR=RGB(229 229 229),
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N4,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=OFF,
BORDER-RIGHT=OFF,
$
TYPE=GRANDTOTAL,
COLUMN=N4,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
$
TYPE=GRANDTOTAL,
COLUMN=N9,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
$
TYPE=GRANDTOTAL,
COLUMN=N10,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
$
TYPE=GRANDTOTAL,
COLUMN=N11,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
$
TYPE=GRANDTOTAL,
COLUMN=N12,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
$
TYPE=GRANDTOTAL,
COLUMN=N5,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BACKCOLOR=RGB(229 229 229),
$
TYPE=GRANDTOTAL,
COLUMN=N6,
BORDER-BOTTOM=LIGHT,
BACKCOLOR=RGB(229 229 229),
$
TYPE=GRANDTOTAL,
COLUMN=N7,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BACKCOLOR=RGB(229 229 229),
$
TYPE=GRANDTOTAL,
COLUMN=N8,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BACKCOLOR=RGB(229 229 229),
$
TYPE=GRANDTOTAL,
COLUMN=N13,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BACKCOLOR=RGB(229 229 229),
$
TYPE=GRANDTOTAL,
COLUMN=N14,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BACKCOLOR=RGB(229 229 229),
$
TYPE=GRANDTOTAL,
COLUMN=N15,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BACKCOLOR=RGB(229 229 229),
$
TYPE=GRANDTOTAL,
COLUMN=N16,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
$
ENDSTYLE
END
 
Posts: 12 | Registered: June 08, 2010Report This Post
Greg G
Member
posted Hide Post
Sorry, I didn't realize you were are in 7.6.11 which does not have drop blank lines, therefore my solution will not work for you.
 
Posts: 12 | Registered: June 08, 2010Report This Post
VinceCSW
Member
posted Hide Post
It actually does work, Greg. the only problem is that some of the fields in my subtotal for my real report are computes, which means the total line needs to be a recompute to get the proper data results. Thanks for the help. Any other ideas are certainly welcome


WebFocus 8.2.01
Windows 2016
XLSX, HTML, PDF
 
Posts: 9 | Registered: October 12, 2011Report This Post
njsden
Virtuoso
posted Hide Post
How about this?

SET BYDISPLAY = ON
TABLE FILE CAR
PRINT
'CAR.COMP.CAR'
'CAR.BODY.SEATS'
'CAR.BODY.DEALER_COST'
'CAR.BODY.RETAIL_COST'
'CAR.BODY.SALES'
'CAR.SPECS.LENGTH'
'CAR.SPECS.WIDTH'
'CAR.SPECS.HEIGHT'
'CAR.SPECS.WEIGHT'
'CAR.SPECS.WHEELBASE'
'CAR.SPECS.FUEL_CAP'
'CAR.SPECS.BHP'
'CAR.SPECS.RPM'
'CAR.SPECS.MPG'
COMPUTE MARKUP/D7.2% = ((RETAIL_COST / DEALER_COST) - 1) * 100;
BY 'CAR.ORIGIN.COUNTRY'

ON TABLE SUMMARIZE AS '* TOTAL'
HEADING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT, FONT='ARIAL', SIZE=8, $
TYPE=DATA, BORDER=LIGHT, $
TYPE=GRANDTOTAL, BORDER=LIGHT, STYLE=BOLD, $
$
TYPE=DATA, COLUMN=P1, BORDER=OFF, $
TYPE=DATA, COLUMN=P2, BORDER-LEFT=OFF, BORDER-TOP=OFF, BORDER-BOTTOM=OFF, $
TYPE=DATA, COLUMN=P4, BACKCOLOR=RGB(229 229 229), $
TYPE=DATA, COLUMN=P5, BACKCOLOR=RGB(229 229 229), $
TYPE=DATA, COLUMN=P6, BACKCOLOR=RGB(229 229 229), $
TYPE=DATA, COLUMN=P7, BACKCOLOR=RGB(229 229 229), $
TYPE=DATA, COLUMN=P12, BACKCOLOR=RGB(229 229 229), $
TYPE=DATA, COLUMN=P13, BACKCOLOR=RGB(229 229 229), $
TYPE=DATA, COLUMN=P14, BACKCOLOR=RGB(229 229 229), $
TYPE=DATA, COLUMN=P15, BACKCOLOR=RGB(229 229 229), $
TYPE=DATA, COLUMN=P16, BACKCOLOR=RGB(229 229 229), $
$
TYPE=GRANDTOTAL, COLUMN=P1, BORDER=OFF, $
TYPE=GRANDTOTAL, COLUMN=P2, BORDER-LEFT=OFF, BORDER-TOP=OFF, BORDER-BOTTOM=OFF, $
TYPE=GRANDTOTAL, COLUMN=P4, BACKCOLOR=RGB(229 229 229), $
TYPE=GRANDTOTAL, COLUMN=P5, BACKCOLOR=RGB(229 229 229), $
TYPE=GRANDTOTAL, COLUMN=P6, BACKCOLOR=RGB(229 229 229), $
TYPE=GRANDTOTAL, COLUMN=P7, BACKCOLOR=RGB(229 229 229), $
TYPE=GRANDTOTAL, COLUMN=P12, BACKCOLOR=RGB(229 229 229), $
TYPE=GRANDTOTAL, COLUMN=P13, BACKCOLOR=RGB(229 229 229), $
TYPE=GRANDTOTAL, COLUMN=P14, BACKCOLOR=RGB(229 229 229), $
TYPE=GRANDTOTAL, COLUMN=P15, BACKCOLOR=RGB(229 229 229), $
TYPE=GRANDTOTAL, COLUMN=P16, BACKCOLOR='SILVER', $
$
ENDSTYLE
END


I added a COMPUTE'd field at the end just to test the "recompute" effect in the grandtotal line.

Hopefully there are not significant differences in the way HTML borders are handled between 7.6.11 and 7.7.03.


Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Report This Post
VinceCSW
Member
posted Hide Post
That worked great. Thanks for your help.


WebFocus 8.2.01
Windows 2016
XLSX, HTML, PDF
 
Posts: 9 | Registered: October 12, 2011Report This Post
njsden
Virtuoso
posted Hide Post
You're welcome! I'm glad it worked!


Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Report 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     Subtotal Borders [SOLVED]

Copyright © 1996-2020 Information Builders