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, the .pdf format. Use these methods to specify headers and footers in web-based reports:

    • In the Header or Footer field, you can specify text using a string that includes commands. Use &L, &C, and &R commands to divide the header and footer into left, center, and right sections respectively.

      Use commands to modify font face, font size, font color, font type (regular, bold, italic, underline, strike through).

      To specify text and modify fonts use these commands:

      Command Description
      && Inputs the '&' character.
      &L Places the text in the left section.
      &C Places the text in the center section.
      &R Places the text in the right section.
      &”<font_name>[, <font_type>]” Sets the font type. These are valid font types:
      • “Bold”
      • “Italic”
      • “Bold Italic”
      • “Italic Bold”
      Example: 
      &L&"Arial, Italic"Left text&C&"Times"Center text&R&"Arial,
                Italic Bold"Right text
      &<number> Sets the font size.
      &I<number> Sets the color palette index.
      &S Strikes through the text.
      &U Underlines the text.
      &P or &[page] Inserts the current page number.
      &N or &[pages] Inserts the total page number.
      &A or &[view] Inserts the current report name.
      &D or &[date] or &[date2] Inserts the current date. The &[date] command returns the [DDMMYYYY] date format. The &[date2] command returns the [DDMMYY] date format. The &[date] command is used to export to .pdf and .xlsx files.
      &T or &[time] Inserts the current time.
      &F or &[file] Inserts the current report path. The &A command is used to export to .xlsx file.
      &M or &[user] Inserts the current user name.
      &<any_other_character> Is ignored and removed.
    • In the Header or Footer field, you can specify formulas that can contain variables.

      The &[=<formula>] command is substituted with the formula value in the report view.

      For example, the complete header or footer definition can be: 
      &LValue of cell D5 is &[=D5]&RValue of report variable V is
        &[=ReportVariables.V.Text]
      Where &L is the left part of the header and &R is the right part. The text of the left part is Value of cell D5 is &[=D5], and right part is Value of report variable V is &[=ReportVariables.V.Text]. The definition output in the report view is: Value of report variable V is <variable value of V>.
      The ']' character in formulas must be escaped by the '&' character. To use the '&' character in a formula, specify the '&&' character. For example, to insert a unique element name of a hierarchy ("[HierarchyName].[ElementName]"), specify this formula: 
      &[="[HierarchyName&]" && "." && "[ElementName&]"]

      If the inserted formula is invalid, it is used as a quoted string formula. The &[=<invalid_formula>] command is substituted with &[="<invalid_formula>"].

    • In the Header or Footer field you can insert an object. Select the object from the list of objects.
    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.

    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