Need Manufacturer Report

[William_firefold]

I think this may not be as simple as some of the other things we have needed, but..
We would like to have a report or some sort of page where we can view all of the products by a particular manufacturer, with columns for name, SKU, and model #.
This would help with ordering items by having both the manufacturer number and ours right next to each other.
Is there a way to do this without getting into the SQL?

[compunerdy]

Isnt that basically what I sent you? Like that but with model#?

[William_firefold]

no, that does not pull ALL products by manufacturer.

[AbleMods]

If your reporting needs are going to continue to grow, you might want to take a look at http://www.DataDynamics.com/

They've got a great .Net report writer that lets you write very nice reports and integrate them directly into the AC7 storefront. I've used it several times for some very spiffy reporting. Can output to HTML, Excel, PDF, RTF etc.

It requires Visual Studio and .Net coding skills though, so if you're not set up for full .Net development it's not going to work for you. An external SQL report writer for end-users like Crystal Reports etc. would be a good choice then. Heck, you could even use MS Access with ODBC connections for that matter

[mazhar]

Have a look at the following post, it may help you
viewtopic.php?f=45&t=6971