[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 791
  • Last Modified:

SSRS 2008 Repeat Group on Header and Footer

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
rwheeler23
Asked:
rwheeler23
  • 2
  • 2
1 Solution
 
edlunadCommented:
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
 
rwheeler23Author Commented:
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
 
edlunadCommented:
The association with the group is going to take place in the scope of your subtotal expression, not exactly in the Footer.
0
 
rwheeler23Author Commented:
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now