Tuto WEBDEV 25

Part 5: Let’s continue the development 199 Creating the "Invoice" 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 WEBDEV project (Table control, Looper control, ...). Remark WEBDEV 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 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 description window of query is displayed. ▶ First of all, give a name to the query: type "QRY_Invoice" instead of "QRY_NoName1" in "Query name". ▶ To build the query, we are going to select the elements that will be displayed in the result. The query will contain the content of Orders data file, the content of OrderLine data file and the content of Customer data file. 1.  In the left section of the screen, select the Orders data file and click the blue arrow ( ): the items of Orders data file are displayed in the middle of the screen. 2. Repeat this action for the OrderLine and Customer data files.