Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Tejpal, A.D.
  New Posts New Posts RSS Feed - Report_GrpPaging_XofY_WithTOC
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Please consider donating $1 per sample downloaded, (find out why here)


 Post Reply Post Reply
A.D. Tejpal View Drop Down
Microsoft MVP
Microsoft MVP

Joined: 30 Jun 2008
Status: Offline
Points: 192
Post Options Post Options   Thanks (0) Thanks(0)   Quote A.D. Tejpal Quote  Post ReplyReply Direct Link To This Post Topic: Report_GrpPaging_XofY_WithTOC
    Posted: 07 Jul 2008 at 10:59pm
Explanatory Notes:
     The sample db demonstrates display of sub-page numbers, group-wise
(for top level group), in addition to normal page numbers for the report as a whole.
Table of Contents (TOC) showing a summary of group names with their start & end pages has been provided at the beginning of report. Same report can be opened in TOC or Non-TOC mode, as per user's choice. In Non-TOC mode, the table of contents gets bye-passed.

    The zipped folder contains two versions (2K & XP). The XP version has a string of bridging dots in table of contents. This feature has been avoided in 2K version as the results achieved through TextWidth property in 2K are not found quite perfect. (On the other hand, the behavior in XP onwards is observed to be satisfactory).

    For depicting sub-page numbers for each individual group, it is necessary to have two cycles of formatting, before commencement of print-preview. The first cycle populates the array, while the subsequent one assigns values to the unbound text box used for depicting sub-page numbers group wise. In order to force this behavior, it is necessary that a calculated control containing [Pages] as a part of its expression is present in the report.

    Two alternative methods for storing information regarding group-wise page details are demonstrated. First method uses an array for storing the particulars, while the other does it via a dedicated table.

    In the sample, group page particulars are displayed at top (just below group header content) while overall page numbers for the report as a whole, are shown at bottom. The placement of relevant text boxes can be altered suitably, if so desired.
Version:  Access 2000 File Format
Reference:  DAO 3.6

Back to Top
Sponsored Links

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.