 |
|||||
|
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] Insert vertical lines when using SPOT Markers?
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Insert vertical lines when using SPOT Markers? Read-Only TopicGo | Search | Notify | Tools |
| [SOLVED] Insert vertical lines when using SPOT Markers? | Login/Join |
| Gold member |
Is there a way to continue vertical lines when aligning defined text fields in a subfoot or subtotal? For example, I have the following: ON CATEGORY SUBFOOT "Total Available<+0> <+0> <+0><COL_TA2<+0> <+0><COL_TA6<+0> <+0><COL_TA10" which I would like to continue the 'MEDIUM' vertical lines through this row:  Any ideas? I would like five vertical lines placed: Left of column 1 shown above Right of column 2 Right of column 4 Right of column 6 Right of column 8This message has been edited. Last edited by: globalwm, 8.0.02M, Oracle 11.2 (AIX), Windows 2008R2, HTML, PDF, Excel | ||
|
| Expert |
I was under the impression that 7.7.0 ? or 8 could do borders on items in headings and footings. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Gold member |
Had a remote support session with IBI late yesterday afternoon and we could only wrap the outer borders (far-left and far-right) with vertical lines. It didn't appear that you could insert vertical lines within. It's like WF treats it like one big (merged) cell. Does anyone have anything else to suggest/try? 8.0.02M, Oracle 11.2 (AIX), Windows 2008R2, HTML, PDF, Excel | |||
|
| Expert |
Whats the format of the report, EXL2K ? Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Expert |
In a very simple example: Hold your data as HTMTABLE or HTML, then open in EXCEL: TABLE FILE CAR PRINT COUNTRY CAR MODEL BODYTYPE WHERE RECORDLIMIT EQ 10 ON TABLE SET PAGE-NUM OFF ON TABLE HOLD AS EXL1 FORMAT HTMTABLE ON TABLE SET STYLE * TYPE=REPORT, BORDER=1,$ ENDSTYLE END -RUN SET HTMLFORMTYPE = XLS -HTMLFORM BEGIN !IBI.FIL.EXL1; -HTMLFORM END -EXIT Tom Flynn WebFOCUS 8.1.05 - PROD/QA DB2 - AS400 - Mainframe | |||
|
| Gold member |
The format was HTML - but had to also export in PDF and EXL2K. 8.0.02M, Oracle 11.2 (AIX), Windows 2008R2, HTML, PDF, Excel | |||
|
| Expert |
You may well have to code each format separately to do this. HTML should be the easiest. PDF Possibly use OBJECT=BOX to draw the lines EXL2K As tom suggests or there are other options to control the SUBFOOT. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Gold member |
We can't seem to get it to work in HTML. we do have some code that is output specific like: IF &WFFMT EQ 'HTML' THEN .... 8.0.02M, Oracle 11.2 (AIX), Windows 2008R2, HTML, PDF, Excel | |||
|
| Expert |
Can you post the code ? Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Gold member |
I ran Tom's code and I don't see how this is demonstrating how to insert Vertical Border Lines when using Spot Markers? I also changed Tom's code to use: SET HTMLFORMTYPE = HTM Confused... 8.0.02M, Oracle 11.2 (AIX), Windows 2008R2, HTML, PDF, Excel | |||
|
| Gold member |
Hi Waz, Here is my SUBFOOT styling: $
TYPE=SUBFOOT,STYLE=BOLD,BACKCOLOR=RGB(225 225 225),COLOR='BLACK',$
TYPE=SUBFOOT,SIZE=8,
BACKCOLOR=RGB(225 225 225),
COLOR=BLACK,
FONT='ARIAL',
HEADALIGN=BODY,
$
TYPE=SUBFOOT,
LINE=1,
OBJECT=TEXT,
ITEM=1,
COLSPAN=1,STYLE=BOLD,
JUSTIFY=LEFT,COLOR='RED',
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
$
TYPE=SUBFOOT,
LINE=1,
OBJECT=FIELD,
ITEM=1,
COLSPAN=1,
JUSTIFY=RIGHT,
$
TYPE=SUBFOOT,
LINE=1,
OBJECT=FIELD,
ITEM=2,
COLSPAN=1,
JUSTIFY=RIGHT,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
$
TYPE=SUBFOOT,
LINE=1,
OBJECT=FIELD,
ITEM=3,
COLSPAN=1,
JUSTIFY=RIGHT, 8.0.02M, Oracle 11.2 (AIX), Windows 2008R2, HTML, PDF, Excel | |||
|
| Expert |
I expanded on Toms code. TABLE FILE CAR
PRINT
CAR
MODEL
BODYTYPE
BY COUNTRY
ON COUNTRY SUBFOOT
" Country <+0> Car<+0> Model <+0> BodyType "
WHERE RECORDLIMIT EQ 10
ON TABLE SET PAGE-NUM OFF
ON TABLE HOLD AS EXL1 FORMAT HTMTABLE
ON TABLE SET STYLE *
TYPE=REPORT, BORDER=OFF,GRID=OFF,$
TYPE=SUBFOOT, HEADALIGN=BODY, $
TYPE=SUBFOOT, ITEM=1, CLASS=BdrLeft, $
TYPE=SUBFOOT, ITEM=2, CLASS=BdrLeft, $
TYPE=SUBFOOT, ITEM=3, CLASS=BdrLeft, $
TYPE=SUBFOOT, ITEM=4, CLASS=BdrBoth, $
ENDSTYLE
END
-RUN
SET HTMLFORMTYPE = XLS
-*SET HTMLFORMTYPE = HTM
-HTMLFORM BEGIN
<html>
<style>
.BdrLeft {
border-left: 1 solid blue;
}
.BdrBoth {
border-left: 1 solid blue;
border-right: 1 solid blue;
}
</style>
<body>
!IBI.FIL.EXL1;
</body>
</html>
-HTMLFORM END
Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Gold member |
Thanks Waz. I was also curious on how to see this rendered in PDF if possible? 8.0.02M, Oracle 11.2 (AIX), Windows 2008R2, HTML, PDF, Excel | |||
|
| Expert |
PDF has to be done a different way. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Expert |
This seems to work. Not sure if it will line up with the grid lines in the data TABLE FILE CAR PRINT CAR MODEL BODYTYPE BY COUNTRY ON COUNTRY SUBFOOT "Country <+0>Car<+0>Model <+0>BodyType " WHERE RECORDLIMIT EQ 10 ON TABLE SET PAGE-NUM OFF ON TABLE PCHOLD AS EXL1 FORMAT PDF ON TABLE SET STYLE * TYPE=REPORT, BORDER=OFF,GRID=OFF,$ -*TYPE=SUBFOOT, HEADALIGN=BODY, $ TYPE=SUBFOOT, ITEM=1, POSITION=P1,BORDER-LEFT=MEDIUM, $ TYPE=SUBFOOT, ITEM=2, POSITION=P2, BORDER-LEFT=MEDIUM, $ TYPE=SUBFOOT, ITEM=3, POSITION=P3, BORDER-LEFT=MEDIUM, $ TYPE=SUBFOOT, ITEM=4, POSITION=P4, BORDER-LEFT=MEDIUM,BORDER-RIGHT=MEDIUM, $ ENDSTYLE END Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Gold member |
Thank you!  8.0.02M, Oracle 11.2 (AIX), Windows 2008R2, HTML, PDF, Excel | |||
|
| Virtuoso |
In a (pseudo) SUBFOOT: -SET &ECHO=ALL; SET MSG=ON, HOLDLIST=PRINTONLY DEFINE FILE CAR SCOUNTRY/A10='Country'; SCAR/A16='Car'; SBODY/A12='Bodytype'; END TABLE FILE CAR PRINT CAR BODYTYPE COUNTRY NOPRINT COMPUTE V1/I3=IF LAST COUNTRY EQ ' ' THEN 1 ELSE IF COUNTRY EQ LAST COUNTRY THEN LAST V1 ELSE 2 + LAST V1; BY COUNTRY ON TABLE HOLD AS HHH FORMAT ALPHA END FILEDEF HHH DISK HHH.FTM (APPEND TABLE FILE CAR PRINT SCAR SBODY COUNTRY NOPRINT COMPUTE V1/I3=IF LAST COUNTRY EQ ' ' THEN 2 ELSE IF COUNTRY EQ LAST COUNTRY THEN LAST V1 ELSE 2+LAST V1; BY COUNTRY NOPRINT BY SCOUNTRY ON TABLE SAVE AS HHH END TABLE FILE HHH PRINT CAR BODYTYPE BY V1 NOPRINT BY COUNTRY ON TABLE SET PAGE-NUM OFF ON TABLE SET HTMLCSS ON ON TABLE PCHOLD FORMAT HTML ON TABLE SET STYLE * TYPE=REPORT, BORDER=LIGHT,GRID=OFF,$ ENDSTYLE END Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF | |||
|
| 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] Insert vertical lines when using SPOT Markers?
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Insert vertical lines when using SPOT Markers?Copyright © 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 |