Focal Point
[SOLVED] How to Suppress Repeating Page Heading in a WF HTML Report?

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/885101705

August 12, 2010, 11:32 AM
motto
[SOLVED] How to Suppress Repeating Page Heading in a WF HTML Report?
I think there is a parameter that can be 'SET' with the ON TABLE SET STYLE *?

ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=9,
$


However, I do not know where or what the SYNTAX is?

Requirement is to print only Column Headings Once on first line of HTML OUTPUT. Then display/print only detail lines.

Can some one tell, me how to accomplish this for a WF HTML Report?

Thanks

Mike

This message has been edited. Last edited by: Kerry,


WebFocus Developer 7.6.10
August 12, 2010, 11:36 AM
Darin Lee
SET LINES=99999

In a nutshell, tells Wf that a single page is 99999 records long, so you only get column titles once


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
August 12, 2010, 12:02 PM
motto
quote:
SET LINES=99999


Thanks Darin. Appreciate it much.


WebFocus Developer 7.6.10
August 12, 2010, 12:07 PM
Norb Eckert
Just as a heads up:

I use SET LINES in every fex but when I've used SET LINES = XXXXX and SET PRINTPLUS = ON at the same time I have had inexplicable errors. Removing the SET PRINTPLUS = ON command solved the issues. I don't know if it's because I was doing HTML output and PRINTPLUS is geared towards PDF or what.

Just wanted to put that out there.

Later,

Norb


prod:7.6.9, win2k3 mre, caster, bid, devstudio 7.6.9
August 12, 2010, 01:17 PM
Francis Mariani
There was a discussion in FocalPoint about SET LINES=999999 sometimes not working as exepected. The solution was to use some other number, e.g. 99999. Unfortunately, neither the FP or Google search found this thread - perhaps I was dreaming it all...


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
August 13, 2010, 05:06 AM
Gobinath Velusamy
Hi
If LINES = 999999 is not working . Try this property , it is working fine .

TYPE=REPORT,
HFREEZE=TOP,


Still if you face any issue ... Please let me know

Thanks
Gobinath Velusamy


WebFOCUS 7610
Windows