Doh! So simple, but so easily missed.
"Wayne Snyder" <wayne.nospam.snyder@mariner-usa.com> wrote in message
news:OzsLHvkfFHA.2472@TK2MSFTNGP15.phx.gbl...
> Right click the group and there should be a dialog box, where you can
> select display footer....
>
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> (Please respond only to the newsgroup.)
>
> I support the Professional Association for SQL Server ( PASS) and it's
> community of SQL Professionals.
> "McGeeky" <anon@anon.com> wrote in message
> news:uuaheqkfFHA.1044@tk2msftngp13.phx.gbl...
>> Thanks Bruce. I have managed to get a group header and group body working
>> but cannot make a group footer, only a table footer (which I don't need).
>> How do I make a group footer?
>>
>> Thanks!
>>
>> --
>> McGeeky
>>
http://mcgeeky.blogspot.com >>
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message
>> news:%23yu%23nEkfFHA.1248@TK2MSFTNGP12.phx.gbl...
>>> This is totally supported and easy to do. You need to add groups to your
>>> table. Each group can have header and footers. You can then add an
>>> expression that totals the current field. Search Books Online for the
>>> word grouping
>>>
>>>
>>> --
>>> Bruce Loehle-Conger
>>> MVP SQL Server Reporting Services
>>>
>>> "McGeeky" <anon@anon.com> wrote in message
>>> news:eL6gP$jfFHA.3448@TK2MSFTNGP12.phx.gbl...
>>>> Hi,
>>>>
>>>> Is it possible to get reporting services to create a report with a
>>>> repeating grouping structure with a total at the bottom of each group?
>>>> I would want to start with a report header that is only output once.
>>>> Then for each repeating group, I need a header, the body, and a footer
>>>> with the total. Here is an example of the structure (hope it makes
>>>> sense!!!)...
>>>>
>>>>>>Report Header Begin<<
>>>> Branch=14 Date=2005-07-01
>>>>>>Report Header End<<
>>>>
>>>>>>Group Header Begin<<
>>>> Title=Hello
>>>>>>Group Header End<<
>>>>>> Group Body Begin<<
>>>> Code Customer Quantity
>>>> XYZ Smith 10
>>>> ABC Jones 10
>>>> 123 Zippy 10
>>>>>>Group Body End<<
>>>>>>Group Footer Begin<<
>>>> Total = 30
>>>>>>Group Footer End<<
>>>>
>>>>>>Group Header Begin<<
>>>> Title=OK
>>>>>>Group Header End<<
>>>>>> Group Body Begin<<
>>>> Code Customer Quantity
>>>> XYZ Smith 5
>>>> ABC Jones 5
>>>> 123 Zippy 5
>>>>>>Group Body End<<
>>>>>>Group Footer Begin<<
>>>> Total = 15
>>>>>>Group Footer End<<
>>>>
>>>> --
>>>> McGeeky
>>>>
http://mcgeeky.blogspot.com >>>>
>>>
>>>
>>
>>
>
>