AnsweredAssumed Answered

Need an efficient per-item sales report

Question asked by MaximoBerocay on Jun 20, 2012
Latest reply on Jun 20, 2012 by philmodjunk

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?

Outcomes