Matrix custom subtotals ? How is it possible ? -- sql server reporting services

alberto.gastaldo NO[at]SPAM libero.it
6/13/2007 9:16:49 AM

Hi ALL,
I have a problem and i becoming crazy !
I create a report like this using a Matrix in Reporting Services
Sales
Area 1 250
Customer 1 100
Customer 2 150
Area 2 60
Customer 3 40
Customer 4 20

I need to add a total row witch is the sum of AREA 1 + AREA 2 lke this
IMPORTANT : rows in matrix becomes directly from my query... they are
not grouping.

Sales
Area 1 250
Customer 1 100
Customer 2 150
Area 2 60
Customer 3 40
Customer 4 20
TOTAL 310

How can I express the contition... If I add a total to the matrix my
total is 620 (wrong !...)
Thank you !

Gas1970

EMartinez
6/13/2007 5:56:24 PM

[quoted text, click to view]

Traditionally, in some cases, I obtain my sums/totals in the stored
procedure/query that is sourcing my matrix report. This should be a
good option in your case as well. Also, depending on the complexity of
the matrix report, you may need to use a while loop/cursor to
determine the sum/totals. Hope this helps.

Regards,

Enrique Martinez
Sr. Software Consultant

sql server reporting services : Matrix custom subtotals ? How is it possible ?