chrometweaks.org

Can I build a online date site on iPage?

Click Here To View All Answers...


Got a question, hope someone can answer... Can I build a online date site on iPage? Thanks in advance for any comment. My 2nd question... 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..

Comments (68)

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...

Comment #1

Use mysql odbc to connect to the database, create the report and then can have uptodate reports at anytime, with graphs..

Comment #2

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..

Comment #3

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...

Comment #4

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..

Comment #5

I figured it out. Had to modify the sql statement manually...

Comment #6

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..

Comment #7

We do a manual dump out of mysql and hack it into an excel spreadsheet..

Comment #8


This question was taken from a support group/message board and re-posted here so others can learn from it.