Yup, but... you might want to make sure and wait for another person here to confirm my answer as I am not sure. Better yet, why don't you e-mail the iPage guys because they can give you an answer better...
Use mysql odbc to connect to the database, create the report and then can have uptodate reports at anytime, with graphs..
I have that contribution. But it doesn't give me a report showing the items purchased only the dollars..
I have crystal reports so I will look into that as an option..
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...
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?.
I figured it out. Had to modify the sql statement manually...
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..
We do a manual dump out of mysql and hack it into an excel spreadsheet..