Focal Point Banner


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
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

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  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] How to let title display once

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] How to let title display once
 Login/Join
 
hainguyen
Platinum Member
posted
My issue is when I export my report in HTML format, if the number of records is too big, it will break my reports and display title many times. How can I let the title display just only one time?
Thanks

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


WebFOCUS 7.7.03
Windows, All Outputs
 
Posts: 125 | Registered: June 17, 2013Report This Post
Prarie
Virtuoso
posted Hide Post
Title? Column Title or Heading?

How big? This sounds odd.
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
hainguyen
Platinum Member
posted Hide Post
It is the column title.
Ex:
 
LOT     CAR      GRADE      STATUS
XXX     XXX      XXX        XXX
.
.
.
LOT     CAR      GRADE      STATUS
XXX     XXX      XXX        XXX
.
.
.
LOT     CAR      GRADE      STATUS
XXX     XXX      XXX        XXX
.
.
.

The report is broken 3 times and have the column title on the top of each time. How can I display the column title just 1 time on the top of the whole report.


WebFOCUS 7.7.03
Windows, All Outputs
 
Posts: 125 | Registered: June 17, 2013Report This Post
Tom Flynn
Expert
posted Hide Post
As the manual states:
SET LINES = 999999


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Waz
Expert
posted Hide Post
What do you mean by Export ?

Is the report in another format or a parent report ?

Is it an option on the report to produce an HTML report ?

Toms Suggestion is the best.

Tom, is it 999999 or 99999 ? or am i remembering the good old days.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Tom Flynn
Expert
posted Hide Post
Hey Waz! Happy New Year to you! Summer looks HOT down there...

Actually, it was SET LINES = 998 in the good ol' days...

Its's one of the above!!!


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
hainguyen
Platinum Member
posted Hide Post
Tom: SET LINES = 999999 didn't work in my case.
Waz: I meant the report in HTML format.
Prarie: The report has 300 records and it seems broken for every 100 records.
Do you have any other suggestions ?


WebFOCUS 7.7.03
Windows, All Outputs
 
Posts: 125 | Registered: June 17, 2013Report This Post
Waz
Expert
posted Hide Post
Sweating

Looking forward to the pool......


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Tom Flynn
Expert
posted Hide Post
Waz, I bet you are!
SET LINES = 998

Probably have SET LINES = XXX somewhere else?


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Waz
Expert
posted Hide Post
Just set your LINES to a large number.

Also check your code output to see if there is LINES is being reset elseware


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
hainguyen
Platinum Member
posted Hide Post
My bad, it works with SET LINES = 998 or SET LINES = 9999999 or whatever. Because I put semicolon after SET LINES = 998 before, it didn't work . Now it is good. Thanks all and stay warm. Wink


WebFOCUS 7.7.03
Windows, All Outputs
 
Posts: 125 | Registered: June 17, 2013Report This Post
Tom Flynn
Expert
posted Hide Post
Open a manual...


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Tony A
Expert
posted Hide Post
In case anyone gets to this post after a search and just for the sake of clarity, the correct syntax is -
SET LINES = 999999
... or ...
ON TABLE SET LINES 999999

T


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] How to let title display once

Copyright © 1996-2020 Information Builders