Introduction to BIRT Report Development (Otherwise known as BIRT, - - PowerPoint PPT Presentation

▶
introduction to birt report
SMART_READER_LITE
LIVE PREVIEW

Introduction to BIRT Report Development (Otherwise known as BIRT, - - PowerPoint PPT Presentation

Aug 13, 2022 473 likes •1.04k views

EclipseCon 2014 Introduction to BIRT Report Development (Otherwise known as BIRT, Basics, and Beyond) John Ward BIRT and Us Who am I? Who are you? Who am I? John Ward, BIRT user Actuate OEM BIRT Engineer - Expert Author:

slide-1
SLIDE 1

EclipseCon 2014 Introduction to BIRT Report Development (Otherwise known as BIRT, Basics, and Beyond)

John Ward

slide-2
SLIDE 2

BIRT and Us – Who am I? Who are you?

  • Who am I?
  • John Ward, BIRT user
  • Actuate OEM BIRT Engineer - Expert
  • Author: Practical Data Analysis and Reporting with BIRT
  • http://digiassn.blogspot.com
  • jward@actuate.com
  • Who are you?
  • Name, Company, technical background (C, SQL, Java, reporting…)
  • Experience with BIRT
  • What are you hoping to get out of today’s presentation?

2

2

slide-3
SLIDE 3

Please Do the Following Survey

  • https://www.surveymonkey.com/s/PXFC56C
  • Or the URL Shortened
  • http://goo.gl/UEW90s
  • Helps us to improve the product
slide-4
SLIDE 4

Evaluate This Session

Sign-in: www.eclipsecon.org Select session from schedule Evaluate:

1 2 3

slide-5
SLIDE 5

Other BIRT Talks

  • BEST PRACTICES WITH BIRT
  • 18 March 11:15 - 11:50
  • John Ward (that’s me =D)
  • Integrating BIRT – Choose Your Own Adventure
  • 19 March 16:15 - 16:50
  • Senior Kristopher Clark – Esq.
  • Creating Data Driven Web Apps with BIRT
  • 18 March 16:15 - 16:50
  • Michael Williams
  • ECLIPSE M2M TECHNOLOGIES IN ACTION – IOT SYSTEMS FOR

PEOPLE COUNTING WITH ECLIPSE KURA AND ECLIPSE BIRT

  • March 19, 2014 - 16:15 to 16:50
  • Marco Carrer [Eurotech]
slide-6
SLIDE 6

Shameless Plug

6

slide-7
SLIDE 7

… and those other guys books…

7

slide-8
SLIDE 8

Agenda Outline of class

  • BIRT
  • History
  • Guided Tour
  • The Report Perspective
  • Building Reports
  • Components
  • Exercise
  • Data
  • Exercise
  • Charts and Layouts
  • Exercise
  • Q&A
slide-9
SLIDE 9

What is BIRT

  • Brief history and background
  • Whos Behind It
  • Who uses it
slide-10
SLIDE 10

The BIRT Community at a Glance

  • Project Committers
  • Actuate (http://www.actuate.com)
  • IBM (http://www.ibm.com)
  • Inetsoft (http://www.inetsoft.com)
  • BIRT pages on Eclipse web site
  • http://www.eclipse.org/birt
  • Download BIRT and walk through a tutorial
  • BIRT Help
  • http://developer.actuate.com
  • Legacy: http://www.birt-exchange.org

12

slide-11
SLIDE 11

High Level BIRT Architecture

13

Report Designer Report Engine Presentation Services Report Design Engine XML Report Design Report Document

HTML PDF Print

Eclipse Report Designer Generation Services Data Transform. Services Charting Engine Data Data Chart Designer Eclipse DTP ODA Custom Designer

slide-12
SLIDE 12

Report Lifecycle (Simplified)

Initialize

Preparation Generation

slide-13
SLIDE 13

Report Perspective

  • Areas of Reporting perspective
slide-14
SLIDE 14

Report Designer

  • Area where report layout is designed, previews of the report are seen, scripts and events are

coded, and XML source for report can be viewed.

slide-15
SLIDE 15

Palette

  • Contains a number of visual

elements used in BIRT report designs

  • Similar to Toolboxes in MS Visual

Studio and other visual IDE

slide-16
SLIDE 16

Data Explorer

  • Contains.
  • Data Sources: Connections to

database.

  • Data Sets: Same as a Record set.

Allows users to navigate through Query Results.

  • Report Parameters: Used as the

interface for report parameters that will be passed to a Data Set.

slide-17
SLIDE 17

Navigator

  • Navigates through Eclipse projects

and files under those projects

  • Allows user to run report inside of

BIRT

slide-18
SLIDE 18

Outline

  • Provides hierarchy of current report
  • Allows for easy navigation of report

elements to change properties in the property pane

  • When selecting libraries, use the
  • utline to copy non-visual

components such as data sources and sets

slide-19
SLIDE 19

Property Editor

  • Properties Pane.
  • Properties for BIRT objects can be modified, such as Data Set Binding, Font information,

formatting for Data Set returns such as Row Highlighting and Color Alternation.

slide-20
SLIDE 20

The Guided Tour

slide-21
SLIDE 21

Elements of a Report Design

Data Sources Data Sets Body Master Page Header Footer Design Containers Report Items

slide-22
SLIDE 22

Containers

24

slide-23
SLIDE 23

Tables/Lists

  • Slots
  • Header
  • Detail
  • Footer
  • Data Binding
  • Makes table/list aware of values

in Data Set

  • Grouping
  • Group on value in Data Set
  • Sorting
  • Sort on value in Data Set
  • Rows
  • Columns
  • Cells

25

slide-24
SLIDE 24

Report Items

  • Label
  • Dumb, static
  • Text
  • HTML, RTF
  • Data
  • Smart, can be Dynamic, Expression Driven
  • Chart
  • Graphics for the small words and pictures crowd

(management)

  • Aggregation
  • Total, Sum, Avg
slide-25
SLIDE 25

Expressions

  • A lot of things in BIRT are based on them
  • Report Items
  • Properties
  • Outputs
  • Formatting
  • Small snippets of Javascript that return single values
  • You will see these everywhere
  • Anytime you start off with row[“ColumnName”], you are starting

with an expression.

  • Anywhere there is an expression editor.
slide-26
SLIDE 26

Exercise 1 – Introduction to BIRT Environment (30 minutes)

  • What you will learn
  • Get familiar with the

environment.

  • Learn basic report layout
  • Build basic report
slide-27
SLIDE 27

Introduction to Data Elements

  • What are the data elements?
  • Where do you access them?
  • How do they work?
slide-28
SLIDE 28

Data Access

  • Data Sources
  • Handled data connections
  • Data Sets
  • Defined Data to be used in Report
  • Parameters
  • Used for User Interaction to Filter

Data

  • Cascading Parameters
  • Parameter Binding

30

slide-29
SLIDE 29

Data Source Types

  • Out of the Box
  • JDBC
  • Web Service
  • Flat File
  • Scripted Data Source
  • Extensions
  • Anything BIRT doesn’t do out of the box
  • Data Cube
  • Analytics based on data sets
  • Lets you cut and slice data
slide-30
SLIDE 30

32

Exercise 2 – Working with Data (30 minutes)

Work with Data In a report Work with Flat File and Database driven reports Formatting Reports on a basic level

slide-31
SLIDE 31

33

Charting in Reports

  • Charts integrated with BIRT Report Designer
  • Charts can be used standalone as a library
  • Wide variety of chart types
  • Many formatting options
  • Charts are extensible to include more types
slide-32
SLIDE 32

34

34

Pie Charts

  • 2D, 2D with depth
  • Ratio, Explode slices, Min Slice
slide-33
SLIDE 33

35

35

Bar Charts

  • Horizontal, Vertical
  • 2D, 2D w/depth, 3D
  • Stacked, Side-by-side
  • Percent, Logarithmic
slide-34
SLIDE 34

36

Cones – Tubes – Pyramids

36

slide-35
SLIDE 35

37

37

Line Charts

  • Horizontal, Vertical
  • 2D, 3D
  • Various types of markers
  • Line styles, thicknesses
  • Drawn as Line, Curve
slide-36
SLIDE 36

38

38

Stock Charts

  • CandleStick / Bar Stick
  • Horizontal, Vertical
  • 2D
  • Formatting control
slide-37
SLIDE 37

39

39

Scatter Charts

  • Horizontal, Vertical
  • 2D
  • Various types of markers
  • Line styles, thicknesses
  • Drawn as Line, Curve
slide-38
SLIDE 38

40

40

Area Charts

  • Horizontal, Vertical
  • 2D, 2D w/depth, 3D
  • Stacked, Side-by-side
  • Percent, Logarithmic
  • Drawn as Line, Curve
slide-39
SLIDE 39

41

Difference/Range Charts

41

  • 2D. Curve or Straight lines.
  • New Negative/Positive Fill also works for other types.
slide-40
SLIDE 40

42

42

Meter Charts

  • 2D, formatting control
  • Regions, Needle styles, thicknesses
slide-41
SLIDE 41

43

Gantt Charts

43

  • 2D. Custom Bar width
  • Custom Start/End Markers
  • Data : Task ID / Start Date, End Date, Task Name
slide-42
SLIDE 42

44

Bubble Charts

  • 2D
  • Custom Bubble shape – Square, triangle, diamond, star, icon…

44

slide-43
SLIDE 43

3Rd Party Visualizations

slide-44
SLIDE 44

3rd Party Visualizations (cont)

slide-45
SLIDE 45

Formatting

  • Intrinsic Properties
  • At the level of the element itself
  • Overrides CSS
  • CSS
  • Used for applying a global style to reports
  • Cascades down.
  • Lowest element wins
  • Similar to HTML CSS, but not exactly the same
slide-46
SLIDE 46

Using styles

  • Defined in
  • Report design
  • Library
  • Separate CSS text file
  • Can use pre-defined element names or custom names
  • Ex.
  • .table { background : #FFFFFF }
  • Will apply to all tables in report
  • Use to keep look and feel of multiple reports consistent
slide-47
SLIDE 47

Using Intrinsic Properties

  • Very tempting to use since it is the first way you learn to set

styles

  • Only do it in small reporting projects
  • Tend to be more cumbersome to maintain
slide-48
SLIDE 48

Order of Application

Tab le (Font-Size = 8pt, defined in style) Row Cell Data (Style Defined Font Size: 7pt) Data (Style Defined Font Size: 7pt, Intrinsic 10pt)

slide-49
SLIDE 49

Exercise 3 – Charting and Advanced Formatting

  • Build some real

reports

  • Work with charts
  • Work with styles and

layouts

slide-50
SLIDE 50

Event handling

  • Working with the Report Lifecycle
  • Alters the flow of events
  • Used to do things like dynamically add elements to a report,

scripts data sources, and work with the chart engine

  • Very advanced topic!!
slide-51
SLIDE 51

Reuse and Teams

  • How do you re-use components?
  • What do you do when you work in a team so each member

isn’t duplicating the same data sources, data sets, and report headers?

  • How do you set up common starting points?
slide-52
SLIDE 52

Templates

  • A common starting point for report development.
  • Is basically a report design that is registered with the New

Report Wizard.

  • Can contains as little or as much as needed in order to start a

report

  • Data sources
  • Data sets
  • Report items and containers
  • Master page elements
slide-53
SLIDE 53

Libraries

  • Contains shared components
  • When a library item is updated, all dependent reports are

updated as well.

  • Requires deployment with reports.
slide-54
SLIDE 54

Deployment

  • Complex topic
  • Can deploy to J2EE containers, applications, or the BIRT Web

Viewer

  • Commercial Actuate has tools built in for handling this.
  • Can integrate BIRT engine into your application. See

“Integrating and Extending BIRT” for more information

  • Later sessions at EclipseCon will discuss this more in depth as

well.

slide-55
SLIDE 55

Extensions

  • Extremely complex topic
  • See “Integrating and Extending BIRT” for information on this

topic.

slide-56
SLIDE 56

Q & A (10 minutes)