Solved

SSRS 2008 Repeat Group on Header and Footer

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

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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SCCM Reporting 5 74
SSRS Columns as Rows in a Table 14 59
How to read data from SQL server  to sharepoint 2013 ? 3 48
Find control on SSRS report 1 47
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
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…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

679 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