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 |
|
rkalyani
Starting Member
30 Posts |
 Posted - 2009-07-17 : 13:47:44
|
| I have a report like thisaaa a 10 b 20bbb a 20 b 30I need to create a grand total at the end of the report a 30 b 50 Is it possible to do this in reporting serviceThank you,kal30 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-17 : 14:13:49
|
| yes its possible. you need to add a new table and inside it add a grouping based on field containing values a,b,.. then give =sum(fields!measurefield.value) as expression in group footer |
 |
|
|
|
|
|
Grand total