Focal Point
Deleting space between column title and data

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

April 13, 2007, 02:02 PM
<NAG>
Deleting space between column title and data
Hi
While i using across iam getting space between
Column Title and Data in PDF and HTML.

How can i avoid space between Title and Data
April 13, 2007, 02:11 PM
Leah
quote:
How can i avoid space between Title and Data

I believe that WebFOCUS always assumes one line prior to data. As many have said, can you let us know which environment you are using by adding your signature.

Extra lines in headings could be due to hitting 'new line' in the GUI after the last line which results in an extra line. Is that your issue or is it just the 'standard' line.


Leah
April 15, 2007, 10:03 AM
Danny-SRL
NAG,
It is true that when you use ACROSS there will always be a space between the line of across values and the data. This is because that is where a column heading will appear should you have more than one field in your output.
However, never despair, WF always has a solution:
-DEFAULT &OUTPUT=HTML
SET HOLDLIST=PRINTONLY
TABLE FILE CAR
BY SEATS
ON TABLE SAVE
END
-RUN
-SET &MSEAT=&LINES;
DEFINE FILE CAR
-REPEAT #SEATLOOP FOR &I FROM 1 TO &MSEAT;
-READ SAVE,&SEATNUM
-SET &S.&I=&SEATNUM;
SAL&I / I6 = IF SEATS EQ &S.&I THEN SALES ELSE 0;
-#SEATLOOP
END
TABLE FILE CAR
SUM
-REPEAT #SEATREP FOR &I FROM 1 TO &MSEAT;
-SET &S0=IF &I EQ 1 THEN 'SEATS' ELSE ' ';
SAL&I AS '&S.&I'
-#SEATREP
BY COUNTRY
HEADING
"SEATS<+0 "
ON TABLE SET HTMLCSS ON
ON TABLE PCHOLD FORMAT &OUTPUT
-SET &HEAD=IF &OUTPUT EQ PDF THEN 'POSITION=SAL1, JUSTIFY=RIGHT'
-                            ELSE 'COLSPAN=2, JUSTIFY=RIGHT ';
ON TABLE SET STYLE *
TYPE=REPORT, GRID=OFF, $
TYPE=REPORT, HEADALIGN=BODY, $
TYPE=HEADING, LINE=1, ITEM=1, &HEAD, $
ENDSTYLE
END

Change the parameter &OUTPUT from HTML to PDF to see the different formats.


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

April 15, 2007, 05:00 PM
Furrygrady
Similiar results if you just use an AS '' on your by field.

You lose the column title which is causing the space but more than likely your user will be able to determine the sort field by the data or title of the report.
August 17, 2007, 01:02 PM
SG
NAG,

Try this right before the Table file

SET ACROSSLINE=SKIP


Webfocus 7.6.8
PDF,HTML & EXCEL