Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Matrix: subtotal row shows wrong sum

Status
Not open for further replies.

Handlerr

Programmer
Oct 27, 2008
10
DE
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?
 
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
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top