Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Reports - Items purchases by month?


Recommended Posts

We can view Best Products Purchased.


However, I want to know the top producers in each month.


For January I want to know the best selling item and how many

Same for Feb, March, April, etc.


This helps to see any trends and also helps knowing how much of each item to buy.


Anyone have a report like this they would like to share.



Link to comment
Share on other sites

with crystal reports, tied in via odbc (mysql odbc, get from mysql.com) you will love it. all reports on the fly, up to date with opening the report and choosing update, anytime, day or night.

Link to comment
Share on other sites

  • 4 weeks later...

I loaded Crystal 8.5 and have it connected via ODBC to the database. I can do simple reports buy when I try to join to table, I am getting an INNER JOIN error.


I am trying to connect orders to orders_products.


Can you asssist?



Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...