SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Development Tools
 Reporting Services Development
 SSRS 2008, can I to totals for groups at the end
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

dainova
Starting Member

31 Posts

Posted - 07/09/2013 :  02:21:23  Show Profile  Reply with Quote
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

India
52309 Posts

Posted - 07/09/2013 :  04:59:13  Show Profile  Reply with Quote
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
Go to Top of Page

dainova
Starting Member

31 Posts

Posted - 07/10/2013 :  05:02:21  Show Profile  Reply with Quote
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

Edited by - dainova on 07/10/2013 05:03:11
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 07/10/2013 :  05:08:29  Show Profile  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.07 seconds. Powered By: Snitz Forums 2000