How to order by a total in a matrix

[InSanity]

Hi im using visual studio 2005 reporting sevices to generate a matrix, but i want to order it by the subtotal. Is this possible its easy enough to do in tables but dont know how in matrix.

Any help thanks

 

[InSanity]

Ok...

All of you seem to be as confused as i am, but i found out the answer.

Here it is :
"Hi,



Reporting Services allows users to make the records sort on the subtotal in the matrix. This can be done with the instructions below.

Open "Matrix Properties" dialog box, switch to "Groups" tab.
Select rows group item and click "Edit".
In "Grouping and Sorting Properties" dialog box, go to "Sorting" tab and add the expression "=Sum(Fields!SubtotalField_name.Value,"RowGroup_name")".
If there are any more questions, please let me know.

Thanks."

Thanks

 

[Brawler]

phew.. im so glad I don't do that ***** anymore..

 

[LazyLion]

*** there is no spoon ***

 

[InSanity]

no ways this ****** is awsum im loving it

 

[Brawler]

thats great