[ic] How best to get SQL Reports

Sat Aug 24 20:13:02 2002

On Sat, Aug 24, 2002 at 03:29:09PM -0700, Dan Browning wrote:
> At 05:10 PM 8/24/02 -0400, you wrote:
> >I'm running 4.8.6 using MySQL. I need to create a single document for each 
> >order.. combining info from both the transactions and orderline tables. 
> >Being rather new to SQL I thought I'd ask what others do (or would do). 
> >From what I've read, I think I want to create "reports" using the data 
> >from these tables.
> >
> >I've tried using the report features from M$ Access (XP), Corel Paradox 9 
> >and Sun Staroffice 6.0/Adabas. I can do queries using all three, but none 
> >of them is capable of actually creating reports. They all fail with some 
> >obscure error... different error in each. I don't think I'm asking them to 
> >do anything out of the ordinary, I think the problem has more to do with 
> >running Windows ME.
> >
> >So my question is how would you gurus go about creating a single document 
> >for each order (name address, skus, etc). Something like a mail-merge/form 
> >letter type of thing is what I have in mind. Thanks for all hints.
> >
> >DB
> 
> My understanding quotient is a little low today, I'm not sure what you are 
> asking.  3 random facts that come to mind:
> 
>  * I've used Seagate Crystal Reports to create reports from SQL databases.
>  * The Admin has the order reports feature (totals, etc.)
>  * The "Orders" section has a one-order "report" of user data, skus, etc.
> 

None of the above compares to straight up perl/dbi/sql.

-- 

Christopher F. Miller, Publisher                               cfm@maine.com
MaineStreet Communications, Inc           208 Portland Road, Gray, ME  04039
1.207.657.5078                                         http://www.maine.com/
Content/site management, online commerce, internet integration, Debian linux