Focal Point
Dynamic spacing of data rows

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

November 30, 2005, 03:30 AM
Dharma
Dynamic spacing of data rows
I have a requirement where the table display area size is fixed. The rows to be displayed in this table have to evenly spaced. How can I dynamically space the lines in the table. Please help.


dharma
------------------
WF v 7.1.1
OS - Win XP
Output: PDF, EXL2K
December 01, 2005, 12:49 PM
<JG>
The first question that has got to be asked is what format do you want for the output.
The second question is what release of WebFocus are you on.

JG
December 01, 2005, 04:39 PM
reFOCUSing
Don't know if this is way you are trying to do:


TABLE FILE CAR
SUM
RETAIL_COST
COMPUTE LINES/D1 = IF LAST COUNTRY EQ COUNTRY THEN LINES + 1 ELSE 1;
BY HIGHEST
COUNTRY
BY HIGHEST
CAR
ON TABLE HOLD AS H0 FORMAT ALPHA
END
-RUN

TABLE FILE H0
PRINT
RETAIL_COST
COMPUTE SPACES/A1 = IF LAST COUNTRY NE COUNTRY THEN FTOA(LINES,'(D1)',SPACES) ELSE LAST SPACES; NOPRINT
BY
COUNTRY
BY
CAR
ON COUNTRY SUBFOOT
" "
WHEN SPACES EQ '2';

ON COUNTRY SUBFOOT
" "
" "
WHEN SPACES EQ '1';
ON TABLE PCHOLD FORMAT PDF
END
-RUN

This message has been edited. Last edited by: <Mabel>,
December 01, 2005, 06:38 PM
susannah
-* dynamc rows
-SET &MYHEIGHT = 100 ;
TABLE FILE CAR PRINT *
ON TABLE HOLD AS MYTAB FORMAT HTMTABLE
ON TABLE SET STYLE *
TYPE=REPORT,FONT='Arial',SIZE=8,$
TYPE=DATA,COLUMN=CAR,CLASS=CARSS,$
END
-RUN
-HTMLFORM BEGIN
<HTML>
<HEAD>
<STYLE>
TD.CARSS {height: &MYHEIGHT }
</style>
</HEAD>
<BODY>
!IBI.FIL.MYTAB;
</BODY>
</HTML>
-HTMLFORM END





In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID