BIRT

Business Intelligence and Reporting Tools:

BIRT is an open source Eclipse-based reporting system that integrates with your Java/Java EE application to produce compelling reports

ABOUT BIRT. TUTORIAL.

Here i am going to show you how to connect birt with mysql.

Step1:

    To create a report project in Eclipse

     goto File->new->other

Step2:

     Then expand the Business Intelligence and Reporting Tool. after that select the report project.

then click the next button and give the project name.then, Click the finish button.

Step3:

   Go to your project folder and right click.

   New->Report

   then give filename for your Report. and click finsh button.

Step4:

Then click Data Explorer after that right click the Data Sources and click New Data Source.

Step5:

Click the JDBC Data Source and then give your Data Source Name and click Next button.

Step6:

Then download the mysql connector from here.

Step7:

After step5 click the Manage Drivers and then click the add button and import your mysql-connector jar file here and click ok button.

Step8:

Then select the Driver Class

Step9:

After that Give your Database URL: jdbc:mysql://localhost:3306/birt

 jdbc:mysql://localhost:3306 is a localhost

 birt is your database

 Then give your mysql Username and password. 

 Finally click Test Connection.

Link1,Link2 to know how to configure your data sources with data sets and  how to form a report? etc...