totals on top of matrix

[doggiegirl]

I am new to sql server report service 2005. I need to be able to put totals
at the top of categories instead of at the bottom of categories. i have tried
lots of options but nothing has worked so far. I need to be able to have a
report look like the following:



total
group1 100
type1 50
type2 25
type3 25

Basically the total of 100 needs to be at the top of the report instead as
a total at the bottom.
I have been trying to use both the matrix and tables from the toolbar, but
I have not succeeded yet. Thus I am wondering if you have any suggestions.

 

[Jordancdc]

See here for info on adding a subtotal. One of the options on the list is Before/After. Choose Before and it will go on top. If you are using SSRS 2005 its different. But I beleive this is the method for 2008.

http://msdn.microsoft.com/en-us/library/ms157334(SQL.90).aspx