Matrix: subtotal row shows wrong sum

[Handlerr]

hello,

i did create a matrix in a vs2008 asp.net reports website.
a view does fetch the data for the matrix from the sqlserver2000 database in a dataset.

i added a subtotal row, but unfortenately it shows not the total sum of my column contents! it seems that it shows only the numbers of the last row, please see my screenshot added.

what can be wrong here?

 

[xlbo]

How did you set up your subtotal?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Handlerr]

i did just add the subtotal by right-clicking the colum and the row.
in the detail i had the expression Fields!GesamtAnzahlVeranstaltungenPerTruck.Value because my database view for the matrix already counted the wanted data.
i did not know that the matrix detail cell is "coupled" with the definition for the subtotal.

now i have in the detail cell the expression =Sum(Fields!GesamtAnzahlVeranstaltungenPerTruck.Value) and now also the subtotal for the rows and for the columns are correct!

so me issue is solved! thanks anyway.