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)
[Link] 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.
[Link] 2/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
** SQL **
?
1 Select Acc.Account_Id
2 ,Acc.Cust_Id
3 ,[Link] Cust_Address
4 ,Acc.Product_Cd -- Product Code (Service of Bank)
5 ,Acc.Open_Branch_Id -- Branch (of Bank)
6 ,[Link] 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:
[Link] 3/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
File/New/Other...
report this ad
Enter Project name: report this ad
HelloBIRT
[Link] 4/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
5- Create Data Source
[Link] 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
[Link] 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
[Link] is a JDBC Driver library for Oracle
[Link] 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.
[Link] 8/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
[Link] 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 ,[Link] Branch_Name
3 ,Acc.Cust_Id
4 ,[Link] Cust_Address
5 ,Acc.Account_Id
[Link] 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
[Link] 11/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
[Link] 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: [Link]
[Link] 13/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
[Link] 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
[Link] 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.
[Link] 16/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
9- Interface Design (Header)
report this ad
report this ad
[Link] 17/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
[Link] 18/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
?
1 <H3>
2 Vietcombank
3 </H3>
[Link] 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
[Link] 20/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
[Link] 21/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
[Link] 22/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
[Link] 23/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
[Link] 24/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
[Link] 25/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
[Link] 26/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
[Link] 27/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
11- Run reports for the first time
[Link] 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)
[Link] 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
[Link] 30/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
[Link] 31/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
[Link] 32/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
[Link] 33/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
[Link] 34/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
[Link] 35/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
[Link] 36/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
13- Run report (2)
[Link] 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
[Link] 38/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
[Link] 39/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
[Link] 40/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
15- Run report (3)
[Link] 41/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
16- Sub Total
report this ad
[Link] 42/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
[Link] 43/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
[Link] 44/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
report this ad
17- Run Report
[Link] 45/48
22/08/2019 BIRT reporting Programming Tutorial for beginners
report this ad
View more Tutorials:
Report Programming
report this ad
[Link] 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
[Link] 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
[Link]
[Link] 48/48
