Basic BIRT Report Development.ppt

1、Basic BIRT Report Development,John Ward, Innovent Solutions,2,2,BIRT and us Who are I? Who are you?,Who are we? John Ward, BIRT user Innovent Solutions Author: Practical Data Analysis and Reporting with BIRTWho are you? Name, Company, technical background (C, SQL, Java, reporting) Experience with BI

2、RT What are you hoping to get out of todays presentation?,3,Agenda,BIRT Overview Lesson 1 Simple Reports Lesson 2 Charting in Reports Lesson 3 BIRT Scripting Lesson 4 Report Libraries and Templates Lesson 5 Deploying with the Web Viewer,4,Objectives,Become Familiar with BIRT Designer Know how to cre

3、ate and design BIRT reports and projects Access Data in BIRT Reports Report Layout and Formatting Using Styles Sort, Group Data Use Report Parameters Create and Format Charts Write Expressions Using Scripting Creating and Using Libraries and Templates Deploy BIRT Reports,5,5,Easy Hard,Presentation F

4、ocus,BIRT Tasks Audience,BIRT Report DevelopersAdvanced BIRT DevelopersDeploy ExpertsReporting Integration BIRT ExtensionBIRT Core Development,Drag & Drop, Charting, PropertiesBIRT ScriptingBIRT ViewerDesign Engine APIBIRT Extension PointsEclipse Development,6,BIRT Target Users & Benefits,Embed pre-

5、designed reports in application Designs reports using Eclipse-based designer Creates report libraries & templates,Powerful and easy to use report designer Creates & uses report libraries & templates,Focused on $, developer productivity End user satisfaction,Quick availability of reports Reports that

6、 also look good Content as HTML and PDF,Reports that support business activities Ever changing business requirements,Minimizes Eclipse developer training Increase developer productivity Lower costs,Saves calories vs. JSP/Java Minutes vs. days for HTML, vs. weeks for PDF Minutes to modify as user req

7、uirements change Iterative development gets the right reports quicker,Managers,End Users,Report Developers,Java Developers,Flexible, web page design metaphor Ability to leverage complex components,7,Report Designer,High Level BIRT Architecture,Report Engine,Presentation Services,Report Design Engine

8、,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,Reporting,Objectives: Become Familiar with BIRT Workbench To create a BIRT Reporting Project To create a BIR

9、T Report Introduce the BIRT Workbench Create a simple Product Profitability & Inventory Report End User Customizing via Report Parameters,9,9,The Quick Tour,The BIRT Perspective Data View, Palette, Outline View, Layout, Code, Preview BIRT Data Data Sources, Data Sets, Parameters BIRT Layout Grids, T

10、ables, Controls, Data Binding BIRT Code Expression Builders vs. Code Pages BIRT Preview HTML View, BIRT Viewer, PDF Viewer,10,Birt Designer,Graphical report designer, similar to web development applications such as Dreamweaver or NvuProvides visual environment to quickly “draw” reportsProvides mecha

11、nisms to quickly create data connectionsProvides Project Management,11,Workbench,Navigator,Navigates through Eclipse projects and files under those projects Allows user to run report inside of BIRT,Outline,Provides hierarchy of current report Allows for easy navigation of report elements to change p

12、roperties in the property pane When selecting libraries, use the outline to copy non-visual components such as data sources and sets,Palette,Contains a number of visual elements used in BIRT report designs Similar to Toolboxes in MS Visual Studio and other visual IDE,Data Explorer,Contains. Data Sou

13、rces: Connections to database. Data Sets: Same as a Recordset. Allows users to navigate through Query Results. Report Parameters: Used as the interface for report parameters that will be passed to a Data Set.,Report Designer,Area where report layout is designed, previews of the report are seen, scri

14、pts and events are coded, and XML source for report can be viewed.,Areas of the BIRT Workspace (Cont.),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.,18,Top Leve

15、l Report Layout,Master Pages Contains elements visible on every page, such as page headersGrids Used to position elements on page Contains no Data BindingsTables Grids with Data Binding Has Header, Detail, and Footer bandsLists Single Column Tables,19,Demo Static Report,Background: Our Manager, Mr E

16、rnie, wants a generic letterhead.Build a letter head for Classic Cars using containers to format the layout.Objectives: Familiarize you with the concept of containers for Report Elements,Setting up a Project,BIRT uses the eclipse paradigm of using projects File/new/project From the project wizard, s

17、elect report project from under BIRT Set project name Projects are shown in the eclipse navigator,Setting up a Report,With eclipse project open From file menu File/new/report From navigator Right-mouse click on report project, new/report Select project to associate report with and give file name,22,

18、Containers,23,Data Access,Data Sources Handled data connectionsData Sets Defined Data to be used in ReportParameters Used for User Interaction to Filter Data Cascading ParametersParameter Binding,Setting up JDBC,Setup is done via the Data Explorer when setting up a new data source. Click on the “man

19、age drivers” button. Point to JDBC ZIP/JAR file. In order to set up connection, you must know the JDBC URL. Can set a template of the JDBC URL format for future use of driver. This makes it easier for future connections. Datasources can be added to libraries for report projects that use consistent d

20、atasources.,Creating a Data Set,With data source(s) created, right-click on data set and chose new. Type in SQL query. Can create Joined Data Sets to combine 2 or more data sources. Here I am using a questionmark, which will bind a report parameter to a query. Datasets can be added to libraries. htt

21、p:/ Parameters,Used to create dynamic result sets from queries Binds user input to filter results sets Parameters get assigned in sequential order, first parameter gets assigned to first bind variable in query Report Parameters get stored as global variables in reports, accessible in scripts and exp

22、ressions in addition to data.,27,Tables,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,28,Styles,Built InCSSThemes,29,Aggregates,Aggregate operations Sum Avg Count Done at the binding level,30

23、,Viewing Reports,PreviewWeb ViewerEmitters,Report Run,Can Run from Navigator or from File Menu Reports that get run open in separate browser window. Results can be saved. Option to view as HTML, Word, Excel, PDF,32,Demo Building Reports - Product Profitability Report,Scenario: You work for the Class

24、ic Cars company. Your boss, Mr Ernie, wants a report that is a simple listing of all product sales in the database, with the total costs and total profits for each product arranged by State and City, sorted in order of decreasing amounts of total profits. Provide a report parameter to limit the list

25、ing to just 1 state. Make sure that the parameter only lists those states already in the database.Objective: To Familiarize ourselves with building reports with Data awareness and work with data.,33,Demo Product Profitability Report,Bring up Eclipse Open the BIRT Perspective In the Navigator View cr

26、eate a BIRT Report Project In the Project create a BIRT Report Add a data source to the Classic Models Sample database Add a data set to list products, total costs, total profits Add report items Format report Group items Sort items Add report parameters Add data set parameters Preview,Lesson 2 Char

27、ting in Reports,35,Basic Concepts Charting in Reports,Charts integrated with BIRT Report DesignerCharts can be used standalone as a libraryWide variety of chart typesMany formatting optionsCharts are extensible to include more types,36,36,Pie Charts,2D, 2D with depth Ratio, Explode slices, Min Slice

28、,37,37,Bar Charts,Horizontal, Vertical 2D, 2D w/depth, 3D Stacked, Side-by-side Percent, Logarithmic,38,Bar Charts,38,39,Cones Tubes Pyramids,39,40,40,Line Charts,Horizontal, Vertical 2D, 3D Various types of markers Line styles, thicknesses Drawn as Line, Curve,41,41,Stock Charts,CandleStick / Bar S

29、tick Horizontal, Vertical 2D Formatting control,42,42,Scatter Charts,Horizontal, Vertical 2D Various types of markers Line styles, thicknesses Drawn as Line, Curve,43,43,Area Charts,Horizontal, Vertical 2D, 2D w/depth, 3D Stacked, Side-by-side Percent, Logarithmic Drawn as Line, Curve,44,Difference/

30、Range Charts,44,2D. Curve or Straight lines. New Negative/Positive Fill also works for other types.,45,45,Meter Charts,2D, formatting control Regions, Needle styles, thicknesses,46,Gantt Charts,46,2D. Custom Bar width Custom Start/End Markers Data : Task ID / Start Date, End Date, Task Name,47,Bubbl

31、e Charts,2D Custom Bubble shape Square, triangle, diamond, star, icon,47,48,Data Binding in Charts,Bind through Data SetBind through Report Element,49,Interactivity in Charts,Can jump to anchor pointsDrill Through to other ReportsInteractivity through Javascript,50,Demo Charting in Your Report,Scena

32、rio: Mr. Ernie wants a report that is a simple listing of all products in the database, with the number of units in stock. Arrange the products for each Product Line and sorted the products in each product line in decreasing order of total inventory. Your boss would also like to only list those prod

