22/08/2019 BIRT reporting Programming Tutorial for beginners
Start Download
Download Driver Support Tool From a Microsoft OPEN
Certi ed Partner
MENU
BIRT reporting Programming Tutorial for beginners
report this ad
View more Tutorials:
Report Programming
1- Introduction
2- Reporting interface after project completion
3- The installation requires
4- Create BIRT Project
5- Create Data Source
6- Create dataset report this ad
7- Create new Report
8- Configuring the size of the report
9- Interface Design (Header)
10- Design charts
11- Run reports for the first time
12- Designing the body of the report
13- Run report (2)
14- Edit style (1)
15- Run report (3)
16- Sub Total
17- Run Report
44
Shares
1- Introduction
This document is based on:
Eclipse 4.4 (LUNA) (or newer)
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 1/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
BIRT 4.4
2- Reporting interface after project completion
Start
Download
Driver Support
Download Driver Support Tool From
a Microsoft Certi ed Partner
report this ad
OPEN
This is a photo of report will be made in this document:
report this ad
Raw data:
First of all, we need to understand some professional knowledge:
A CUSTOMER can create one or more ACCOUNT in a branch of some bank.
Each account corresponds with a service PRODUCT provided by the bank.
Each account has an AVAILABLE BALANCE.
For convenience, you can look at the following raw data.
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 2/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
** SQL **
?
1 Select Acc.Account_Id
2 ,Acc.Cust_Id
3 ,Cus.Address Cust_Address
4 ,Acc.Product_Cd -- Product Code (Service of Bank)
5 ,Acc.Open_Branch_Id -- Branch (of Bank)
6 ,Bra.Name Branch_Name
7 ,Acc.Avail_Balance -- Available Balance
8 From Account Acc
9 ,Customer Cus
10 ,Branch Bra
11 Where Acc.Cust_Id = Cus.Cust_Id
12 And Acc.Open_Branch_Id = Bra.Branch_Id;
report this ad
3- The installation requires
BIRT Plugin:
For programming BIRT report, you need to install BIRT tools into Eclipse. You can see the instructions at:
report this ad
Install BIRT report tools into Eclipse
Sample database:
LearningSQL is a small database used commonly in the instruction of o7planning. The instruction of programming
BIRT report also uses data on this Database. You need to create this Database (It takes only 5 minutes) as the
following instruction:
Sample Oracle Database for Learning SQL
Sample SQL Server Database for Learning SQL
Sample MySQL Database for Learning SQL
JDBC Driver library for Databases (Oracle, MySQL, SQLServer) and its use:
Depending on the type of Database, you use the equivalent JDBC Driver library of that Database (It takes you 3
minutes to finish it), look at the instruction of download at:
JDBC Driver Libraries for different types of database in Java
4- Create BIRT Project
In Eclipse select:
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 3/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
File/New/Other...
report this ad
Enter Project name: report this ad
HelloBIRT
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 4/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
5- Create Data Source
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 5/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
Create a Data Source from JDBC, or XML,... In this document, we will create Data Source from JDBC connected
with LearningSQL database.
report this ad
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 6/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
Here I connect JDBC with LearningSQL database (on DB Oracle). However, other Database manipulation is carried out
alike.
report this ad
ojdbc6.jar is a JDBC Driver library for Oracle
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 7/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
“See more:
JDBC Driver Libraries for different types of database in Java
report this ad
report this ad
Check whether database LearningSQL has been connected or not.
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 8/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 9/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
6- Create dataset
report this ad
Enter:
Data Set Name: Account avail balance
report this ad
?
1 Select Acc.Open_Branch_Id
2 ,Bra.Name Branch_Name
3 ,Acc.Cust_Id
4 ,Cus.Address Cust_Address
5 ,Acc.Account_Id
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 10/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
6 ,Acc.Product_Cd
7 ,Acc.Avail_Balance
8 From Account Acc
9 ,Customer Cus
10 ,Branch Bra
11 Where Acc.Cust_Id = Cus.Cust_Id
12 And Acc.Open_Branch_Id = Bra.Branch_Id
13 Order By Acc.Open_Branch_Id
report this ad
report this ad
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 11/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 12/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
7- Create new Report
In Eclipse select:
File/New/Other...
report this ad
report this ad
File name: BranchReport01.rptdesign
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 13/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 14/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
8- Configuring the size of the report
We create a default report whose size is the same as that of an A4 paper.
report this ad
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 15/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
Select property:
Orientation: Landscape
report this ad
report this ad
Configuring Border:
You can also change other properties.
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 16/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
9- Interface Design (Header)
report this ad
report this ad
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 17/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 18/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
?
1 <H3>
2 Vietcombank
3 </H3>
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 19/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
?
1 <B>
2 <I>
3 For internal use only
4 </I>
5 </B>
report this ad
10- Design charts
report this ad
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 20/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 21/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 22/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 23/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 24/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 25/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 26/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 27/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
11- Run reports for the first time
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 28/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
12- Designing the body of the report
Raw data like the illustration below:
But we will design the report so that its display is more simple and eye-catching (As the below illustration)
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 29/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
We will carry out step by step.
Drag and drop Table icon into the screen of report.
report this ad
report this ad
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 30/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 31/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 32/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 33/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 34/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 35/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 36/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
13- Run report (2)
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 37/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
14- Edit style (1)
The report runs, but its interface is not beautiful. We need to adjust some styles.
report this ad
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 38/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 39/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 40/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
15- Run report (3)
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 41/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
16- Sub Total
report this ad
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 42/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 43/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 44/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
17- Run Report
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 45/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
View more Tutorials:
Report Programming
report this ad
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 46/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
report this ad
Report Programming
Install BIRT report tools into Eclipse
BIRT reporting Programming Tutorial for beginners
Install Jaspersoft studio into Eclipse - Visual design tool for JasperReports
JasperReport Tutorial for Beginners
Calling Jasper Report from Java Application
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 47/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
Newest Documents
HTML Hyperlinks
HTML Lists
HTML Images
HTML Tables
Installing Atom-Beautify
Starting with HTML
HTML Editors
Installing Atom HTML Preview
Introducing HTML report this ad
Introducing Javascript HTML5 Canvas API
o7planning.org
https://o7planning.org/en/10243/birt-reporting-programming-tutorial-for-beginners#a24692 48/48
