 |
|||||
|
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 [CLOSED] {sort of} Space Issue in HTML formatting - Extra Unwatned Rows
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CLOSED] {sort of} Space Issue in HTML formatting - Extra Unwatned RowsPage 1 2
Read-Only TopicGo | Search | Notify | Tools |
| [CLOSED] {sort of} Space Issue in HTML formatting - Extra Unwatned Rows | Login/Join |
| Virtuoso |
I think the issue here has to do with the type of output. It is DHTML. If you specify that type of output in your separate procedures, you'll get the same result as with the compound procedure. Having said that, I've been trying to fool around with the styling in order to possibly remove one or more of the blank lines. I managed to get it down to just the one extra blank line between the heading and the column titles. What I had to do to get that is adjust the styling of the individual components a little bit. In my case it is now: ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT DHTML
ON TABLE SET STYLE *
$
TYPE=REPORT,
BORDER=LIGHT,
BORDER-COLOR=RGB(18 72 124),
FONT='ARIAL',
SIZE=8,
$
TYPE=TITLE,
FONT='ARIAL',
SIZE=8,
COLOR='WHITE',
BACKCOLOR=RGB(18 72 124),
STYLE=-UNDERLINE+BOLD,
$
TYPE=HEADING,
BORDER=OFF,
FONT='ARIAL',
SIZE=9,
COLOR=RGB(18 72 124),
STYLE=BOLD,
$
TYPE=REPORT,
COLUMN=N1,
SQUEEZE=1.500000,
$
TYPE=REPORT,
COLUMN=N2,
SQUEEZE=1.500000,
$
ENDSTYLESee if it helps you, if only a little bit perhaps.GamP
| |||||||||
| ||||||||||
| Silver Member |
Gamp - Thank you for the effort... I have had success getting it down to just the one line between heading and table- but I still appreciate the effort and the DHTML idea - which seems to render more consistent results... so that was helpful. In an earlier post, someone gave me the idea of using this code:
-HTMLFORM BEGIN
<STYLE TYPE="text/css">
<!--
.x1 {display:none;}
-->
</STYLE>
-HTMLFORM END
So, now I am trying to find a way to get the Composer Layout page to read this code either from one of the fexes used to build the compound layout page in Composer, or in COmposer itself. So far, I have not been able to get Composer to recognize this in any form - and when it does, it prints it outside the <HTML>header at the top of the final output DTHTML page, which of course means it is ignored by the code that needs to see it. Any idea how I could fool composer into printing this inside the <HTML>header. - I already tried putting only that in a fex and adding that fex as a componet. That does not work. It reads the -HTMLFORM and stops there. I feel like some combination of all of the things that have been suggested will work - but I really want to use composer because I need output in both HTML and PDF - and using composer makes it easier to pass variables from my HTML launch page to the various output fex compound pages. Here is the code I was using. Notice I am using DHTML and your Styles.
-* File Comp_Remove_Space_Include.fex
-HTMLFORM BEGIN
<STYLE TYPE="text/css">
<!--
.x1 {display:none;}
-->
</STYLE>
-HTMLFORM END
-* File comp1.fex
-*-HTMLFORM BEGIN
-*<STYLE TYPE="text/css">
-*<!--
-*.x1 {display:none;}
-*-->
-*</STYLE>
-*-HTMLFORM END
SET PAGE-NUM=NOLEAD
TABLE FILE CAR
SUM
DEALER_COST/D7CM AS 'Dealer Cost'
BY BODYTYPE AS 'Type'
WHERE BODYTYPE EQ 'ROADSTER';
HEADING "Dealer Cost"
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT DHTML
-*ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
$
TYPE=REPORT,
BORDER=LIGHT,
BORDER-COLOR=RGB(18 72 124),
FONT='ARIAL',
SIZE=8,
$
TYPE=TITLE,
FONT='ARIAL',
SIZE=8,
COLOR='WHITE',
BACKCOLOR=RGB(18 72 124),
STYLE=-UNDERLINE+BOLD,
$
TYPE=HEADING,
BORDER=OFF,
FONT='ARIAL',
SIZE=9,
COLOR=RGB(18 72 124),
STYLE=BOLD,
$
TYPE=REPORT,
COLUMN=N1,
SQUEEZE=1.500000,
$
TYPE=REPORT,
COLUMN=N2,
SQUEEZE=1.500000,
$
ENDSTYLE
END
-* File comp2.fex
SET PAGE-NUM=NOLEAD
TABLE FILE CAR
SUM
RETAIL_COST/D7CM AS 'Retail Cost'
BY BODYTYPE AS 'Type'
WHERE BODYTYPE EQ 'ROADSTER';
HEADING "Retail Cost"
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT DHTML
-*ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
$
TYPE=REPORT,
BORDER=LIGHT,
BORDER-COLOR=RGB(18 72 124),
FONT='ARIAL',
SIZE=8,
$
TYPE=TITLE,
FONT='ARIAL',
SIZE=8,
COLOR='WHITE',
BACKCOLOR=RGB(18 72 124),
STYLE=-UNDERLINE+BOLD,
$
TYPE=HEADING,
BORDER=OFF,
FONT='ARIAL',
SIZE=9,
COLOR=RGB(18 72 124),
STYLE=BOLD,
$
TYPE=REPORT,
COLUMN=N1,
SQUEEZE=1.500000,
$
TYPE=REPORT,
COLUMN=N2,
SQUEEZE=1.500000,
$
ENDSTYLE
END
And this is the Composer Layout code: -* File francis_layout_test -* Default Mode: ResourceLayout SET HTMLARCHIVE=ON COMPOUND LAYOUT PCHOLD FORMAT DHTML UNITS=IN, $ SECTION=section1, LAYOUT=ON, METADATA='0.5^0.5^0.5^0.5^4', MERGE=OFF, ORIENTATION=PORTRAIT, PAGESIZE=Letter, SHOW_GLOBALFILTER=OFF, $ PAGELAYOUT=1, NAME='Page layout 1', text='Page layout 1', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $ COMPONENT='report1', TEXT='report1', TOC-LEVEL=2, POSITION=(0.688 0.656), DIMENSION=(3.281 0.807), METADATA='Z-INDEX: 100; LEFT: 0.688in; WIDTH: 3.281in; POSITION: absolute; TOP: 0.656in; HEIGHT: 0.807in', $ COMPONENT='report2', TEXT='report2', TOC-LEVEL=2, POSITION=(0.688 1.531), DIMENSION=(3.281 0.859), METADATA='Z-INDEX: 100; LEFT: 0.688in; WIDTH: 3.281in; POSITION: absolute; TOP: 1.531in; HEIGHT: 0.859in', $ END SET COMPONENT='report1' -*component_type report -INCLUDE comp1.fex SET COMPONENT='report2' -*component_type report -INCLUDE comp2.fex COMPOUND END Damon WF 7.7.02M LINUX PMF 5.3.1 HTML, PDF, EXCEL | |||
|
| Silver Member |
ok. This will be my last post on this until an actual "fix" comes along. I was never able to make any of the potential solutions work and Francis' final answer was "this has never been explained". It is a bug. There is no need for the extra rows to appear unless they are desired and requested somehow in the focus code. I will submit a bug request and report back here when it is fixed. In the meantime, I am able to publish a work around with the help of my sr. developer, Julie! (Thanks, Julie) This will only work in my specific situation - that being, you want to display a title over a group of columns using the OVER command to put them in a vertical column. The reason for doing this is purely layout based. If you don't care about the extra space-wasting row that you did not request between the heading and the table of data, then don't bother. (note: this will still work without the OVER, but the title will appear to the left of the data - not useful in most situations) If however, you are packing several things onto a single Document Composer page and you really need your output to work in both HTML and PDF, then here is a fix: 1. Create a define field = to nothing. DEFINE FILE CAR DEALER_TITLE/A2 = ''; END 2. Call that field with no value, and style the column title text as your title. DEALER_TITLE AS 'Cost Vs. Price' OVER 3. Use the OVER command and make this title field the first column. 4. The title will print even though there is no data, and you will have a nice neat title close to the table instead of a mile away looking like it does not even belong on the same page. 5. The complete example code using the car file is below. Thank you to all who tried. I actually did learn some cool stuff in this process that perhaps I can use in another situation. I would not call this "solved" - by any means - but I would call it "done - until the bug is fixed".
-* File comp1.fex
DEFINE FILE CAR
DEALER_TITLE/A2 = '';
END
SET PAGE-NUM=NOLEAD
TABLE FILE CAR
SUM
DEALER_TITLE AS 'Cost Vs. Price' OVER
DEALER_COST/D9CM AS 'Dealer Cost' OVER
SALES/D9CM AS 'Retail Price'
WHERE BODYTYPE EQ 'ROADSTER';
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
$
TYPE=REPORT,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BORDER-TOP-COLOR=RGB(18 72 124),
BORDER-BOTTOM-COLOR=RGB(18 72 124),
BORDER-LEFT-COLOR=RGB(18 72 124),
BORDER-RIGHT-COLOR=RGB(18 72 124),
FONT='ARIAL',
SIZE=8,
$
TYPE=DATA,
COLUMN=N1,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=OFF,
BORDER-RIGHT=OFF,
$
TYPE=DATA,
COLUMN=N2,
JUSTIFY=RIGHT,
$
TYPE=DATA,
COLUMN=N3,
JUSTIFY=RIGHT,
$
TYPE=TITLE,
FONT='ARIAL',
SIZE=8,
COLOR='WHITE',
BACKCOLOR=RGB(18 72 124),
STYLE=-UNDERLINE+BOLD,
$
TYPE=TITLE,
COLUMN=N1,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=OFF,
BORDER-RIGHT=OFF,
SIZE=9,
COLOR=RGB(18 72 124),
BACKCOLOR='NONE',
$
TYPE=TITLE,
COLUMN=N2,
JUSTIFY=LEFT,
$
TYPE=TITLE,
COLUMN=N3,
JUSTIFY=LEFT,
$
TYPE=REPORT,
COLUMN=N1,
SQUEEZE=1.500000,
$
TYPE=REPORT,
COLUMN=N2,
SQUEEZE=1.500000,
$
TYPE=REPORT,
COLUMN=N3,
SQUEEZE=1.500000,
$
ENDSTYLE
END
Damon WF 7.7.02M LINUX PMF 5.3.1 HTML, PDF, EXCEL | |||
|
| Powered by Social Strata | Page 1 2 |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CLOSED] {sort of} Space Issue in HTML formatting - Extra Unwatned Rows
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CLOSED] {sort of} Space Issue in HTML formatting - Extra Unwatned RowsCopyright © 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 |