 |
|||||
|
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
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 WebFOCUS/FOCUS Forum on Focal Point [SOLVED]Border Line length in Subfoot of Excel output file
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED]Border Line length in Subfoot of Excel output file Read-Only TopicGo | Search | Notify | Tools |
| [SOLVED]Border Line length in Subfoot of Excel output file | Login/Join |
| Guru |
I need to know how to get the bottom border line to be the same colspan length of 5 like the rest of the border lines. SET NODATA = '';
SET ASNAMES = ON
SET PRINTPLUS=ON
DEFINE FILE CAR
BLANK/A1 = ' ';
BLANK1/A1 = ' ';
BLANK2/A1 = ' ';
BLANK3/A1 = ' ';
FILLER/A1 = ' ';
END
TABLE FILE CAR
HEADING
"Testing Border in Subfoot "
" "
" "
PRINT BODYTYPE POWER MILES WARRANTY RCOST DCOST SALES
-*BY FILLER NOPRINT
BY BLANK NOPRINT
BY BLANK1 NOPRINT
BY BLANK2 NOPRINT
BY BLANK3 NOPRINT
BY COUNTRY
BY CAR
ON BLANK3 SUBFOOT
""
""
" Summary Detail "
ON BLANK2 SUBFOOT
" Average Cost - Standard Invoice "
" Invoice Count of Invoicess Meeting the Standard "
" % of the Invoices Meeting the Standard "
" Count of Invoices that are over the Standard Cost "
" % of Invoices that are over the total cost of the product "
""
" Total Invoice Cost of all disability invoices "
" Count of Invoices that are not total disability invoices "
" % of total disability invoices "
" Count of disability that so not meet standards "
" % of partial disability invoices "
""
" Average cost of all invoices including disability invoices "
" Average count of all invoices "
" % of average disability invoices "
" Count invoices that are not disability "
" % of invoices that are not disability "
""
" Count of invoices that were not approved "
ON BLANK1 SUBFOOT
""
""
""
" Footnote "
ON BLANK SUBFOOT
""
" Calculation 1 "
" Calculation 2"
" Standard and non-standard invoices are separated according the the company`s standard policy procedure "
" Calculation 3"
" Calculation 4"
" Calculation 5"
" Calculation 6"
" Calculation 7"
""
ON TABLE SET PAGE-NUM OFF
-*ON TABLE SET EMPTYCELLS OFF
ON TABLE NOTOTAL
ON TABLE SET SHOWBLANKS ON
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
$
-*TYPE=GRANDTOTAL,STYLE=BOLD,BORDER-TOP=MEDIUM,BORDER-TOP-COLOR=RGB(31 46 110),$
-*TYPE=SUBTOTAL,BORDER-RIGHT=0.20,$
-*TYPE=SUBTOTAL,BORDER-LEFT=0.20,$
TYPE=REPORT,
FONT='ARIAL',
SIZE=9,$
TYPE=SUBFOOT,
BORDER-TOP=HEAVY,
BORDER-BOTTOM=HEAVY,
BORDER-LEFT=HEAVY,
BORDER-RIGHT=HEAVY,
BACKCOLOR=RGB(237 241 213),
COLSPAN=5,
$
-* Removes the right border from the blank lines that appear right before "Summary Detail"
TYPE=SUBFOOT,
BY=4,
BORDER-RIGHT=OFF,
BACKCOLOR=WHITE,
$
-* Removes the right border from the blank lines that appear right before "Footnote"
TYPE=SUBFOOT,
BY=2,
BORDER-RIGHT=OFF,
BACKCOLOR=WHITE,
$
-* Makes the word "Footnote" BOLD
TYPE=SUBFOOT,
BY=2,
LINE=4,
OBJECT=TEXT,
STYLE=BOLD,
$
-* Makes words "Summary Detail" BOLD
TYPE=SUBFOOT,
BY=4,
LINE=3,
OBJECT=TEXT,
STYLE=BOLD,
$
ENDSTYLE
END This message has been edited. Last edited by: Michele Brooks, WF 8205, Windows 10 Oracle DBMS EXL07/PDF Output | ||
|
| Virtuoso |
I don't have access to WebFOCUS right now to test this but it seems to me like your missing a keyword to mae your SUBFOOT "cells" align with those in the "BODY" of the report. Try this:
TYPE=SUBFOOT,
HEADALIGN=BODY,
COLSPAN=5,
BORDER-TOP=HEAVY,
BORDER-BOTTOM=HEAVY,
BORDER-LEFT=HEAVY,
BORDER-RIGHT=HEAVY,
BACKCOLOR=RGB(237 241 213),
$
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. | |||
|
| Guru |
If I do the HEADALIGN=BODY the COLSPAN=5 is ignored and the box borders extends to the full length of the report columns. I want the box borders to extend to only 5 columns. Thanks. WF 8205, Windows 10 Oracle DBMS EXL07/PDF Output | |||
|
| Guru |
I was able to get the bottom line borders to be the same length as the top borders, but now the colspan does not work. The box border width is the same width as the report. I need the box borders to extend to 5 columns. See revised code below. -* File brooks1.fex
SET NODATA = '';
SET ASNAMES = ON
SET PRINTPLUS=ON
DEFINE FILE CAR
BLANK/A1 = ' ';
BLANK1/A1 = ' ';
BLANK2/A1 = ' ';
BLANK3/A1 = ' ';
BLANK4/A1 = '';
FILLER/A1 = ' ';
FILLER2/A1 = ' ';
END
TABLE FILE CAR
HEADING
"Testing Border in Subfoot "
" "
SUM RCOST DCOST SALES RCOST DCOST SALES
BY BLANK NOPRINT
BY BLANK1 NOPRINT
BY BLANK2 NOPRINT
BY BLANK3 NOPRINT
BY CAR
BY COUNTRY
BY FILLER NOPRINT
BY FILLER2 NOPRINT
ON FILLER RECOMPUTE
SUM. SALES
SUM. RCOST
SUM. DCOST MULTILINES AS 'Totals'
ON FILLER2 RECOMPUTE
AVE. SALES MULTILINES AS 'Average'
ON BLANK3 SUBFOOT
""
""
" Summary Detail "
ON BLANK2 SUBFOOT
" Average Cost - Standard Invoice "
" Invoice Count of Invoicess Meeting the Standard "
" % of the Invoices Meeting the Standard "
" Count of Invoices that are over the Standard Cost "
" % of Invoices that are over the total cost of the product "
""
" Total Invoice Cost of all disability invoices "
" Count of Invoices that are not total disability invoices "
" % of total disability invoices "
" Count of disability that so not meet standards "
" % of partial disability invoices "
""
" Average cost of all invoices including disability invoices "
" Average count of all invoices "
" % of average disability invoices "
" Count invoices that are not disability "
" % of invoices that are not disability "
""
" Count of invoices that were not approved "
""
ON BLANK1 SUBFOOT
""
""
""
" Footnote "
ON BLANK SUBFOOT
""
" Calculation 1 "
" Calculation 2"
" Standard and non-standard invoices are separated according to the company`s standard policy procedure "
" Calculation 3"
" Calculation 4"
" Calculation 5"
" Calculation 6"
" Calculation 7"
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=OFF,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=9,$
-* Right and Left Borders and Border Back Color
TYPE=SUBFOOT,
BORDER-LEFT=LIGHT,BORDER-LEFT-COLOR=BLACK,
BORDER-RIGHT=LIGHT,BORDER-RIGHT-COLOR=BLACK,
BACKCOLOR=RGB(237 241 213),$
-* Top and Bottom Borders for both boxes
TYPE=SUBFOOT,BY=3,BORDER-TOP=LIGHT,BORDER-BOTTOM-COLOR=BLACK,$
TYPE=SUBFOOT,BY=2,BORDER-BOTTOM=LIGHT,BORDER-BOTTOM-COLOR=BLACK,$
TYPE=SUBFOOT,BY=1,BORDER-BOTTOM=LIGHT,BORDER-BOTTOM-COLOR=BLACK,$
-* Gets rid of the borders and grid lines on the blank lines that appear before the Summary Detail section
TYPE=SUBFOOT,BY=4,BORDER=OFF,BACKCOLOR=WHITE,$
-* Gets rid of the borders and grid lines on the blank lines that appear before the Footnote section
TYPE=SUBFOOT,BY=2,BORDER-RIGHT=OFF,BACKCOLOR=WHITE,$
TYPE=SUBFOOT,BY=2,LINE=1,BACKCOLOR=WHITE,$
TYPE=SUBFOOT,BY=2,LINE=2,BORDER-RIGHT=OFF,BACKCOLOR=WHITE,$
TYPE=SUBFOOT,BY=2,LINE=3,BORDER-RIGHT=OFF,BACKCOLOR=WHITE,$
TYPE=SUBFOOT,BY=2,LINE=4,BORDER-RIGHT=OFF,BACKCOLOR=WHITE,$
-* Makes the word "Footnote" BOLD
TYPE=SUBFOOT,BY=2,LINE=4,OBJECT=TEXT,STYLE=BOLD,$
-* Makes words "Summary Detail" BOLD
TYPE=SUBFOOT,BY=4,LINE=3,OBJECT=TEXT,STYLE=BOLD,$
ENDSTYLE
END
WF 8205, Windows 10 Oracle DBMS EXL07/PDF Output | |||
|
| Guru |
I finally solved my problem. I had to add two additional BY statements and also get rid of any unncessary borders. The code pasted below is the code that works. Borders can be very tricky.
SET NODATA = '';
SET ASNAMES = ON
SET PRINTPLUS=ON
DEFINE FILE CAR
BLANK/A1 = '';
BLANK1/A1 = '';
BLANK1A/A1 = '';
BLANK2/A1 = '';
BLANK3/A1 = '';
BLANK4/A1 = '';
FILLER/A1 = '';
FILLER2/A1 = '';
FILLER3/A1 = '';
END
TABLE FILE CAR
HEADING
"Testing Border in Subfoot "
" "
SUM RCOST DCOST SALES RCOST DCOST SALES
BY FILLER3 NOPRINT
BY BLANK NOPRINT
BY BLANK1 NOPRINT
BY BLANK1A NOPRINT
BY BLANK2 NOPRINT
BY BLANK3 NOPRINT
BY CAR
BY COUNTRY
BY FILLER NOPRINT
BY FILLER2 NOPRINT
ON FILLER RECOMPUTE
SUM. SALES
SUM. RCOST
SUM. DCOST MULTILINES AS 'Totals'
ON FILLER2 RECOMPUTE
AVE. SALES MULTILINES AS 'Average'
ON BLANK3 SUBFOOT
""
""
" Summary Detail "
ON BLANK2 SUBFOOT
" Average Cost - Standard Invoice "
" Invoice Count of Invoicess Meeting the Standard "
" % of the Invoices Meeting the Standard "
" Count of Invoices that are over the Standard Cost "
" % of Invoices that are over the total cost of the product "
""
" Total Invoice Cost of all disability invoices "
" Count of Invoices that are not total disability invoices "
" % of total disability invoices "
" Count of disability that so not meet standards "
" % of partial disability invoices "
""
" Average cost of all invoices including disability invoices "
" Average count of all invoices "
" % of average disability invoices "
" Count invoices that are not disability "
" % of invoices that are not disability "
""
" Count of invoices that were not approved "
""
ON BLANK1A SUBFOOT
""
ON BLANK1 SUBFOOT
""
""
""
" Footnote "
ON BLANK SUBFOOT
""
" Calculation 1 "
" Calculation 2"
" Standard and non-standard invoices are separated according to the company`s standard policy procedure "
" Calculation 3"
" Calculation 4"
" Calculation 5"
" Calculation 6"
" Calculation 7"
""
ON FILLER3 SUBFOOT
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=OFF,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=9,$
-* Turns borders on, gets rid of the extra bottom border line
-* Turns the right and left borders off for the blank line that appears after the last bottom border
-* Gets rid of the grid lines for the blank line that appears after the last bottom border
TYPE=SUBFOOT,BORDER=ON,BACKCOLOR=RGB(237 241 213),$
TYPE=SUBFOOT,BY=1,BORDER-BOTTOM=ON,BORDER-BOTTOM-COLOR=WHITE,BORDER-TOP-COLOR=BLACK,COLSPAN=5,$
TYPE=SUBFOOT,BY=1,BORDER-RIGHT=OFF,BORDER-LEFT=OFF,BACKCOLOR=WHITE,$
TYPE=SUBFOOT,BY=3,BORDER-LEFT=OFF,BACKCOLOR=WHITE,$
-* Sets Colspan to 5
-* Gets rid of any unnecessary borders
TYPE=SUBFOOT,BY=2,COLSPAN=5,$
TYPE=SUBFOOT,BY=3,BORDER-BOTTOM=OFF,$
TYPE=SUBFOOT,BY=4,COLSPAN=5,BORDER-RIGHT=OFF,BORDER-LEFT=OFF,BACKCOLOR=WHITE,$
TYPE=SUBFOOT,BY=5,COLSPAN=5,$
-* Gets rid of the borders and grid lines on the blank lines that appear before the Summary Detail section
TYPE=SUBFOOT,BY=6,BORDER=OFF,BACKCOLOR=WHITE,$
-* Gets rid of the borders and grid lines on the blank lines that appear before the Footnote section
TYPE=SUBFOOT,BY=3,BORDER-RIGHT=OFF,BACKCOLOR=WHITE,$
-* Makes the word "Footnote" BOLD
TYPE=SUBFOOT,BY=3,LINE=4,OBJECT=TEXT,SIZE=10,STYLE=BOLD,$
-* Makes words "Summary Detail" BOLD
TYPE=SUBFOOT,BY=6,LINE=3,OBJECT=TEXT,SIZE=10,STYLE=BOLD,$
ENDSTYLE
END
WF 8205, Windows 10 Oracle DBMS EXL07/PDF Output | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED]Border Line length in Subfoot of Excel output file
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED]Border Line length in Subfoot of Excel output fileCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |