I have been looking into utilizing more FOCUS STYLESHEET formatting commands such as BORDER to jazz up our reports. I found the following quirk and was wondering if there is a way to fix this or is this a bug waiting to be fixed.

Run the following code, once with the OLDWAY formatting and once with the NEWWAY formatting. The NEWWAY formatting adds a blank line after the HEADING text that is not there in the OLDWAY.

Any ideas on how to make these two consistent?

I ran this under WebFOCUS 7.1.

Thanks!


TABLE FILE CAR
HEADING
"THIS IS THE HEADING"
FOOTING
"this is the footing"
SUM RCOST DCOST SALES
BY COUNTRY
BY CAR
BY MODEL
ON TABLE SET PAGE NOLEAD
-GOTO OLDWAY
-*****************************************
-OLDWAY
ON TABLE SET HTMLCSS OFF
ON TABLE SET STYLE *
TYPE=REPORT, GRID=OFF,$
ENDSTYLE
-GOTO ENDWAY
-*****************************************
-NEWWAY
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT, BORDER=OFF,$
ENDSTYLE
-*****************************************
-ENDWAY
END

I don't use HTMLCSS = ON because a lot of unpredictable things happen. If you want to use HTML CSS styling, create your own stylesheet and assign classes in the WebFOCUS stylesheet.

Francis,

Thanks for the suggestion. I was experimenting with that route as well. However, in order to get both HTML and PDF formatted the same, this eliminates the possiblity of manually doing the styling with CSS and the "CLASS = " STYLESHEET attribute.

Any other ideas?

Thanks!

Mickey,

I use two different WebFOCUS stylesheets, one for HTML and Excel 2000 and the other for PDF. Unfortunately, like HEADALIGN=BODY or POSITION=xx, some styling only works for one, some only works for the other.

This is what I do:

ON TABLE SET STYLE *<br />-GOTO STYLE_&OUTPUT<br /><br />-*-- Include WebFOCUS report styling for HTML and Excel 2000<br />-STYLE_H<br />-STYLE_E<br />-INCLUDE BRSTYLE01<br /><br />-*-- Non standard styling<br />TYPE=SUBHEAD, HEADALIGN=BODY, STYLE=BOLD, $<br />TYPE=SUBHEAD, BY=FISCAL_SEMIYEAR, ITEM=2, COLSPAN=4, JUSTIFY=CENTER, COLOR=RGB(0 32 120), $<br />TYPE=SUBHEAD, BY=FISCAL_SEMIYEAR, ITEM=3, COLSPAN=4, JUSTIFY=CENTER, COLOR=RGB(0 32 120), $<br />-*<br />TYPE=DATA, WRAP=OFF, $<br /><br />-GOTO STYLE_END<br /><br />-*-- Include WebFOCUS report styling for PDF<br />-STYLE_P<br />-INCLUDE BRSTYLE02<br /><br />-*-- Non standard styling<br />TYPE=REPORT, LEFTGAP=0.03, RIGHTGAP=0.05, $<br />TYPE=SUBHEAD, BY=IG_INSR_TP_DS2, JUSTIFY=LEFT, COLOR=RGB(0 32 120), $<br />-*<br />TYPE=SUBHEAD, BY=FISCAL_SEMIYEAR, ITEM=2, POSITION=P4, JUSTIFY=CENTER, COLOR=RGB(0 32 120), $<br />TYPE=SUBHEAD, BY=FISCAL_SEMIYEAR, ITEM=3, POSITION=P8, JUSTIFY=CENTER, COLOR=RGB(0 32 120), $<br />-*<br />TYPE=DATA, COLUMN=CNT_BAL_AMT(*), BORDER-LEFT=0.01, BORDER-LEFT-COLOR=RGB(200 200 200), $<br /><br />-GOTO STYLE_END<br /><br />-STYLE_END<br />ENDSTYLE<br /><br />END<br />-RUN