Products Purchased Report
I am looking for a little advice on how to setup a report layout for my company. We setup a new Order database structure where Order.Id ------> Orderline.FK_OrderId. Orderlines store the product code, cost and quantity of a given product. I would like to have a report where the headers are:
Order Date, Customer, Order Number, Product1 quanity, Product1 Cost, Product2 quantity, Product2 cost...ProductN quantity, ProductN Cost
I would then like to have a grand summary at the bottom where we can see the totals of each product purchased for the week if we find by a date range of the Order Date.
Thanks in advance for your help!