If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Reset page numbers for each group in a report
I seem to recall having done this very procedure before, but I can't
get it to work now. I have 1100 some-odd records generating reports-- which produces 1600 some-odd pages of report. I want Joe Smith's 2 page report to show Page 1; Page 2; respectively (rather than Page 1,041; Page 1,042). Following MS Access Help instruction and creating a macro which resets the [Page] value to 1-- which is invoked in the header's On Format property and forcing a new page "After Section" in the group footer results in having every page numbered Page 1. Copying the code from Northwind sample database and inserting it in the header produces the same result. Ideas? Instruction? Many thanks! |
#2
|
|||
|
|||
Reset page numbers for each group in a report
Ruth, did you put your code into the Format event of the *Group* Header, or
the Page Header section? -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Ruth" wrote in message oups.com... I seem to recall having done this very procedure before, but I can't get it to work now. I have 1100 some-odd records generating reports-- which produces 1600 some-odd pages of report. I want Joe Smith's 2 page report to show Page 1; Page 2; respectively (rather than Page 1,041; Page 1,042). Following MS Access Help instruction and creating a macro which resets the [Page] value to 1-- which is invoked in the header's On Format property and forcing a new page "After Section" in the group footer results in having every page numbered Page 1. Copying the code from Northwind sample database and inserting it in the header produces the same result. Ideas? Instruction? Many thanks! |
#3
|
|||
|
|||
Reset page numbers for each group in a report
Hi Allen,
Just got back to this. In the Group Header. Thanks, Ruth |
#4
|
|||
|
|||
Reset page numbers for each group in a report
OK... I'm making a second reply with more information because I really
NEED to have this working by Monday! The report is a "wish list" for families in need. The top level record in the report is the parent data with child data grouped underneath. The main report is grouped on Head of Household name, with both a Group Header and Footer, Group on Each Value, Group Interval 1, Keep Together No. The report detail section contains a subreport that is also grouped-- by each child: Child 1 - Wish List Item 1, Wish List Item 2, Wish List Item 3, etc. Grouping options are set the same as for the HofH Name grouping: Group Header and Footer, Group on Each Value, Group Interval 1, Keep Together No. I'm wondering if this grouping within the subreport is causing me to get the repeated Page 1. Thanks again for any ideas you might have on this. Ruth |
#5
|
|||
|
|||
Reset page numbers for each group in a report
Hi Ruth.
Have just done some experiementing with this, and found: 1. Problem: If you use the Format event of the group header, it resets to 1 on the last page of the previous section. Becuase you have Force New Page set to Before, the attempt to fit put the section on the page resets the number. Workaround: Use the Print event of the section. 2. Problem: If you have Repeat Section set to Yes, it resets on every page. Workaround: If you need the heading repeated, create 2 group headers on the same field, and repeat the other one. 3. Problem: If you don't print all pages of the report, the page resetting does not work, because the events don't fire for the pages you did not print. Workaround: Print all pages, or only the pages for one client (using a WhereCondition in OpenReport.) This article might help too: Printing First and Last Page Numbers for Report Groups at: http://www.mvps.org/access/reports/rpt0013.htm HTH. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Ruth" wrote in message ups.com... OK... I'm making a second reply with more information because I really NEED to have this working by Monday! The report is a "wish list" for families in need. The top level record in the report is the parent data with child data grouped underneath. The main report is grouped on Head of Household name, with both a Group Header and Footer, Group on Each Value, Group Interval 1, Keep Together No. The report detail section contains a subreport that is also grouped-- by each child: Child 1 - Wish List Item 1, Wish List Item 2, Wish List Item 3, etc. Grouping options are set the same as for the HofH Name grouping: Group Header and Footer, Group on Each Value, Group Interval 1, Keep Together No. I'm wondering if this grouping within the subreport is causing me to get the repeated Page 1. Thanks again for any ideas you might have on this. Ruth |
#6
|
|||
|
|||
Reset page numbers for each group in a report
Hi Allen! Thank you so much! I will let you know how it works. I had a
feeling the problem stemmed from having something in the wrong location. And yes, I do have the group header set to repeat so that information is helpful as well. Thanks for anticipating. Wish me luck! Regards, Ruth |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Reporting subreport total on main report | BobV | Setting Up & Running Reports | 22 | November 1st, 2005 03:19 AM |
REPOST: Maintaining Page Numbers with multiple reports. | Robin Chapple | Setting Up & Running Reports | 1 | August 5th, 2005 06:53 AM |
Total hours from Table into Report | HeatherLou1974 | General Discussion | 3 | March 7th, 2005 08:04 PM |
Ambiguous outer joins | Renwick | New Users | 1 | February 22nd, 2005 02:08 PM |
Help Needed for Groups Please | Paul Black | General Discussion | 15 | June 21st, 2004 02:54 AM |