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 |
|
dainova
Starting Member
31 Posts |
 Posted - 2013-07-09 : 02:21:23
|
| Hi, allI have basic report grouped by Site, and after each group I did ADD TOTAL which works fine, but my user wants these totals for all groups be at the end, is it possible ? I don't see how to do this with SSRS, I use titles like "Total for @site " but I can't move them all at the end,Appreciate your help and advice.ThanksMario |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-07-09 : 04:59:13
|
| You can. you need to place table footer and write expression inside it for getting the grand total.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
dainova
Starting Member
31 Posts |
Posted - 2013-07-10 : 05:02:21
|
| Tx, visakh.Is it completey done in VB/VBS? can you point me to any example.+ I need to write totals for each group in the footer.Thanksmario |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-07-10 : 05:08:29
|
| Nope..its done in SSRS using SSRS Expression. You can add a footer for GROUP also to get group totals.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
SSRS 2008, can I to totals for groups at the end