33、ucts with a minimum quantity in stock. Provide a report parameter to limit the output to those products with a quantity in stock greater than that specified in the report parameter.Add a Pie chart to this report to list products and their inventory.,51,Demo Charting in Your Report,Start with the Pro

34、duct Listing report. Select Product Line grouping row Insert row below titles Merge cells Insert chart Select Pie chart, SVG output Inherit data from container Category Product Name, group; Value Quantity In Stock, aggregate by Sum() Format chart,52,Demo Charting in Your Report Final Output,Lesson 3

35、 Scripting in a BIRT Report,Objectives: To build simple expressions for highlightingTo build JavaScript scripts,Scripting,For some logical calculations and report-centric tasks, a JavaScript based scripting engine has been embedded into BIRT. Report events can be overridden to implement custom actio

36、ns, such as creating calculated fields on row retrieval from a dataset.Variables can be declared and used persistently throughout reports through scripting mechanism. http:/ presentation more focused on Scripting: “Advanced BIRT Report Customization” tell Virgil and Jason that I sent you ;),55,Scrip

37、ting Background,Do you know Javascript?Do you know Java?,56,BIRT Utilizes the Mozilla Rhino Javascript engine. All the features of JavaScript 1.5 BIRT Script allows for use of Java classes and methods (regular expression, searches, etc) as well as custom Java objects Event Handlers can be external J

38、ava objects, not just Javascript,BIRT,Awesome!,Simple, 1 line expressions Used in data elements to return single result Used in visual elements as a simple condition or to retrieve display values,Triggered by Events in BIRT onOpen onRender Fetch Complex, multi line statements Contain advanced logic

39、to manipulate BIRT elements Can reference and set external elements Can invoke external Java objects,58,Demo Expressions,Scenario: Ernie wants a Employee Sales Performance Report. Have a chart to show employee sales against a quota, and create a computed column for grouping.Objective: Demonstrate ba

40、sic expression in Data Elements, complex expressions in the computed column and groupings.,59,Scripting/Event Handling (Simplified),Handlers are called for particular events Handlers are methods Code to do task is placed in the method Can be externalized in Java objects http:/www.eclipse.org/birt/ph

41、oenix/deploy/reportScripting.php#javaevents,60,Demo Using Java Scripted Data Source,Scenario: A request has come through from the Java developers to create a method to list all the Java environment variables to assist in application development.Objective: Give a quick overview of the Scripting event

42、 model by creating a scripted data source.,61,Demo Using Java Scripted Data Source,Create a scripted data source object Create a scripted data set 3 data fields: Name, Value, Type In Open Method Assign the Packages.java.lang.System.getProperties() to a variable. Get iterator from the entrySet().iter

43、ator() method. In Fetch Method while (propIter.hasNext() entry = propIter.next();rowpropName = entry.getKey();rowpropValue = entry.getValue();return true;return false; Add data grid,Lesson 4 Libraries and Templates,Objectives: To use & build BIRT Report Libraries in building reports To use & build B

44、IRT Report Templates,63,Basic Concepts - Libraries,Enables collaboration in report development, speeds up report design Large #s of report developers, or, large #s of reports Many designs use same elements, or layouts Stores report items shared between multiple developers/reports Use multiple librar

45、ies in a report design Changes to report items in library reflected in all report designs Open design in designer Generate report Group related styles into a theme Can convert a report design into a report library File extension - .rptlibrary Define resource folder location in Window-Preferences-Rep

46、ort Design-Resource,64,Demo Using a BIRT Library,Create BIRTLib.rptlibrary to Workspace Refresh project Open BIRTLib.rptlibrary Publish library to resource folder Copy visual items to report editor Copy data sets to report Outline view Preview Change a report item in library Preview,65,Basic Concept

47、s Templates,Serve as starting points for speedy report development Template captures visual relationships of report items Degree of completed template depends on requirements Can use report libraries in template Design of template is similar to report design Define template location in Window-Prefer

48、ences-Report Design-Template,66,Demo Creating a Template,Create New Template in similar fashion to a report design Specify display name, description, image Design template just as a report design Register Template with New Report wizardOpen existing report. Save as Template.,Lesson 5 Deploying with

49、the Web Viewer,Objectives: To deploy BIRT Reports in Tomcat Discuss other Deployment Options,68,Traditional Report Deployment Strategies,Burst reports Took lots of resources Online Reports None BI based solutions Cumbersome and time consuming to develop Error prone No consistent interfaces,69,Online Report Deployment,Using BI Based Solutions Rapid Deployment Available to global audience Ability to deploy to a number of commonly used formats,