We will now give the user the possibility to print the details of the requested order. The report can be directly printed via the popup menu of Table control.


	Answer	If you did not create the windows in the previous lessons, you can follow this lesson by opening a corrected project: in WINDEV's home page (Ctrl + <), click "Tutorial" and select "Full application (With windows)". A full corrected application project is also available: in WINDEV's home page (Ctrl + <), click "Tutorial" and select "Full application (Answer)". In this case, to follow the rest of the lesson, select the "Windows 32-bit executable" configuration in the "Project explorer" pane.

Creating the "Order form" report

First of all, we are going to list the information that will be displayed in the report:

The order characteristics: date and order number.
The personal customer details: name, address, zip code, city and country.
The characteristics of order lines:
- Ordered quantity,
- Product reference,
- Product caption,
- Total BT,
- Total IOT.

To easily create this report, the data to print will be grouped in a query. This query can be used by the report or by any other element of WINDEV project (Table control, Looper control, ...).


	Remark	WINDEV proposes to create reports from several data sources: data files, queries, controls, text files, ... In most cases, we advise you to group the data to print via a query and to create a report based on this query. To add an information into the report, all you have to do is add the corresponding item into the query. The reports based on data files must be simple reports, which means reports used to display data coming from a single data file.

Creating the query

The query editor will be used to create the base query of report.

Click among the quick access buttons. The element creation window appears: click "Query". The query creation wizard starts.
Select the "Select" option.
Indeed, this query will be used to select the records that will be printed in the report. Go to the next step.
The query description window is displayed. To build the query, we are going to select the elements that will be displayed in the result.

Double-click the items in the analysis, to the left of the description window. The items taken into account are displayed in the middle of the screen.
We want to print in the report:

information regarding the customer. In the "Customer" data file, double-click the FullName, Address, ZipCode, City, and Country items.
information regarding the order. In the "Orders" data file, double-click the OrderID and Date items.
information regarding the product. In the "Product" data file, double-click the Reference, Caption, and PriceBT items.
information regarding the order line. In the "OrderLine" data file, double-click the Quantity and TotalBT items.

information regarding the grand total of order. In the "Orders" data file, double-click the TotalBT and TotalIOT items.


	Remark	The order in which the items are inserted into the query is important. Indeed, this order corresponds to the order used to display the data in the report. The creation of the corresponding report will be simplified if this order is properly defined.

The description window of query is as follows:

At this time, this query is used to select all orders and the corresponding order lines.

We want to select the data corresponding to a single order whose identifier is known. Therefore, we are going to define the order number in parameter.

To manage the "Order identifier" parameter:
1. Select the Orders.OrdersID item (in the middle of the screen).
2. Expand "Selection condition" and select "New condition".
3. In the window that is displayed, we are going to specify that the selection condition corresponds to a parameter:
  Perform the following operations:
  - Select "Is equal to".
  - Check "the parameter".
  - The name of the parameter is automatically proposed: "ParamOrdersID".
4. Validate the condition description window. The number "1" is displayed on the right of Orders.OrdersID item, indicating that a selection condition was defined.
5. Give a name to the query: type "QRY_OrderForm" instead of "QRY_NoName1" in the "Query name" area:
6. Validate the query description window ("OK" button).
7. The save window is displayed. Validate the proposed information.
8. The graphic query representation is displayed: