Understanding Page Bands in Report Designer

Understanding Page Bands in Report Designer

The articles in this section of the Knowledge Base involve working with Page Bands for display in your reports. To access the Report Designer, select Toolbox Setup > Design Reports > Design (Report Type) Report. Select New Report to design a report from scratch or New Report from Existing. Select Designer to open Report Designer.

From this screen, add a Page Band component to your report, or edit an existing data band component.


Fig. 01 – Page Bands

Page bands are a vital component for report creation. Generally, they are used to output things like company address, contact information, copyright notices, page numbering, etc.. Report Designer has three types of page bands: Empty Data, Page Footer, and Page Header.

Page Header Band

A Page Header band is output at the top of every page of the report. There is no limit to the amount of Page Header bands that can be placed on a page.

The number of Page Header bands that can be placed on a page is effectively only limited by the available space.

Example

In a new report, add a Page Header band, a Data band, and a Header band. Use the Page Header band to display the current page number and number of pages in the report. Use the Data band to display data in the report. Use the Header band to display column headers. Add a text component to the Page Header band and add the following expression in the Text Property Editor:

{PageNofM}

To the Header Band, add four text components to act as column headers. For this example, I’ve added the following headers:

  1. Company
  2. Address
  3. Phone
  4. Contact

To the Data Band, add four text components and apply a data field that corresponds to the headers you chose above.

You should have something that looks like this:


Fig. 02 – Example with Three Bands and Page Number Expression in Designer

At this point, run the report. Notice the page number is printed at the top of each page and that data fields have populated down the pages.


Fig. 03 – Printed Report Example

A Page Footer band is output at the bottom of every page of the report. The Page Footer is useful for company information, dates, and page numbers. There is no limit to the amount of Page Footer bands that can be placed on a page.

The number of Page Footer bands that can be placed on a page is effectively only limited by the available space.

Example

In a new report, add a Page Footer band, a Data band, and a Header band. Use the Page Footer band to display the current page number and number of pages in the report. Use the Data band to display data in the report. Use the Header band to display column headers. Add a text component to the Page Footer band and add the following expression in the Text Property Editor:

{PageNofM}

To the Header Band, add four text components to act as column headers. For this example, I’ve added the following headers:

  1. Company
  2. Address
  3. Phone
  4. Contact

To the Data Band, add four text components and apply a data field that corresponds to the headers you chose above.

You should have something that looks like this:


Fig. 04 - Example with Three Bands and Page Number Expression in Designer

At this point, run the report. Notice the page number is printed at the bottom of each page and that data fields have populated down the pages.


Fig. 05 – Printed Report Example

PrintOnEvenOddPages Property


Fig. 06 – Print on Even Odd Pages Property

The PrintOnEvenOddPages property is used to print headers and footers on even/odd pages, for Page Header bands and Page Footer bands.


Fig. 07 – PrintOnEvenOddPages Set to EvenPage

Figure 06 shows a report with the PrintOnEvenOddPages property of the Page Header band set to EvenPage.


Fig. 08 – PrintOnEvenOddPages Set to OddPage.

Figure 07 shows a report with the PrintOnEvenOddPages property of the Page Header band set to OddPage.

There are three values available for the PrintOnEvenOddPages Property:

  1. PrintOnOddPage – Bands are printed on odd pages. 
  2. PrintOnEvenPages – Bands are printed on even pages. 
  3. Ignore – Bands are printed on all pages. 
    • Related Articles

    • Understanding Empty Data Bands in Report Designer

      The articles in this section of the Knowledge Base involve working with Empty Data bands for display in your reports. To access the Report Designer, select Toolbox Setup > Design Reports > Design (Report Type) Report. Select New Report to design a ...
    • Understanding Report Bands in Report Designer

      The articles in this section of the Knowledge Base involve working with Report Bands for display in your reports. To access the Report Designer, select Toolbox Setup > Design Reports > Design (Report Type) Report. Select New Report to design a report ...
    • Understanding Child Bands in Report Designer

      The articles in this section of the Knowledge Base involve working with Child Bands for display in your reports. To access the Report Designer, select Toolbox Setup > Design Reports > Design (Report Type) Report. Select New Report to design a report ...
    • Report Band Properties in Report Designer

      The articles in this section of the Knowledge Base involve working with Report Bands for display in your reports. To learn more about Report Bands, and how to access this section within the Report Designer, see Understanding Report Bands in Report ...
    • Adding a Header to a Table in Report Designer

      The articles in this section of the Knowledge Base involve working with Lists for display in your reports. To learn more about Lists and how to access the Report Designer, see Creating Lists in Report Designer. This article provides information on ...
    • Recent Articles

    • Toolbox Release Notes | Build 24.1.1206.641

      The following release notes apply to Toolbox build 24.1.1206.641 MV Server Nesting Fix There was a reported issue occurring when users attempted to remotely process work orders using a nesting station on MV Server. When attempting to process the work ...
    • Microvellum Foundation Library Release Notes | Build 24.1127

      The following release notes apply to Microvellum Foundation Library build 24.1127. Additions Added a new Soffit product to the Upper Cabinet Accessories category. Added the Top Filler (Ceiling Scribe) option to Upper and Tall cabinets. (Corner ...
    • Toolbox Release Notes | Build 24.1.1125.641

      The following release notes apply to Toolbox build 24.1.1125.641. IRIB Setmill Location Fix Fig. 1: Setmill being moved to the start of the route (top) rather than at the center of a straight line, as intended (bottom). There was an issue reportedly ...
    • Toolbox Release Notes | Build 24.1.1105.641

      The following release notes apply to Toolbox build 24.1.1105.641 Nesting Fix Fig. 1: The fatal error that would occur during processing. There was reportedly an issue that occurred when clients attempted to process a work order using the nesting ...
    • Microvellum Foundation Library Release Notes | Build 24.1025

      The following release notes apply to Microvellum Foundation Library build 24.1025. Additions Added new global variable “Remove Stop Dado On Bottom Edge” for wood drawer boxes. Check this option to run the dado through at the bottom of the sub front ...