Designing the Orders Report

In this step we design the layout for our Orders report. The report can be designed using any of the controls in the Report Items tab of the Toolbox. The Orders design employs Textbox and Table controls to display output. Note that the items from the ORDERS file are dragged directly to the form from the Fields dialog box.

To design the Orders report:

Select the Layout tab from the report design environment.

The Layout form displays.

Design your report by dragging-and-dropping items from the Fields dialog box to the Layout form.
Use the Textbox Properties dialog box to set the numeric format for cells that display numeric data. To access this dialog box, right-click the appropriate cell, and then select Properties.

NOTE-

In this tutorial, the customer’s name and address and the order number and date are dragged directly to the form whereas the product code and description, quantity, price, and discount fields are placed in a table, Note that items added to the table must be dropped in the Details row of the column.
In this tutorial, a Total column is included with the necessary calculation code to calculate the total price for each item ordered and the grand total price for the entire order.

Below is an example of the resulting form: