how to remove extra space between heading and column titles.I want a report with borders.

below sample car file.For column1,column2 the heading should be HEADING1 and for column3,column4 heading should be HEADING2.
can anyone help on this .

 DEFINE FILE CAR
SH1/A10='HEADING1';
SH2/A10='HEADING2';
END
TABLE FILE CAR
PRINT
SEATS
SALES
SEATS
SALES
HEADING
"<SH1<+0><SH2"
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
   UNITS=IN,
   SQUEEZE=ON,

TYPE=REPORT,
FONT='ARIAL',
SIZE=8,
COLOR='BLACK',
BACKCOLOR='NONE',
GRID=OFF,
BORDER=LIGHT,
$

TYPE=TITLE,
FONT='ARIAL',
SIZE=8,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
COLOR=BLACK,
JUSTIFY=CENTER,
$

TYPE=DATA,
FONT='ARIAL',
SIZE=8,
BACKCOLOR=( 'WHITE' RGB(240 240 240) ),
COLOR=BLACK,
JUSTIFY=RIGHT,
$
ENDSTYLE
END


 

Thanks in advance

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

Try to use SUBHEAD.

Lining up the Headings to be over the columns requested, the following would need to be added you your stylesheet:

  
TYPE=HEADING, HEADALIGN=BODY,$
TYPE=HEADING,
     ITEM=1,
     COLSPAN=2,
     JUSTIFY=CENTER,
$
TYPE=HEADING,
     ITEM=2,
     COLSPAN=2,
     JUSTIFY=CENTER,
$

Not sure much can be done to remove the extra space between the heading and the data without removing the border statement for release 7.1.4.

quote:

remove the extra space between the heading and the data without removing the border

This is an ongoing problem and hasn't yet been solved in v7.7.03.

i tried this by using css code in a define field and call the field in the report heading.Iam getting the left and right gaps for column title and the report title.can someone please help.

 
DEFINE FILE CAR
-*-*SH1/A10='HEADING1';
-*-*SH2/A10='HEADING2';
DUMMY/A1=' ';
TITLE/A300='<TABLE><TR><TD STYLE=''BORDER:1PX SOLID BLACK;''>SEAT</TD><TD STYLE=''BORDER:1PX SOLID BLACK;''>SALES</TD><TD STYLE=''BORDER:1PX SOLID BLACK;''>CAR</TD><TD STYLE=''BORDER:1PX SOLID BLACK;''>SEAT</TD><TD STYLE=''BORDER:1PX SOLID BLACK;''>SALES</TD><TD STYLE=''BORDER:1PX SOLID BLACK;''>CAR</TD></TR></TABLE>';
END
TABLE FILE CAR
PRINT
SEATS AS ''
SALES AS ''
CAR AS ''
SEATS AS ''
SALES AS ''
CAR AS ''
BY DUMMY NOPRINT
ON DUMMY SUBHEAD
"<TITLE"
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
   UNITS=IN,
   SQUEEZE=ON,
TYPE=REPORT,FONT='ARIAL',SIZE=8,COLOR='BLACK',BACKCOLOR='NONE',GRID=OFF,$
TYPE=TITLE,FONT='ARIAL',SIZE=8,BACKCOLOR=RGB(153 153 153),STYLE=BOLD,COLOR=BLACK,JUSTIFY=CENTER,$

TYPE=DATA,FONT='ARIAL',SIZE=8,BACKCOLOR=( 'WHITE' RGB(240 240 240) ),COLOR=BLACK,JUSTIFY=CENTER,BORDER=LIGHT,$
TYPE=DATA,COLUMN=P1,WIDTH=0.3,$
TYPE=DATA,COLUMN=P2,WIDTH=0.3,$
TYPE=DATA,COLUMN=P3,WIDTH=0.3,$
TYPE=DATA,COLUMN=P4,WIDTH=0.3,$
TYPE=DATA,COLUMN=P5,WIDTH=0.3,$
TYPE=DATA,COLUMN=P6,WIDTH=0.3,$

TYPE=TITLE,COLUMN=P1,WIDTH=0.3,$
TYPE=TITLE,COLUMN=P2,WIDTH=0.3,$
TYPE=TITLE,COLUMN=P3,WIDTH=0.3,$
TYPE=TITLE,COLUMN=P4,WIDTH=0.3,$
TYPE=TITLE,COLUMN=P5,WIDTH=0.3,$
TYPE=TITLE,COLUMN=P6,WIDTH=0.3,$

TYPE=SUBHEAD, HEADALIGN=INTERNAL,JUSTIFY=CENTER, BORDER=1,$
TYPE=SUBHEAD, ITEM=1, COLSPAN=3, JUSTIFY=CENTER,$
TYPE=SUBHEAD, ITEM=2, COLSPAN=3, JUSTIFY=CENTER,$
ENDSTYLE
END
 

Hi,

The problem with the generated css is, that it uses x1..xn classnames. There is no
way you know which fields get which classname. But if you have a fixed report you could use something like this (the empty row is not completely removed, but the height is much less)
The only thing is that the fex has a hard-coded .x3 in it (afaik this can not be generated dynamically).

-Fred-

DEFINE FILE CAR
SH1/A10='HEADING1';
SH2/A10='HEADING2';
FFF/A100 WITH SEATS = '<style>.x3{line-height:0px;}</style>';
END
TABLE FILE CAR
PRINT
 
SEATS
SALES
SEATS
SALES
HEADING
"<SH1<+0><SH2"
ON TABLE SUBFOOT
"<FFF "
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
   UNITS=IN,
   SQUEEZE=ON,
$

TYPE=TABFOOTING, BORDER=OFF,$

TYPE=REPORT,
FONT='ARIAL',
SIZE=8,
COLOR='BLACK',
BACKCOLOR='NONE',
GRID=OFF,
BORDER=LIGHT,
$

TYPE=TITLE,
FONT='ARIAL',
SIZE=8,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
COLOR=BLACK,
JUSTIFY=CENTER,
$

TYPE=DATA,
FONT='ARIAL',
SIZE=8,
BACKCOLOR=( 'WHITE' RGB(240 240 240) ),
COLOR=BLACK,
JUSTIFY=RIGHT,
$

TYPE=HEADING, HEADALIGN=BODY,$
TYPE=HEADING,
     ITEM=1,
     COLSPAN=2,
     JUSTIFY=CENTER,
$
TYPE=HEADING,
     ITEM=2,
     COLSPAN=2,
     JUSTIFY=CENTER,
$



ENDSTYLE
END