3 Replies Latest reply on Mar 2, 2015 1:09 PM by BrianLoomis

    Products Purchased Report

    BrianLoomis

      Title

      Products Purchased Report

      Post

      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!

      Brian