Adding Objects to the Report

When you return to the Properties window for the Report object, you will see the SQL details in the Record Source field. Now that you have identified which table or tables to select data from, objects need to be added from the table(s) to the report.

By Admin

Viewing a Report

Up until now, you have been editing and viewing your report in the Design View. Once the design has been completed, you will want to view your report as a user would view it.

By Admin

Report Design View

You are viewing the report in what is called Design View. It should look very similar to the screen shot below:

By Admin

Record Source

The purpose of the Record Source property is to set the source of the data for the report. You can set the Record Source property to a table name, a query name, or you can build your own SQL statement by invoking the Query Builder. You can invoke Query Builder by clicking on the button with the three dots to the right of the Record Source property.

By Admin

Adding a Page Number

You may want to include page numbers at the bottom of your report for reference. Under the Insert menu, select the Page Numbers option.

By Admin