Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles

MS Access

Posted Sep 2, 2003

MS Access for the Business Environment: Reporting in MS Access: Grouped Transactional Report Part I - Page 4

By William Pearson

Create the New Report

Now that we have put a query in place to act as a data source, we are ready to set about the report's creation, and its subsequent binding to its source. We will take the following actions to complete our objectives:

1.  In the Objects pane on the left side of the Database window, click the Reports button, shown in Illustration 10.

Illustration 10: Select Reports in the Object Pane of the Database Window

We arrive at the Reports window, and see various sample reports that are already there.

2.  Click the New button that appears in the toolbar, as depicted in Illustration 11.

Illustration 11: The New Button in the Toolbar of the Reports Window

The New Report dialog appears, with Design View selected by default.

3.  Ensuring that Design View is selected, click the arrow on the selector for the Choose the Table or Query where the Object's Data comes from box in the lower section of the dialog.

4.  Select the Customer_Orders_Source query we created in the last section.

The New Report dialog appears as shown in Illustration 12.

Illustration 12: The New Report Dialog, with Settings

5.  Click OK.

After a few seconds, perhaps less, we are greeted by the Report Design window, which displays header, detail and footer sections. Also apparent is the Field List from the Customer_Orders_Source query, which floats, as it were, over the Report Design window, as depicted in Illustration 13.

Illustration 13: The Report Design Window Dialog, with Source Field List

We can see, by the contents of the Field List, that the blank report is bound to the data source. We are now in a position to establish some of the physical characteristics of the report.

MS Access Archives

Latest Forum Threads
MS Access Forum
Topic By Replies Updated
Help With Microsoft Access kasy 0 September 4th, 07:35 PM
Linked table not sorting or filtering - ODBC error Java 1 August 28th, 10:37 AM
Use Parameter in select statement (Sql in Microsoft Access) katty.jonh 1 July 25th, 06:45 AM
Query Issue algebroni 7 July 23rd, 04:22 PM