JasperReport & MySQL

[2002 JI Open Discussion]

By: Andy Chan - kinseong

JasperReport & MySQL

2003-12-18 01:07

Hi,

 

I can put data from MySQL to JasperReport and generate report?

 

Thanks!!

 

 

 

 

By: Andy Deighton - andyxr

RE: JasperReport & MySQL

2003-12-18 01:46

You can use any JDBC datasource (or indeed any datasource that complies with the interfaces supplied by JasperReports). The PDF documentation refers to this extensively and it's as simple as passing a Connection object to your report and optionally a query, or query parameters etc. So, the short answer is YES and it's easy!

 

Andy

UK

 

 

 

 

By: Andy Chan - kinseong

RE: JasperReport & MySQL

2003-12-18 02:33

By the way, got any sample for MySQL and Jasper Report? I looked through the samples provided in the JasperReport 0.4.5 packages but I think don't have sample for MySQL.

 

Thanks.

 

 

 

 

By: Andy Chan - kinseong

RE: JasperReport & MySQL

2003-12-18 02:29

Thanks Andy from UK answer my question.

 

As you mentioned in your replied "the PDF documentation", where could I get this? Can send to me or by posting a URL here?

 

I tried to do some report using Servlet & MySQL & Jasper Report. But I don't know where to start. Need guide for this coz I'm new in this.

 

 

Thanks in advance.

 

 

 

 

By: Teodor Danciu - teodord

RE: JasperReport & MySQL

2003-12-18 02:35

 

Hi,

 

All the freely available documentation is published

on the project website:

 

http://jasperreports.sourceforge.net

 

and is also distributed inside the project source package.

 

If you think you need more, here is a more complete

guide:

 

http://jasperreports.sourceforge.net/more.docs.html

 

Thank you,

Teodor

 

 

 

 

 

By: Andy Deighton - andyxr

RE: JasperReport & MySQL

2003-12-18 02:40

The PDF documentation is something you can purchases via the site.

The examples are all based on JDBC, so it doesn't matter whether you're using MySQL, Oracle, Access - they're all treated the same using JDBC, so that's why there are no explicit MySQL examples.

 

Andy

UK

 

 

 

 

By: Andy Chan - kinseong

RE: JasperReport & MySQL

2003-12-18 19:08

Thanks guys. Will buy the complete guide in PDF format soon. I will explore more on Jasper Report, if I facing any problem, will get help from you guys.

 

Once again. Thanks!