Possible to do this report?

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.comThis 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
>|||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
>|||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
>>
>|||Doh! So simple, but so easily missed.
--
McGeeky
http://mcgeeky.blogspot.com
"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
>>
>>
>