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, all
I 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.
Thanks
Mario |
|
|
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 MVP
http://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.
Thanks
mario |
|
|
|
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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
|
|
|
|
|
|
|
SSRS 2008, can I to totals for groups at the end