Surpressing row, column and total sums in a grid

mzmzmz

Hi

I got a query result with 3 fields and about 50000 records.
Now, I want to pivot the data set depending on the values
present in field #1 and field #2. Simple job, I did this before
using the PivotCube component.

Everything is nice, but ON DEFAULT the grid has one additional
column and row (SUMs or AVGs). A right-click on the fields (*)
within the grid opens a local menu allowing to enable or
to disable "sums" as a additional column or row within the grid.
How to setup the grid options showing NO row sums and NO column sums
as a default.

Is there any documentation I missed ?

SanX a lot, MZ


(*) added by: AddFieldTo(...)

-=paul=-

mzmzmz wrote: »

Everything is nice, but ON DEFAULT the grid has one additional
column and row (SUMs or AVGs). A right-click on the fields (*)
within the grid opens a local menu allowing to enable or
to disable "sums" as a additional column or row within the grid.
How to setup the grid options showing NO row sums and NO column sums
as a default.

What you see is a total column which you can turn on/off by a popup menu on dimension. You can also hide totals by the next code:

SomeFieldOfRegion.SliceField.MakeTotal := False;