Inserting Objects in a Report

Objectives

After completing this lesson, you will be able to:

  • Insert objects in a report

The Field Explorer

The Field Explorer enables you to view database fields.

Database fields, formula fields, parameters, and special fields are examples of the types of objects that you can place, move, and resize on your report. You access and insert these objects onto the report from the Field Explorer.

Use the Field Explorer to insert, modify, or delete fields on the Design or Preview tabs. To see the Field Explorer:

  • Choose the Field Explorer button on the Standard toolbar.

  • Select the Field Explorer from View on the menu.

The Field Explorer displays a tree view of database fields and special fields that you can add to your report. It also shows formula fields, SQL expression fields, parameter fields, group name fields, and running total fields that you have defined for use in your report.

You can dock the Field Explorer dialog box. In free-floating mode, drag the Field Explorer to any location. Alternately, dock the Field Explorer as a tab, similar to the Design tab.

Browse Field Data

Use the Browse Data dialog box to preview:  

  • Data type (such as number, string, date)
  • Length (if the field is a string type)
  • Sample content of the field

You can take a look at a sample of the actual data in the table before you place the field on your report in the Browse Data dialog box.

Note

When you browse a field, by default you see the first 500 unique values of the field. 

If Select Distinct Data for Browsing is not selected, browsing returns the unique values in the first 500 records. 

Hint
You can also browse the field data after you place the field on the report by right-clicking the field and selecting Browse Field Data from the shortcut menu.

Special Fields

Special fields contain information that is not included in the data source, but is useful to the overall presentation quality of the report.

Some of the more commonly used Special Fields are:

Page Numbering (usually displayed in the Page Header or Page Footer section)

  • Page Number
  • Total Page Count
  • Page N of M

Dates and Times

  • Data Date/Time
  • Print Date/Time
  • Modification Date/Time

Report Information

  • File Author
  • Report Title
  • Report Comments
Note
Report Information contained in the Summary Info → Document Properties.

Log in to track your progress & complete quizzes