[ic] Complex Order Reports

Lee Hoffman lee@rsub.net
Mon, 15 Jan 2001 21:38:05 -0500


Has anyone figured out how to generate a custom order report with
information like:

The week/month/year's top selling products.
The week/month/year's Gross Sales
The week to week change in Gross Sales
etc.

Im guessing that the above has to be done in a custom cgi-script or sub
routine. Is there any SQL expert out there that knows off the top of their
head how to run queries to extract the above data from the transactions
database?

Thanks in advance,
Lee