CrossTab - skipping sum of values in GrandTotal

rbuser

Hello!

I have a crosstab where I want to skip some values of dimension values in
Grand Total but keep showing it on screen

A litle example:

Country 2004 2005 2006 GrandTotal

USA 2 4 6 6 (only 2 + 4)
(I don't want to sum 2006 in GrandTotal).



Is this possible ? How can I do this in ReportBuilder 7.03 ?

Thanks a lot.

nardmoseley

There is no way to do that.

Crosstab demos 124 and 125 show how to use the OnGetDimensionValue and
OnCalcDimensionValue events to control what values are used to perform
calculations. However, the subtotals and grand total are always the sum of
all cell values shown in the crosstab cells.



--
Nard Moseley
Digital Metaphors Corporation
http://www.digital-metaphors.com