• Creating a report based on a query.
• Printing a report based on a query with parameters.

	Estimated time: 30 mn

• 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.

	Note	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.
  1. Click among the quick access buttons. The window for creating a new element is displayed: click "Query­". The wizard for query creation starts.
  2. 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.
  3. The query description window is displayed. To build the query, we are going to select the elements that will be displayed in the result.
  4. Double-click the items found in the analysis on the left of 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.
       

       	Note	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".
     • Specify the parameter name: "pOrdersID".
  4. Validate the description window of condition. 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 description window of query (green button at the bottom of the screen).
  7. The save window is displayed. Validate the proposed information.
  8. The graphic query representation is displayed:
     

Creating the report based on a query

Modifying the "Order form" report

1. We are going to create a new popup menu. This menu will contain the WLanguage code used to print the report.
2. We are going to link this popup menu to the Table control and specify that the default popup menu will be displayed just after the popup menu defined for the Table control.

Creating the popup menu

• To create a popup menu in the "WIN_Menu" window:
  1. Open (if necessary) the "WIN_Menu" window in the editor (double-click its name in the project explorer for example).
  2. On the "Window" pane, in the "Bars and menus" group, expand "Popup menus" and select "New popup menu".
  3. A new popup menu appears in the editor. This menu option includes a single option named "Menu option".
     
  4. Display the description of popup menu:
     • Select "Menu option".
     • Display the popup menu (right mouse click).
     • Select "Description of popup menu".
  5. Give a name to the popup menu ("MENU_Order") and validate.

	Note	Popup menus and windows A popup menu is associated with a window. If a window includes several popup menus (popup menu of window, popup menus of controls, ...), all these menus are saved with the window.

• We are now going to define the option caption and its code.
  1. Select "Menu option".
  2. Press the Space key on the keyboard: the caption becomes editable. Type the new caption ("Print the order form") and validate.
  3. Display the code associated with the option:
     • Select the option.
     • Display the popup menu (right mouse click) and select "Code".
  4. Write the following code:
     
     // Print preview
     iPreview()
     // Initializes the report query
     iInitReportQuery(RPT_Order_form, ...
     TABLE_QRY_FindOrders.COL_OrdersID)
     // Starts printing the report
     iPrintReport(RPT_Order_form)
     
     In this code:
     • iPreview is used to specify that the report print will be performed in the print preview.
     • iInitReportQuery is used to specify the parameters expected by the query associated with the report. In our case, the query expects the order number in parameter. This order number is found in the COL_OrdersID column of the TABLE_QRY_FindOrders Table control for the current row.
     • iPrintReport is used to print the specified report (the RPT_Order_form report in our case).
  5. Close the code window and the window containing the popup menu.
  6. Save the "WIN_Menu" window.

Associating the popup menu with the Table control

Print test