Modifying the grid appearance before printing

You modify the grid appearance by setting page setup options such as orientation, scaling, margins, and so on. This can help you ensure that the end result (the printed report), appears as you desire. You can modify such properties as the orientation, scaling, margins, line width, headers and footers, and so on. These settings are also referred to as page setup options.

To modify grid appearance before printing

1. Run a report. (How?)

2. From the File menu, choose Page Setup. The Page Setup dialog box opens.

3. The following buttons appear on each tab:

   • Print opens the Print dialog box.

   • Print Preview opens the Print Preview dialog box.

   • Options opens a window in which you can view and configure the advanced settings for the selected printer.

4. On the Page tab, your options are:

   • Orientation: Select either Portrait or Landscape. The default is Portrait.

   • Page numbering: This option is used only if you have a header or footer that displays page numbers. It numbers the pages either automatically or starting with a page number that you specify. The default is Automatic, which starts with 1 and increases sequentially in increments of one.

   • Scaling:

     • Adjust to x% normal size: Scales the report by a percentage of its original size, from a minimum of 10% to a maximum of 400%. The default is 100%.

     • Fit to x page(s) wide by x: Scales the report to fit to a certain number of pages horizontally by a certain number of pages vertically.

     If your report is extremely wide, and you want to print it on a single page (setting this option to Fit to 1 page wide by 1 page tall), several columns may still print on a second page. You can instead change the scaling in the PDF export options to one page by one page, export the report to PDF, and then print it from the PDF.

5. On the Margin tab, your options are:

   • Center on page: Select Horizontally, Vertically, or both. If neither option is selected, the report is positioned at the top left corner of the page.

   • Margins: The default page margins (Top, Left, Right, and Bottom) are all set to one inch. You can change some, all, or none of these margins as desired. These margins do not affect the placement of the header and footer.

6. On the Header/Footer tab, your options are:

   • Edit: You can specify formatting options for both a header and footer if desired. In order to simplify the visual presentation of the dialog box, only the header or the footer options are shown (depending upon which one is currently selected).

   • Line width: Select the width of the line that appears beneath the header or above the footer (depending upon which one is currently selected). Your choices are

     • None

     • Thin

     • Thick

   • The Header or Footer section contain the following text boxes that correspond to a specific portion of the header or footer:

     • Left section: Text is left justified with respect to the width of the page.

     • Center section: Text is centered with respect to the width of the page.

     • Right section: Text is right justified with respect to the width of the page.

       • At the bottom is a list that contains up to 15 of the most recently used lines of custom text, as well as some lines that have been predefined. When more than one text box is used, the text for each box is separated by a bar.

       • Wordwrap occurs within each text box whenever two or more boxes are used. If only one of the text boxes is used,

   • The toolbar enables you to create custom headers and footers easily. Each button is described in the table in Modify the grid appearance before printing: Page setup, Header/Footer tab.

7. On the Grid or Graph tab (the tab name changes based on what view your report is saved in), your options are:

   • Page fields: This option is available only when a report that has one or more page field items is being printed. Your options are as follows:

     • Displayed page field: Only the information for the currently displayed page field item(s) of the report is printed. This is the default.

     • Expand all page fields: All pages of the report are printed. If the report has more than 10 attribute elements (for example, if you page by the Week attribute for an entire year of data), a warning message asks you to confirm that you want to print all of the pages of the report.

     For either of these options, you can enable or disable the Show page field titles option.

   • Print on each page: Select Row Headings, Column Headings, or both. For reports that span multiple pages, these options control whether the row and/or column headers are to be included on every page.

   • Print: You can enable either, both, or neither of the following options:

     • Gridlines: If enabled, this option displays gridlines in the printout.

     • Black and white: If enabled, this option allows you to print in black and white on a color printer.

   • Page ordering: When a report spans multiple pages horizontally and vertically, you can choose the order in which the pages are printed. Your options are:

     • Down, then over: One vertical series of pages is printed before moving to the top of the next vertical series of pages to be printed. This is the default.

     • Over, then down: One horizontal series of pages is printed before moving to the beginning of the next horizontal series of pages to be printed.

Related Topics

• Report Viewer