We have FOCUS 7.1.1 at our site. I know that we can create HTML files using FOCUS 7.1.1 and then ftp them to some unix box so that it can be displayed on any portal. But the HTML file that we can create by using command "ON TABLE SAVE AS <FILENAME> FORMAT HTML" is too crude in looks. Is there a way we can set any font or color to this HTML?

Once again FOCUS version is 7.1.1

Thanks.

You use WebFOCUS stylesheets to style your reports. Check the manual, I'm sure styling is available for Mainframe FOCUS 7.1.1

Stylesheets are available to you, but your font options are pretty limited in 7.1.1. I'd suggest you work with things like font size (stick with 8, 10, and 12) and colors (BLACK, WHITE, GREEN, RED, BLUE, MAROON, OLIVE, PURPLE, NAVY, YELLOW, TEAL, GRAY, SILVER, LIME, FUCHSIA, AQUA). Here is a code snippet that I copy in to a TABLE request when I want to create a HTML file:
HEADING
"REPORT HEADING GOES HERE"
FOOTING
"CREATED BY ME "
"FOCEXEC NAME"
ON TABLE SET LINES 999999
ON TABLE SET PAGE NOPAGE
ON TABLE HOLD AS FRED FORMAT HTML
ON TABLE SET STYLE *
TYPE = REPORT, GRID = ON,$
TYPE = HEADING, STYLE=BOLD, HEADALIGN=INTERNAL,$
TYPE = HEADING, LINE=1, COLSPAN=6,$
TYPE = TITLE, SIZE=10, STYLE=BOLD,$
TYPE = FOOTING, SIZE=8, COLOR=GREEN, HEADALIGN=INTERNAL,$
TYPE = FOOTING, LINE=1, OBJECT=TEXT, COLSPAN=6,$
TYPE = FOOTING, LINE=2, OBJECT=TEXT, COLSPAN=6,$
ENDSTYLE
END

Gotchas:
Spot markers!-- FOCUS formats your report as a HTML table. The position on the "line" is a cell, not a character count.
Page Breaks-- see the SET LINES and SET PAGE lines above; they eliminate page breaks
Non-printing sort fields-- you may want to put your BY fields on the PRINT/SUM line and NOPRINT them on the BY lines.

Tips:
COLOR = the data, BACKCOLOR = the cell.
Understand the Stylesheet hierarchy (if you can!).

Final Thoughts:
This is the basic format I use when I create a HTML file that will be viewed with Excel. It may not look as good in a browser.
If you have a SMTP server running on your mainframe, you can have FOCUS email the HTML file as an attachment. I just put a .xls extension on the attachment name and Excel does the rest.

Hi Jeff,
Thanks a bunch for your guidance. I was able to do a lot with the piece of code you gave. Got a few questions -
1) Can we specify the background color for the HTML page?
2) What are the different fonts available in 7.1.1?

Thanks again,
Gaurav

Hi,

This is from the FOCUS for S/390 Creating Reports 7.1 manual (DN1001056.1100):

COURIER is the default. Other fonts available in the font metrics files supplied with FOCUS are HELVETICA, Avant Garde Gothic, BOOKMAN, HELVETICA NARROW, NEW CENTURY SCHOOLBOOK, PALATINO, and TIMES.

I hope this helps.

Regards,
Jennifer

Hi,
Thanks for the font list...I was able to figure out how to give background color

TYPE = REPORT, BACKCOLOR=BLUE,$

This paints the background.

Hi,
I got one more question.
Can we color the GRID and define its line styles etc? I tried using BORDER command in FOCUS 7.1.1 but it doesnt seem to be working for me.

Thanks
Gaurav.

Hi Gaurav,

Coloring the GRID and defining its line styles was not supported in FOCUS 7.1.1.

It may have been supported in 7.2 and was
definitely in 7.3. Those two versions of FOCUS are on the same programming track as WebFOCUS.

Regards,
Jennifer

Thanks Jennifer.