Value of goods sold report

Arabic is the preferred language for this project. Create a report that shows the total value of goods sold after discount from a specific supplier or item(s) or category during a given timeframe, minus the total value of the goods returned of that specific supplier. Table Billheader type 2 is a consists of our FullBill No, and date of the sale. Table Fbillitems consists of the item code, quantity and price. Table items consists of the company, and category of each item code. Table restore bill consists of all the returns including date, item code, quantity and price. Primary keys are indicated with (-) sign before them. We need the results to show both totals view, and summary view. We need the ability to sort and filter the results by any field. The data is available in Microsoft sql and it is synced to mysql. It is preferred that the report is generated from the Microsoft sql tables, but from mysql will do as well. This project will be divided into 2 milestones, one after development, and one after testing. The important fields from the tables are posted below. fbillitems: -id No ItemCode Stock TQuantity Price billheader: -No -Type Date Discount items: AName EName -Code Company Category restorebill: No BillNo Date ItemCode Stock Quantity Price