Solved

SSRS 2008 Repeat Group on Header and Footer

Posted on 2011-09-28
4
751 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to add SSRS subscription in Team Foundataoin server(TFS) 3 44
SSRS Expression 2 37
Date Differences SSRS 3 59
sql query to reportserver  table error 3 39
Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

920 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now