Custom reports for vTiger 6.2

Hello Freelancers, Create a custom report in the Home that you give it a date range and will look into all the sales orders, then it will create a table like this: - Name of product, how many items of the product apeared in all the sales orders in that date range, how much money sold in total for that given product, it will tell the comission for that given product in %, then calculate the comission being paid for that product, and then look at the total money of all the products sold in the period and calculate incidence in % of that product in the total. - It will also list the products not being sold. - The table will have to be order-able by any column. Also, very similar querying, you select another time range, and it will look again at all the sales orders and the products within them, but this time, it will create a table by assigned too, show the total sales, and calculate the commission to the sales person... have in mind that commission is per product, therefore, it will have to look for each amount sold of which product to calculate the commission. It can show that in the table to, a detail of how much of the commission corresponds to which product. Regards, Akma