2042

Change the Report Header of the CustomersReport report from CustomersReport to Report for all our customers without changing format. Maximize the width of the textbox to display the whole new text. Save but do not close the report.

2045

Insert a new text box in the footer of the report that will display the total of records.

2111

Create a new report which will be based on the query r_orders in which all the fields will appear. Grouping level based on the field CustomersCode. Ascending ordering according to Description, with summary of sum of the field TotalValue and sum of the field Quantity (show detail and summary without percentage calculations). Set the orientation of the report to Landscape. Save the report under the name r_orders and close it.

2112

Insert one more text box in the CustomersCode footer section of the R_Orders report to display the average of the TotalValue field. Insert the same text box in Footer section of the report too. Make sure both of the boxes are displayed in 12pt Arial Black font. Save and close the report.

2125

Create a report based on all fields of the r_orders query grouped by the CustomersCode field. The report will display the maximum of the TotalValue. Accept the default properties and save the report under the name All_Orders. Finally, close the report.

2126

The data of the open report are grouped and sorted by CustomersCode in ascending order. Change the grouping field from CustomersCode to ItemCode and the sorting type from ascending to descending. Save and close the report.

2154

Modify the R_Orders1to1 report so that every customer record starts in a new page.

2155

Insert a new text box in the R_Orders1to1 report that will calculate the total of the TotalValue field. Make sure this item is displayed once in the last page of the report.

2171

In the CustomerID footer of the R_Orders report insert a new text box which will calculate the percentage of the customer’s TotalValue in the final TotalValue.

2172

Insert a new text box which will calculate the total of the TotalValue field in the footer of the R_Orders report. Insert one more text box to calculate the total number of the orders.

2173

Insert a new text box that will calculate the total of the TotalValue field for every client in the CustomerID footer of the R_Orders report. Insert one more text box to calculate the total number of the orders placed by every client. Save the report.

2196

Delete the subreport from the Customers report.

2197

Insert the subreport named R_Orders in the Detail section of the Customers report. Use the CustomerID field to link your main form to this one. Save the report.

2782

Apply the appropriate changes to the R_Orders report so that the bottom part of every page contains both the current date and time in one text box and the page number in another, in the following format: Page 1 of 5

2785

Insert a text box in the Detail section of the R_Orders2 report that will display the product of the Price value by the Quantity value for every order in Euro number format.

2786

In the R_Orders3 report modify the text box which displays Surname in the appropriate way to display Surname and Firstname separated by a space between them.

2787

Insert a text box in the CustomerID footer section of the R_Orders report, that will display the percentage of every customer in the turnover. Make sure the resulting output is displayed in percentage form with two decimal places.

2790

Apply the appropriate changes to the R_Orders4 report so that every customer entry is displayed in different page.

2799

Insert a text box in the footer section of the R_Orders report that will display the lowest value of the DateOfOrder field. Save the changes.