Birt Reporting tutorial For Beginners

This is step by step guide for those who are seeking to learn Birt Reporting using Eclipse IDE.

Any one can learn from this post. I used easiest way for making this post.

1- First of all dowload this .sql file (birtDb.sql) and run this script file on any MySQL front end of local machine. I used this database in this post.

 

2- Create a Dynamic Web Project in Eclipse

 

Project name: Birt_Report_Project

and leave other fields as deafult.

Now Click Next button and leave all values as deafult. 

Press Finish button on last window of creating project.

Download Birt jar and other files from here. (Birt Download Link)

Add birt Jar files in lib folder and other in Web-INF folder.

Now Project Structure like this: 

3- Now Add new folder in WebContent folder of project like:

Folder Name: reports and Press Finsh button. Now reports folder created.

4- Now Open Reports Perspective 

 

5- Now Create new Report in reports folder like this:

Report name:   SampleBirtReport.rptdesign

Click Next Button, next window 'll like this:

Now Click Finsih button to finish it.

6- After creating report, Eclipse window look like this:

 

 6- Now open "Data Explorer" view. Create new Data Source like:

Now new Window appear like this:

  

Select JDBC Data Source, Click on next button. Fill all fields like in below screen.

Now Window look like:

Click on Test Connection button for testing connection, window appear like this:

Now Finish this wizard by clicking on finish button.

7- Now Create New Dataset like:

Dowload this sql from here (sql file). Now new Window appear like this:

Copy that sql file and paste in this window like i do. Now click on finish button to end it.

After Finishing that, New window appear like:

In this window Output Columns are shown after executing query which we write. 

Now Click on Preview Results to view the output of that query. Now window look like this:

Now Click Ok button.

8- Now Data Explorer view look like this screenshot:

Now Right Click on recently created Data Set, menu appear like below screenshot.

Select Insert in Layout option.

After selecting above option, window should look like this one:

  9- Now Select Preview option , located in bottom of report page, report page look like this one:

 

10- For Viewing report in Birt Viewer Window select option from menu. Select View Report in Web Viewer from menu.

Now Report show in Birt Viewer like this :

Dont worry, if your report output not look like above outputs.

I do some formatting in this report from my end. 

 If you want to run this example, you can download its war file from here: (WAR file).

Hope this post 'll help you in learning birt reporting. Give me your feedback about this post.

and Enjoy learning...:)