AnsweredAssumed Answered

Products Purchased Report

Question asked by BrianLoomis on Mar 2, 2015
Latest reply on Mar 2, 2015 by BrianLoomis


Products Purchased Report


Hi Everyone!

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!