Skip to content

Keep Columns on One Page

How to keep all of a report's columns on one page

If a report includes many columns, additional pages may be required to accommodate all of them. While your report may contain so many columns that it does ultimately need to continue on an additional page, there are some steps you can take to minimize the number of pages your report will fill. When creating your report, consider the following options:

The Options tab

  1. Do not display the level of detail beyond what you need. For example, if it is not imperative to organize your report by assignment, do not choose to organize it by "Site, Place & Assignment," as this will create separate columns for each level of organization.

  2. Exclude totals columns unless necessary.

  3. When given the option, do not list volunteers unless necessary.

The Fields tab

  1. Do not include a blank column.

  2. For the volunteer list report in particular, note that there are several ways to display the same information. Some ways require more columns than others, so be sure to review your field choices carefully. For instance, you can check a box for "Title," a box for "First name," and a box for "Last name." Alternatively, you can click the box next to "Title First name Last name." Either way will give you the same three pieces of information, but the former will take three columns to display it and the latter will fit it in one column.

The Page design tab

  1. In most reports, the Page design tab includes a "Fit to page" option. However, due to their design, this option is not in Volunteer Profile, Schedule and some label reports. Checking this box will reduce the font size of text in your columns to fit more of the report on one page.

  2. Reduce the margin width. Entering smaller margins will permit your columns to expand closer to the edge of the page.

  3. Change the page orientation from Portrait to Landscape.

  4. Decrease the "body" font size down to 6 point font.

How to keep all of a report's columns on one page