Specifying the page setup

In the Page Setup dialog box you specify the paper size, orientation, and margins of the current report when it is printed or exported.

The options of the Page Setup dialog box are also available in the print wizard. The two tabs of the Page Setup dialog box form two steps of the print wizard.

  1. Select File > Page Setup.
    You can also open Page Setup dialog box from the print preview.
  2. On the Header and Footer tab, specify the headers and footers of the report.
    The options on the Header and Footer tab relate only to reports that are printed or exported to, for example, .pdf format. Use these methods to specify headers and footers in web-based reports:
    • Insert text into the header or footer. Specify the text in the Header or Footer field.
    • Insert an object. Click, and choose the object from the list.
    You can insert these objects:
    Selection Format statement
    Date [DDMMYYYY] &[date]
    Date [DDMMYY] &[date2]
    Time &[time]
    Report Name &[view]
    Page Number &[page]
    Page Count &[pages]
    User Name &[user]

    With the exception of Date [DDMMYY] you can also insert these format statements in Print Preview. To align the text of the header or footer, click the text alignment buttons on the tool bar in Design Mode.

    To format the text of a header or footer, right-click the text in Print Preview and select Font.

    If you select Separator line of the header or Separator line of the footer, a line is printed below the header or above the footer.

  3. Optionally select Scale with report, for the header, or footer, or both.
    By default, the size of text and objects in headers and footers remains constant, whatever scaling is specified on the Page Setup tab. Select Scale with report to match the scaling of the header and footer to the scaling of the report.
  4. On the Page Setup tab, specify the paper size and source, the format of the page and the page margins.
  5. In the Print area section:
    • Define the print area by specifying the cells in the range to print, for example, C3:H12
    • If some rows contain content that must be printed on each page, specify the line numbers, separated by colons, for example, 1:2:3.
    • If some columns contain content that must be printed on each page, specify the column names, separated by colons, for example, A:B:C.
  6. In the Scaling section, specify the size of the report to be printed.
    The table shows the available options:
    Option Description
    Scale to % Reduces or enlarges the report size by the percentage you enter. You can enter values between 10 and 400.
    Fit to page(s) wide Prints a wide report on the number of pages you specify. You cannot specify more than 255 pages.
    Fit to page(s) tall Prints a long report on the number of pages you specify. You cannot specify more than 255 pages.
    Fit to page(s) wide by page(s) tall Prints a report with both page width and height scaled on the number of pages you specify. You cannot specify more than 255 pages.
Related topics