cgchris99 Posted February 20, 2004 Share Posted February 20, 2004 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. Chris Link to comment Share on other sites More sharing options...
ptrau Posted February 21, 2004 Share Posted February 21, 2004 we do a manual dump out of mysql and hack it into an excel spreadsheet "Aliiiiive, it's alive, it's ALIIIIIIIIIIIIIVE!!!" Link to comment Share on other sites More sharing options...
Guest Posted February 21, 2004 Share Posted February 21, 2004 use mysql odbc to connect to the database, create the report and then can have uptodate reports at anytime, with graphs Link to comment Share on other sites More sharing options...
Guest Posted February 21, 2004 Share Posted February 21, 2004 http://www.oscommerce.com/community/contributions,539 Link to comment Share on other sites More sharing options...
cgchris99 Posted February 21, 2004 Author Share Posted February 21, 2004 JB, I have that contribution. But it doesn't give me a report showing the items purchased only the dollars. Mibble, I have crystal reports so I will look into that as an option Link to comment Share on other sites More sharing options...
Guest Posted February 21, 2004 Share Posted February 21, 2004 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 More sharing options...
cgchris99 Posted March 21, 2004 Author Share Posted March 21, 2004 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? thx Link to comment Share on other sites More sharing options...
cgchris99 Posted March 21, 2004 Author Share Posted March 21, 2004 I figured it out. Had to modify the sql statement manually. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.