Click among the quick access buttons.
The element creation window appears: click "Report" then "Report". The report creation wizard starts.
The report creation wizard proposes several types of reports:
Select "Table". Go to the next step.
Select the data source of report. The report will be based on the query that was just created. Select "From a data file or from an existing query".
Go to the next step.
In the list of data files and queries, select the "QRY_OrderForm" query. Go to the next step.
The wizard asks you to specify whether a break is required. No break will be used in this report. This concept will be presented later in this tutorial. Answer "No". Go to the next step.

You are going to specify the order in which the items will be printed and how they will be distributed in the different blocks. In the wizard, the items are listed according to the order defined in the query:

The items regarding the customer will be displayed in the "Page header" block. Indeed, this information must not be repeated on each order line.
For the FullName, Address, ZipCode, City and Country items, click the line corresponding to the item. In the "Block" column, expand the combo box and select "Page header".
The items regarding the order will also be displayed in the "Page header" block. Indeed, this information must not be repeated on each order line. For the OrdersID and Date items, click the line corresponding to the item. In the "Block" column, expand the combo box and select "Page header".
Furthermore, we are going to modify the caption of "OrdersID" item.
- Select the line containing the OrdersID item.
- Click the Caption column and type "Order #".
- The items regarding the order lines will be displayed in the report body. These items will be displayed for all the order lines.

The items regarding the order totals will be displayed in the page footer. Indeed, this information must not be repeated on each order line. For the TotalBT_Or and TotalIOT items, click the line corresponding to the item. In the "Block" column, expand the combo box and select "Page footer".

The following table presents the different assignments of items in the order presented in the wizard:

Item	Block

FullName	Page header
Address	Page header
ZipCode	Page header
City	Page header
Country	Page header
OrdersID	Page header
Date	Page header
Reference	Body
Caption	Body
PriceBT	Body
Quantity	Body
TotalBT	Body
TotalBT_Or	Page footer
TotalIOT	Page footer

Go to the next step.
The wizard proposes to create a counter, a sum or an average on the numeric items found in the report. In this report, the calculations are performed by the query. Click the "No calculation" button. Go to the next step.

This step is used to define the report layout.

We will keep the default values with the "Portrait" orientation.


	Remark	Print margins When choosing the print margins, don't forget to take into account the physical margins of printers. The physical margins of printers are margins where no print is allowed. Furthermore, the physical margins differ according to the type of printer.

Go to the next step.
This step allows you to select the skin template used for the report. We recommend that you use the same skin template as the one used for the windows. In our case, select the "Phoenix" skin template for example and go to the next step.
All we have to do now is give a name and a title to the report.
- Type the title : "Order form".
- The "RPT_Order_form" name is automatically proposed.
  
  Express
  The option "Report modifiable in Reports and Queries" is not available in the Express version.
Validate ("Finish").
The report being too large to be printed in Portrait mode, the report editor proposes to use the landscape mode, to reduce the table or to print the table on several pages. In our case, accept the landscape mode.
Accept to reduce the table if necessary.
The window for saving the report is displayed. Validate the save information.
The report is displayed in edit in the report editor:
The different order lines are grouped in a table.

Run this report by clicking among the quick access buttons.
1. The report editor asks for the print destination. The print destination can be:
  Select "Report viewer" and validate.
2. The report editor asks for the parameters of query used by the report. Don't forget that a parameter was used to specify the number of the order to print. For the example, type the test value "1".
  Validate.
3. The report is displayed as requested in the report viewer.
  You can:
  - Print the current page or the entire document by clicking the printer.
  - Create a duplicate copy.
  - Select a different zoom value.
  - Save the report as a Word document (in RTF format).
  - Save the report in HTML format.
  - Save the report in PDF format.
  - Save the report in XML format.
  - Create an email with the report in HTML format in message body.
  - Create an email with the report in PDF format in attachment.
  - Annotate in the document.
  - Perform a search in a document.
  - Add watermarks.