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     Freeze the 3 Rows (Solved)

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Freeze the 3 Rows (Solved)
 Login/Join
 
Platinum Member
posted
Hi
My requirement is i have to freeze 3 rows of the Report output .

How can i achive this one with Webfocus ?

Thanks
Gobinath Velusamy

This message has been edited. Last edited by: Gobinath Velusamy,


WebFOCUS 7610
Windows
 
Posts: 121 | Registered: September 25, 2007Report This Post
Virtuoso
posted Hide Post
Is your output Excel? If so...I believe you can do it with Templates.
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Platinum Member
posted Hide Post
Hi

My output is HTML output ...


WebFOCUS 7610
Windows
 
Posts: 121 | Registered: September 25, 2007Report This Post
Virtuoso
posted Hide Post
In Active Reports you can freeze columns...

What exactly are you trying to do?
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Platinum Member
posted Hide Post
Hi

In HTML Report ... i want to freeze the first 3 rows of the record .........


WebFOCUS 7610
Windows
 
Posts: 121 | Registered: September 25, 2007Report This Post
Expert
posted Hide Post
Where are javascript routines out there that will do this, but I think they will only work with IE.


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
Expert
posted Hide Post
When you say first three rows, is that the data or headings?


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
Platinum Member
posted Hide Post
The first 3 rows of the Data only


WebFOCUS 7610
Windows
 
Posts: 121 | Registered: September 25, 2007Report This Post
Master
posted Hide Post
You could use IFRAMES and create 2 reports on the same page. Put your 3 rows of "frozen" data in the top one and the rest of the report in the bottom.


Pat
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes
 
Posts: 755 | Location: TX | Registered: September 25, 2007Report This Post
Expert
posted Hide Post
To follow on what Pat suggested.

As this is HTML.

Just have two reports, the first with the first three rows, the second with the rest.

You should be able to get away with the two in the same window.

-*new file

DEFINE FILE CAR
 CNTR/I9 WITH COUNTRY = LAST CNTR + 1 ;
END
TABLE FILE CAR
 PRINT COUNTRY
 WHERE CNTR LE 3
END
TABLE FILE CAR
 PRINT COUNTRY AS ''
 ON TABLE SET PAGE NOLEAD
 WHERE CNTR GT 3
END


You will have to make sure the width of the columns match though.


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
Virtuoso
posted Hide Post
HFREEZE maybe? No? Well, at least it was fun. The CAR file produces so little data I had to set SCROLLHEIGHT=1 to get the report to scroll.

SET ASNAMES   = ON
SET BYDISPLAY = ON
SET HOLDLIST  = PRINTONLY

TABLE FILE CAR
 SUM SALES
 COMPUTE CNTR/I9 = LAST CNTR + 1 ;
 BY COUNTRY
 BY CAR
 WHERE TOTAL CNTR LE 3 ;
 ON TABLE HOLD AS FIRST3
END

DEFINE FILE FIRST3
 BR/A4 = '<hr>';
END

TABLE FILE FIRST3
SUM BR COUNTRY
ACROSS CNTR NOPRINT
ON TABLE SAVE AS RPTHEAD
END

FILEDEF RPTHEAD DISK RPTHEAD.FTM (APPEND

TABLE FILE FIRST3
SUM BR CAR
ACROSS CNTR NOPRINT
ON TABLE SAVE AS RPTHEAD
END

TABLE FILE FIRST3
SUM BR SALES
ACROSS CNTR NOPRINT
ON TABLE SAVE AS RPTHEAD
END

-RUN
-READ RPTHEAD, &RPTHEAD1
-READ RPTHEAD, &RPTHEAD2
-READ RPTHEAD, &RPTHEAD3

TABLE FILE CAR
 HEADING
  "FREEZE FIRST 3 ROWS OF DATA"
 SUM SALES AS '[b]SALES[/b]&RPTHEAD3'
 COMPUTE CNTR/I9 = LAST CNTR + 1 ; NOPRINT
 BY COUNTRY AS '[b]COUNTRY[/b]&RPTHEAD1'
 BY CAR AS '[b]CAR[/b]&RPTHEAD2'
 WHERE TOTAL CNTR GE 4 ;
 ON TABLE SET HTMLCSS ON
 ON TABLE SET STYLE *
  TYPE=REPORT, HFREEZE=TOP, SCROLLHEIGHT=1, $
  TYPE=HEADING, HEADALIGN=BODY, $
  TYPE=HEADING, LINE=1, COLSPAN=3, JUSTIFY=CENTER, $
  TYPE=TITLE, BACKCOLOR=SILVER, $
 ENDSTYLE
END

This message has been edited. Last edited by: Dan Satchell,


WebFOCUS 7.7.05
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Report 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     Freeze the 3 Rows (Solved)

Copyright © 1996-2020 Information Builders