Creating reports in VB6

Hi All

Please can you advise on the best way to create reports in VB6, my
application is linked to a MySQL database. I want to create a Purchase
Order Report from a query linking 4 different tables what is the
easiest way to do this.

Cheers

On 16 Feb 2005 08:52:44 -0800, simon.gadsby.DeleteThis@gmail.com wrote:

 >Please can you advise on the best way to create reports in VB6, my
 >application is linked to a MySQL database. I want to create a Purchase
 >Order Report from a query linking 4 different tables what is the
 >easiest way to do this.

I don't know what the /best/ way to do this would be.

The easiest way I know of, would be to buy a 3rd party reporting tool.

Some raw VB ideas are
* use a RichTextBox to preview with,
* use a Picture control to draw each page,
* export to HTML/CSS or XML/XSL and have the browser handle the
printing
* export the data to another application using OLE
automation/importing where it can be printed.

Hope this helps!
_______________________
Michael B. Johnson<!-- ~MESSAGE_AFTER~ -->