Solved

SSRS 2008 Repeat Group on Header and Footer

Posted on 2011-09-28
4
769 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
[X]
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
  • 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

MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SSRS UK Map with Postcodes 2 189
SSRS 2012 URL 11 74
SSRS expression Issue finding a string 10 110
sql query to reportserver  table error 3 57
After much searching across the internet I have found that you could not set the name of the file you were attaching to dynamic report subscriptons in Microsoft Reporting Services. I did manage to find one article showing you how your could make a s…
This code started out as a fix for a customer that had incoming data that was hunderds of numbers and words long that was to fit in one column. The problem was that the customer did not want to split words or numbers when wrapping in the column. …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

734 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