Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jasminegirl
Starting Member
7 Posts |
 Posted - 2010-02-02 : 09:08:59
|
| 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. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-02 : 09:37:05
|
| you can put expression for totals on top by adding a detail row and applying dummy group by |
 |
|
|
|
|
|
totals on top or matrix