Manufacturer Sales Report

[Danielle]

I have this installed, and it works great when I have the Sort Results By set to default, but if I try to sort it any other way, it says the following:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY pquant ASC, pname ASC' at line 1

The part that I bolded changes depending on what kind of sort you choose, e.g. A-Z, 1-9, etc.

Anyone know why it might be doing this and how I could fix it???

Thanks!

[HappyMom]

Hi,

Where did you get the manufacters sales report?

I also need one to generate reports based on manufacters/designers for my digital scrapbook site.

Thanks!


Norma

[townsend2009]

Bump ;) I would like to show a report of sales by manufacturer. Not sure how to do that. Thanks!

[gharls]

I believe that BlindSide has released a new version of his Sales Report (v2.0) in the Free Downloads section. Perhaps this app will meet your spec ... many Zenners speak highly of his mod.

Long Live SQL!