try corereader at http://ww.corereader.com/
it's certainly not designed to create reports with
much of eye candy.
however, it queries mysql and access (and any other
data source), lets you create queries with point and
click, stores queries and connections, and gives you
a few report headers.
it's mainly a query tool, but it outputs to text,
schema based xml, etc, so you can feed its output
into a word processor or whatever for eye candy.
> Where can I get those tools? With MS access, my queries work fine after
> importing the data from MySQL
>
> Thanks
> Emery
> ----- Original Message -----
> From: "CP" <[EMAIL PROTECTED]>
> To: "NZEYIMANA Emery Fabrice" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Friday, September 27, 2002 10:47 AM
> Subject: Re: SHAPE command for Hierarchical Recordset
>
>
> > I would suggest you use MS Access report with MyTool-DLL For VB and MySQL.
> >
> > ----- Original Message -----
> > From: "NZEYIMANA Emery Fabrice" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Friday, September 27, 2002 4:40 PM
> > Subject: SHAPE command for Hierarchical Recordset
> >
> >
> > > I have created a MySQL database that will help me manage my Invoicing
> > system
> > > but I have been stack when I tried to print a report using a VB
> > application.
> > >
> > > I have read from Help that I will need to use a hierarchical recordset
> to
> > > achieve what I want to.
> > > You know an Invoice has some headers like: Customer names, Invoice
> number,
> > > ...
> > >
> > > It also has details of ordered products/services Like: Item ID,
> > Description,
> > > ...
> > >
> > > So my invoice should look like:
> > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > > NZEYIMANA (Customer name)
> > > Some Addresses
> > >
> > > Invoice No.: 2002-09/00005
> >
> > --------------------------------------------------------------------------
> > --
> > > -------------+
> > > Item ID Description Qty UP Total
> >
> > --------------------------------------------------------------------------
> > --
> > > -------------+
> > > 12 dfhsdfdsfjsd 5 25
> > 125
> > > ...
> > > ...
> > > _________________________________
> > > Total
> 125
> > > VAT: -------------
> > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > >
> > > To build such an invoice using ADO, VB, DataReport you need that
> > > Hierarchical recordset because DataReport won't accept if it is not a
> > > hierarchical recordset.
> > >
> > > How do I achieve this?
> > >
> > > Thanks
> > > Emery
> > >
>
>
>
>
>
--
John Ragan
[EMAIL PROTECTED]
501-228-0317
http://www.CoreReader.com/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
