I have created a prototype report with the CAR file using the OVER command.

It is styling nicely but I like to have the BLANK field span two columns rather
than one.

I defined a 2nd field named FILL/5='HELLO'; to populate the extra cell
but I'd rather not go that route unless necessary.

-* File car_over.fex
SET PAGE = NOPAGE

DEFINE FILE CAR
BLANK/A1 = '';
END

TABLE FILE CAR
HEADING
"CAR <+0> DEALER"
"COUNTRY <+0> RETAIL"
" "
"<+0> <+0>COMBINED"
"<+0> <+0>SF85 SF85P "
PRINT
CAR AS ''
DEALER AS ''
OVER COUNTRY AS ''
RETAIL AS ''
OVER BLANK AS ''
-*
WHERE COUNTRY EQ 'ENGLAND';
ON TABLE PCHOLD FORMAT HTML

ON TABLE SET STYLE *
TYPE=REPORT, ORIENTATION=LANDSCAPE, GRID=ON, FONT=ARIAL, SIZE=9, $
TYPE=HEADING, HEADALIGN=BODY, $
TYPE=HEADING, LINE=1, OBJECT=TEXT, ITEM=1, COLSPAN=1, JUSTIFY=CENTER, $
TYPE=HEADING, LINE=1, OBJECT=TEXT, ITEM=2, COLSPAN=1, JUSTIFY=CENTER, $
TYPE=HEADING, LINE=2, OBJECT=TEXT, ITEM=1, COLSPAN=1, JUSTIFY=CENTER, $
TYPE=HEADING, LINE=2, OBJECT=TEXT, ITEM=2, COLSPAN=1, JUSTIFY=CENTER, $
TYPE=HEADING, LINE=3, OBJECT=TEXT, COLSPAN=2, JUSTIFY=CENTER, $
-*
TYPE=HEADING, LINE=4, OBJECT=TEXT, ITEM=1, COLSPAN=1, JUSTIFY=CENTER, $
TYPE=HEADING, LINE=4, OBJECT=TEXT, ITEM=2, COLSPAN=1, JUSTIFY=RIGHT, $
TYPE=HEADING, LINE=5, OBJECT=TEXT, ITEM=1, COLSPAN=1, JUSTIFY=CENTER, $
TYPE=HEADING, LINE=5, OBJECT=TEXT, ITEM=2, COLSPAN=1, JUSTIFY=CENTER, $
-*
TYPE=DATA, JUSTIFY=CENTER, $
TYPE=DATA, COLUMN=N1, COLOR=ORANGE, $
TYPE=DATA, COLUMN=N2, COLOR=GREEN, $
TYPE=DATA, COLUMN=N3, COLOR=BLUE, $
TYPE=DATA, COLUMN=N4, COLOR=PURPLE, $
TYPE=DATA, COLUMN=N5, COLOR=BROWN, $
TYPE=DATA, COLUMN=N6, COLOR=RED, $ 

ENDSTYLE
END
-RUN

Can anyone help me fix this ?

Thanks!

This message has been edited. Last edited by: <Kathryn Henning>,

Quick and dirty HTML solution?

DEFINE FILE CAR
BLANK/A22 = '&|nbsp;</td><td>&|nbsp;';
END

T

Ok, not exactly what you wanted (column span) but you would have to hack into the TD tag attributes for that and that would probably mean using HTMTABLE holds and inclusion of JQuery, reading the DOM and then changing the bit you want.

A lot of effort for not much benefit?

Of course the reason that you cannot use TYPE=DATA, COLUMN=BLANK, COLSPAN=2, $ in the stylesheet is your use of OVER.

T

I can live with it as it is, but as we used to say in college: "This bl**s"