I hit the totals icon the GUI and sure enough it turned on grand totals for all my numeric fields.

However there are a couple we do NOT want grand totals for.

I double clicked the grand total line, went to options then the general tab. I checked off the columns I wanted totals for. All totals disappeared. Some sort of bug in 8008 perhaps?

Any ideas. I do have a text field reported between a few of the totals...not sure why this would matter.

This message has been edited. Last edited by: FP Mod Chuck,

Robert

This code worked in 8.0.09.. Try it in your environment.


TABLE FILE CAR
SUM
CAR.BODY.DEALER_COST
CAR.BODY.RETAIL_COST
CAR.BODY.SALES
BY CAR.ORIGIN.COUNTRY
BY CAR.COMP.CAR
BY CAR.CARREC.MODEL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE COLUMN-TOTAL AS 'TOTAL' 'CAR.BODY.RETAIL_COST'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
ENDSTYLE
END


quote:

ON TABLE COLUMN-TOTAL AS 'TOTAL' 'CAR.BODY.RETAIL_COST'

well it worked for the first one. So I have 2 literal columns: Provider and Dept, then a numeric I want total (FTE) then two numerics I do NOT want to total( Benchmark1 and Benchmark2) then a column I want to total (Budget).

I added this:
PRINT TABLE.SEG01.FTE
PRINT TABLE.SEG01.BENCHMARK1
PRINT TABLE.SEG01.BENCHMARK2
PRINT TABLE.SEG01.BUDG
BY TABLE.SEG01.PROVIDER
BY TABLE.SEG01.DEPT
ON TABLE SET BYDISPLAY ON
ON TABLE COLUMN-TOTAL AS 'TOTAL' 'TABLE.SEG01.FTE'
ON TABLE COLUMN-TOTAL AS 'TOTAL' 'TABLE.SEG01.BUDG'

It totals for FTE but nothing for the BUDG.

Put both fields on the same COLUMN-TOTAL line, like this:

TABLE FILE CAR
SUM
CAR.BODY.DEALER_COST
CAR.BODY.RETAIL_COST
CAR.BODY.SALES
BY CAR.ORIGIN.COUNTRY
BY CAR.COMP.CAR
BY CAR.CARREC.MODEL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE COLUMN-TOTAL AS 'TOTAL' 'CAR.BODY.DEALER_COST' 'CAR.BODY.RETAIL_COST' 
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,$
ENDSTYLE
END

To get this:

COUNTRY CAR MODEL           DEALER_COST RETAIL_COST SALES 
ENGLAND JAGUAR V12XKE AUTO        7,427     8,878       0 
. . . . . . . . . . . . . . . . . . . . . . . . . . . . .
TOTAL                           143,794   173,204

You can abbreviate that line as follows:

ON TABLE COLUMN-TOTAL AS 'TOTAL' DEALER_COST RETAIL_COST

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

That did not work. Only the FIRST on prints. Is there a way to white font just the undesired column Total values...otherwise I think I am toast.

I think I got around this by grouping on all my literals and the few numbers that were not additive, then using the gui to turn on totals. I have to validate but I think I fooled it....