3 Replies Latest reply on Jun 20, 2012 11:07 AM by philmodjunk

    Need an efficient per-item sales report

    MaximoBerocay

      Title

      Need an efficient per-item sales report

      Post

      I am currently rebuilding our database and we need a way to give sales numbers per-item for arbitary date ranges. The current method we are using can take more than 10 minutes to sum all the item sales and generate a report. Is there a way I can structure the tables to reduce this time?