Database Reports

Overview

With Database Reports, you can produce a printed report of the information in your database. Database Reports are generated automatically from database views.

Creating database reports is ideal when you want to:

You can fully customize the presentation of your printed reports. Choose from one of five professionally designed report formats and custom tailor the page title, gridlines, and page break options.

Creating a database report

You must be a database manager to create new reports.

To create a database report:

  1. Go to the Manage Database page for the Database, and then click Reports.

  2. Click New in the Command Bar.

  3. Select the properties for your report:

Report Name

This is the name of the report as it appears within the site. The Report Name does not appear on the printed report.

 

Source View

The report is generated based on the view you select here. If you'd like to change how information is displayed in the report, you must first make changes to the source view.

Click here to learn more about making changes to views.

 

Page Title

This title appears at the top of each page of the printed report. By default, the page title is the name of the database plus the name of the source view. If you'd like a different title to appear there instead, select the Other option and type the new name in the text box beside it.

 

Paging

If there are groups in the source view, you can choose to start a new page at the beginning of each group.

Note: In Internet Explorer this option is not available on Mac OS X or Mac OS X 2.6.

 

Grid Lines

Select whether or not you'd like to display gridlines in your report.

 

Report Format

Select from one of five report formats. When you click each report option, you see an illustration of what the report format looks like to the right.

You'll notice that some of the report formats are available in full color, for printing on a color printer. Even if you do not have access to a color printer, you can still use one of the full color formats. The report is simply printed in gray tones instead.

 

  1. Click Save in the Command Bar.

Printing a database report

All users who have Read access to a database are permitted to print reports from the database.

To print a database report:

  1. From any view page, click Reports in the Command Bar. Click the printer icon next to the report you want to print. You see a preview page for the report.

  2. Click Print Report at the top of the preview page. If you are using an older web browser, it might not recognize this print command. If this happens, simply use your browser's File > Print option.

Modifying a database report

You must be a database manager to make changes to a report.

To modify a database report:

  1. Go to the Manage Database page for the Database, and then click Reports.

  2. Click the Edit icon beside the report you'd like to modify.

  3. Change the report properties, then click Save in the Command Bar.

Tips on printing database reports

Here are some tips on printing database reports.

Printing your reports as they appear in the preview
The reports make use of both background colors and images. If you use Microsoft's Internet Explorer, please make sure that the browser is configured to print using background colors and images. To turn on this option:

  1. Select Internet Options from the Tools menu.

  2. Select the Advanced tab.

  3. Scroll down in the Settings: window until you can see the Printing section.

  4. Check Print background colors and images.

  5. Click Ok.

Changing the header and footer information that appears on your printed report
Depending on your browser settings, your printed reports might contain headers and footers that you might not want to show. For example, you might not want to print the page number, page URL, and date on your report. In Internet Explorer, you can control these settings in your browser's Page Setup options.

To change your Page Setup options in Internet Explorer 6 and above:

  1. Select File > Page Setup.

  2. In the Header and Footer boxes, specify the information to be printed by using the following variables.

To print this

Type this

Window title

&w

Page address (URL)

&u

Date in short format

&d

Date in long format

&D

Time

&t

Time in 24-hour format

&T

Current page number

&p

Total number of pages

&P

Centered text

&b

Right-aligned text

&b&b

A single ampersand

&&

  1. Variables can be combined with text. For example, Page &p of &P would be rendered as "Page 2 of 9." To show no header or information, simply clear all the information in the Header and Footer boxes.

  2. Click Ok.