Page 1 of 1
Need Manufacturer Report
Posted: Tue Oct 28, 2008 2:32 pm
by 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?
Re: Need Manufacturer Report
Posted: Tue Oct 28, 2008 2:37 pm
by compunerdy
Isnt that basically what I sent you? Like that but with model#?
Re: Need Manufacturer Report
Posted: Tue Oct 28, 2008 2:43 pm
by William_firefold
no, that does not pull ALL products by manufacturer.
Re: Need Manufacturer Report
Posted: Wed Oct 29, 2008 5:57 am
by 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
Re: Need Manufacturer Report
Posted: Wed Oct 29, 2008 6:04 am
by mazhar
Have a look at the following post, it may help you
viewtopic.php?f=45&t=6971