OpenUtilities Wiki Report Page Number Format

Report Page Number Format

	Product(s):	Promis.e, Bentley Substation
	Version(s):	through 08.11.13.73
	Environment:	N/A
	Area:	Template Management
	Subarea:	Report Template Designer

Background

The report templates supplied with Promis.e and Bentley Substation will list the page number and total page count when output to various formats. The information is typically displayed at the bottom of each page in a “Page x/y” format where x is the page number and y is the total page count.

This document describes how to display the page number and total in a “Page x of y” instead of “Page x/y” on reports.

Steps to Accomplish

Refer to the animation below when following this procedure.

Open Report Template Designer.
Select File > Open and open the report template to be modified.
If creating a report template from scratch, drag a PageInfo control from the Standard Controls area of the Tool Box (View > Windows > Tool Box) to the desired area of the template. The PageInfo control is typically placed in the Bottom Margin band. If there is already a PageInfo control for page numbering on the template, click on it in the Designer view. In the Designer view, such a control looks like a box containing the text “1/1”.
Click the > arrow that appears on the upper right of the box for the control placed on the template. This should reveal an XRPageInfo Tasks pop-up.
On the XRPageInfo Tasks pop-up, set the Page Info field to “NumberOfTotal” if it is not set to that already.
Enter "Page {0} of {1}" (without quotes) into the Format field. If there is already a text box nearby containing the text “Page:”, either enter “{0} of {1}” into the Format field or delete the "Page" text box.
Click off or right-click the box for the control placed on the template to close the XRPageInfo Tasks pop-up.
Use the Property Grid to set properties such as font style and size for the PageInfo control.
Preview the report. It may be necessary to resize the control to fit all the text.

The important part of the text entered into the Format field in step 6 are the {0} and {1} variables. The {0} variable will always be populated with the page number and the {1} variable will be populated with the total page count. The other text in the Format field is not necessary and can be changed or rearranged to suit.

It is also possible to place separate PageInfo controls for the page number and total count. For example, one control could have a Format value of “Page: {0}” and another could have a Format value of “Total: {1}”