Hi
I am trying to make subtotal to appear below a certain column. How do we specify that in style?
I have been trying
TYPE=SUBFOOT,
BY=1,
LINE=1,
OBJECT=FIELD,
ITEM=1,
POSITION='N3',
$

But not getting the desired output.

Thanks
Chirag

Chirag

This functionality only works in a PDF format report.
In HTML you need an other approach.

What is your required output format?

The desired output is excel. What approach should i follow?

Chirag

Positioning in HTML can be done with grid, I'm not sure if that works in EXCEL to.
Can you post something more of this report, the whole fex might work, but put it between [ code] and [ /code] tages.
There might be an other solution.

Chirag,

Here is one possibility:

  
-* File chirag2.fex
TABLE FILE CAR
SUM SALES 
BY COUNTRY 
BY CAR 
BY BODYTYPE
ON COUNTRY SUBFOOT
"Total for <COUNTRY <ST.SALES "
" "
ON TABLE SET HTMLCSS ON
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
TYPE=SUBFOOT, HEADALIGN=BODY, $
TYPE=SUBFOOT, ITEM=4, JUSTIFY=RIGHT, $
ENDSTYLE
END

quote:

TYPE=SUBFOOT,
BY=1,
LINE=1,
OBJECT=FIELD,
ITEM=1,
POSITION='N3',
$

Try:
TYPE=SUBFOOT, HEADALIGN=BODY,$
TYPE=SUBFOOT,
BY=1,
LINE=1,
ITEM=1,
COLSPAN=3,
JUSTIFY=RIGHT,
$

The OBJECT=FIELD (or TEXT) is optional, it makes it harder to count your positions. Without it each part of the line is 1 item. In the line

"Country Subtotal <COUNTRY<AMT"

ITEM=1 would be 'Country Subtotal '
ITEM=2 would be COUNTRY (the value of the field)
and ITEM=3 would be AMT.

Be aware that if you type it like this:

"Country Subtotal <COUNTRY <AMT"

in EXCEL AMT becomes item 4. The space following COUNTRY becomes item 3.