Monday, March 12, 2012

Matrix Fields for Subtotal

I had a matrix which retrieves value from a database.When i put "Fields!availability.Value" in the detail cell,it shows warning about aggregate.And i am using 'subtotal'.But my problem is when i use "Sum(Fields!availability.Value)",the value itself that was displayed is different from the actual value in the database.And when i use "First!availability.Value",the subtotal only get the first value from the above rows to which to get the subtotal.Uhm can there be anyway to solve this? Thanks in advance.

Hello,

Can you please explain what you mean by 'the value itself that was displayed is different from the actual value in the database'? Do you mean that the total shown does not equal the sum of the availability values shown in the matrix report? Can you provide an example?

Did you build your matrix using the wizard or directly? Have you tried the wizard? Play around with it for a little bit to get an understanding of the way SSRS matrix reports work.

Larry Smithmier

-

http://Smithmier.com/Blog

|||

I am using a manually created matrix.I had said that because the value is really different from what is retrieved from the database.Instead of 0.1, the value then becomes 0.9.And same as for the other value which also change.The total is equal to the sum of the availabilty, its fine,as long as the value is correct,which for me is not.What could have possibly be the reason why the values do change?

|||Ow..this issue was closed...hehe it was my fault,because it was in my subreport but when i run it actually on my main report it just works fine..It was caused by my parameters,wrong values were being passed..hehe..Thanks

No comments:

Post a Comment