trying to detect Total and subTotal Cells

[dophin]

Hello, Alex

Is there any possibility to "detect" total (Row, Column) and subtotal cells.

I've put this in a getRowTotal event handler

showMessage( 'GetRowTotal' ) ;

and the message does not show up.

Am i missing something once more ?

Thank you and best regards,

Joseph Osende

[AlexZencovich]

Yes. OnGetRowTotal fired for fixed totals only because they painting in different way than usual.
You should use OnGetCellValue event and check RowIndex parameter.
If it is same as PivotMap.TopRows.Index then you have row total.
If you have PivotMap.RowCells[RowIndex].ChildCount > 0 - then you get subtotal

[dophin]

Thank you, Alex.

Really fantastic service !!!

Joseph Osende

[dophin]

Hello, Alex

Do you use the same kind of logic
regarding colum total cells ?

[dophin]

hello, Alex

I've tried the following :

if ( measureIndex = 4 ) then
if (( cell <> Nil )) then
begin
if ( rowIndex = pivotMap1.TopRows.Index ) then
cellString := ' '
else
if ( columnIndex = pivotMap1.TopColumns.Index ) then
cellString := ' '
end

but my rowTotals and ColumnTotals are still displayed

Coud you please help me ?

TIA

Joseph osende

[AlexZencovich]

change
cellString := ' ' (empty string)
to
cellString := ' ' (space string)

Empty string treatened as if event does not provide own string value so it format original value

[dophin]

Thank you very much

Joseph Osende