Faisal62


hi,

i am using SQL server reporting services 2000. in that i am using a matrix and one column group and a one row group. i want to calculate total of row and column group and i insert a subtotal at for row and column group.

butits calculation wrong total just picking first row and first column in total.

Application ABC DEF 123 456 Total
stat 17 15 3 6 17
Config 15 0 12 0 15
CSP - IMS 11 10 0 0 11
Portalm 10 8 8 0 10
Total 17 15 3 6 17

can anyone help me in this regards.

Regards,

Faisal Saleem





Re: Subtotal problem

GregSQL


Are you using the automatic subtotal functionality If not, then it seems as though the Total row's expression is set to

First(Fields!myField.Value).







Re: Subtotal problem

Faisal62

yeh i am using automatic subtotal functionality.







Re: Subtotal problem

GregSQL

Faisal62 wrote:

yeh i am using automatic subtotal functionality.

I'm not sure why it's doing that to you, but my advice is to build the Total row directly into your SQL statement so you don't have to rely on a microsoft function of which the code cannot be edited.

In my experience, that autosum feature has been highly limited.






Re: Subtotal problem

Faisal62

hi,

thanks for ur help. i got the solution what that i was doing wrong i was not using sum function thats y it was calculating wrong total now its forking pretty good.

Application Fields!reason.Value Total
Fields!application.Value Sum(Fields!value.Value)
Total

Regards,

Faisal Saleem