Tuto WINDEV 25

200 Part 4: Full application with data 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 query creation wizard 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. 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.