|
|
You're in the
sql server reporting services
group:Possible to do this report?
sql server reporting services:
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 [quoted text, click to view] "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 [quoted text, click to view] "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 >>>> >>> >>> >> >> > >
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 [quoted text, click to view] "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. [quoted text, click to view] "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 >>> >> >> > >
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!!!)... [quoted text, click to view] >>Report Header Begin<< Code Customer QuantityBranch=14 Date=2005-07-01 >>Report Header End<< >>Group Header Begin<< Title=Hello >>Group Header End<< >> Group Body Begin<< XYZ Smith 10 ABC Jones 10 123 Zippy 10 [quoted text, click to view] >>Group Body End<< Code Customer Quantity>>Group Footer Begin<< Total = 30 >>Group Footer End<< >>Group Header Begin<< Title=OK >>Group Header End<< >> Group Body Begin<< XYZ Smith 5 ABC Jones 5 123 Zippy 5 [quoted text, click to view] >>Group Body End<< >>Group Footer Begin<< Total = 15 >>Group Footer End<< -- McGeeky http://mcgeeky.blogspot.com
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |