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,

Is your output Excel? If so...I believe you can do it with Templates.

Hi

My output is HTML output ...

In Active Reports you can freeze columns...

What exactly are you trying to do?

Hi

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

Where are javascript routines out there that will do this, but I think they will only work with IE.

When you say first three rows, is that the data or headings?

The first 3 rows of the Data only

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.

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.

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,