Business Intelligence and Reporting Tools

Business Intelligence and Reporting Tools (BIRT) 2.2Jason Weathersby, BIRT PMCAgendaQuick OverviewQuick BIRT Demo2.2 FeaturesBIRT WTP Wizard DemoODA Wizard Demo3High Level BIRT ArchitectureReport DesignerReport Design EngineXMLReportDesignHTMLPDFDOCXLSPrintPSCSVReport EnginePresentationServicesGenerationServicesDataTransform.Services4ReportDocumentDataDataCustomDesigner1ChartingEngine5Eclipse DTPODA2Eclipse WTP3ChartDesigner5Eclipse ReportDesignerBIRT Introduction –The Quick TourThe BIRT PerspectiveData View, Palette, Outline View, Layout, Code, PreviewBIRT DataData Sources, Data Sets, ParametersBIRT LayoutGrids, Tables, Controls, Data BindingBIRT CodeExpression Builders vs. Code PagesBIRT PreviewHTML View, BIRT Viewer, PDF Viewer, DOC Viewer…Deploying BIRTJ2EE Deploy, RCP Deploy, OtherBIRT PerspectiveBIRT Perspective •Report•Template•LibraryBIRT Projects•Report Project•ODA Designer•ODA Runtime •New Web ProjectBIRT ViewsData Explorer View •Extensible Data Sources –Flat File, XML, Web Services, JDBC, Scripted.•Data Sets –SQL Query, Stored Procedures, Joint Data Sets.•Parameters –Cascaded, Dynamic, Static.Palette View •Extensible –Extensions provided to add new elements.•Report Elements used in constructing a Report.Library Explorer View •Reusable Report Elements.•Dynamic reference.Outline View •Hierarchal view of report.•Quick Navigation.BIRT Views ContinuedReport Editor •Layout –Report Canvas for element drag and drop.•Master Page –Headers, Footers, Margins and Orientation. Multiple master page support.•Script –Quick access to event handler scripts for selected report element.•XML Source –XML for report design.•Preview –Quick view of report HTML output.Properties •Gui -for common properties (ie, Localization, Style, TOC).•Binding –Data Set container binding.•Sorting –Sort data inside the given element.•Groups –Quick access to add/modify groups.•Map –Conditional Data presentation.•Highlights –Conditional styling.•Filter –Complex filtering of data within the container.Example BIRT ViewerBIRT Viewer •AJAX Based.•Parameter Discovery.•J2EE Application (Application Server Deployment).•Eclipse Plugin (RCP deployment).•Report Engine API (Java Application Deployment).BIRT Report Development DemoBIRT 2.2 Feature HighlightsEclipse 3.3 SupportDynamic CrossTabWeb Services Data SourceBetter Flat File Data SourceODA Project WizardDynamic Reference to Connection ProfileWord, Excel and Postscript EmittersMore references to styles, including external CSS filesImproved XML EditorImproved JavaScript Editor, with DebuggingWTP Project WizardJSP Tag libraryNew Chart typesBIRT Web ProjectBIRT Viewer TagBIRT Requestor TagBIRT Report TagBIRT ODA ProjectWord Emitter –XLS, PS On the wayNew Examples ViewBIRT WTP Project Wizard DemoODA Project Wizard DemoQuestions?Suggestions Comments QuestionsJason Weathersby (jweathersby@actuate.com)