Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

SSRS 2008 Repeat Group on Header and Footer

Posted on 2011-09-28
4
762 Views
Last Modified: 2012-05-12
In this report I have a group that prnts a subtotal in the header. I simply want this subtotal to repeat in the footer. In SSRS 2005 the setting was right htere but I cannot find the setting in SSRS2008. Please let me know how in SSRS 2008 where the settng is so I can havve this subtotal appear in both the header and footer.
Group.jpg
0
Comment
Question by:rwheeler23
  • 2
  • 2
4 Comments
 
LVL 9

Accepted Solution

by:
edlunad earned 500 total points
ID: 36720380
You need to first add a footer to your report, then you can just can copy/paste your subtotal expression.

To do this you need to right click outside the report area and select "Add Page Footer".
0
 

Author Comment

by:rwheeler23
ID: 36720526
But I need the footer to be associated with the group. The group is on a field called Location and I want the header and footer for each location. I will try clicking out side the report area and see if it give me an option to add the footer to the group. I am still trying to get used to the look and feel of 2008.
0
 
LVL 9

Expert Comment

by:edlunad
ID: 36720638
The association with the group is going to take place in the scope of your subtotal expression, not exactly in the Footer.
0
 

Author Comment

by:rwheeler23
ID: 36748616
I started a new version from scratch and this time I did not use the wizard and choose not to use an exploding subtotal. This secnd verison works. Thanks for the tips.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to use Variables  and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS. Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question