Details zum E-Book

Pentaho Reporting 3.5 for Java Developers. Create advanced reports, including cross tabs, sub-reports, and charts that connect to practically any data source using open source Pentaho Reporting

Pentaho Reporting 3.5 for Java Developers. Create advanced reports, including cross tabs, sub-reports, and charts that connect to practically any data source using open source Pentaho Reporting

Lance Walter, Will Gorman

E-book
Pentaho Reporting lets you create, generate, and distribute rich and sophisticated report content from different data sources. Knowing how to use it quickly and efficiently gives you the edge in producing reports from your database. If you have been looking for a book that has plenty of easy-to-understand instructions and also contains lots of examples and screenshots, this is where your search ends.
This book shows you how to replace or build your enterprise reporting solution from scratch with Pentaho's Reporting Suite. Through detailed examples, it dives deeply into all aspects of Pentaho's reporting functionalities, providing you with the knowledge you need to master report creation.
This book starts off with a number of examples to get you familiar with the tools and technology of the Pentaho Reporting Suite. Then, with additional examples, it goes into advanced subjects such as charting, sub-reporting, cross tabs, as well as API generation of reports. There are also details and examples on extending Pentaho's open source reporting engine. The reader will learn the ins and outs of Pentaho Report Designer, including a cheat sheet with all the available short-cut keys, to make report design efficient and painless.
Embedding reports into your Java application can be difficult. With Pentaho Reporting it's just a few lines of code. The book provides examples of how to embed reporting into your J2EE and client Java applications, as well as showing you how to build dynamic reports from scratch using Pentaho Reporting's simple Java Bean-based report generation API.
Setting up and integrating a reporting server in an enterprise environment can be arduous. In addition to learning how to build great embeddable reports, you'll also learn how to combine Pentaho Reporting with Pentaho's BI Server for a zero-code, easy-to-configure, enterprise reporting solution.
  • Pentaho Reporting 3.5 for Java Developers
    • Pentaho Reporting 3.5 for Java Developers
    • Credits
    • Foreword
    • About the Author
    • About the Reviewers
    • Preface
      • What this book covers
      • Who this book is for
      • Conventions
      • Reader feedback
      • Customer support
        • Downloading the example code for the book
        • Errata
        • Piracy
        • Questions
    • 1. An Introduction to Pentaho Reporting
      • Typical uses of Pentaho Reporting
        • Operational reporting
        • Business intelligence reporting
        • Financial reporting
        • Production reporting
      • Pentaho Reporting history
        • Pentaho Reporting timeline
      • Feature overview
        • An advanced reporting algorithm
        • A multitude of available data sources
        • A wide variety of output formats
        • Pixel accurate rich formatting
        • Embedded charts
        • Report parameterization
        • Formulas and style expressions
        • Sub-reports
        • Cross Tab Reports
        • Interactive reporting
        • Rich authoring tools
        • Reporting server
        • Java API for building reports
        • Extensibility
        • A business friendly open source license
        • Pentaho reporting roadmap
      • Pentaho Reporting architecture
        • LibBase
        • LibDocBundle
        • LibFonts
        • LibFormat
        • LibFormula
        • LibLoader
        • LibRepository
        • LibSerializer
        • LibXml
        • Report Engine Core
        • Report Engine Extensions
      • Summary
    • 2. Pentaho Reporting Client and Enterprise Examples
      • Pentaho Reporting and example prerequisites
      • Setting up Pentaho Reporting
      • Building your first report
        • Report Designer introduction
        • Creating and configuring your first data source
        • Report layout
          • Creating the report title
          • Creating column headings
          • Populating the details band
          • Creating a report summary
          • Previewing and saving your report
      • Embedding your report in a Swing application
        • Setting up the Swing example application
        • Incorporating Pentaho Reporting into the application
      • Embedding your report in an enterprise web application
        • Setting up the example Tomcat application
        • Incorporating Pentaho Reporting into the web application
        • Adding additional output formats
      • Summary
    • 3. Pentaho Reporting Examples in the Real World
      • Setting up the example data source
      • ElectroBarn inventory report
        • Configuring the data source
        • Creating a query
        • Creating the Report Header and Page Footer
        • Defining the Group Header
        • Defining the Details band
        • Defining the Group Footer and the Report Footer band
        • Adding a pie chart
        • Incorporating the inventory report into your J2EE environment
          • Adding re port selection as an input to the servlet
          • Compiling and deploying the report servlet
      • End of the day cashier balances
        • Configuring an input parameter
        • Configuring the data source query
        • Creating the Report Header and Page Footer
        • Defining the Details band
        • Defining the Group bands
        • Defining the main Group Header
        • Incorporating the End of Day report into your J2EE environment
      • ElectroBarn invoice example
        • Configuring the data source query
        • Defining the Group Header
        • Defining the sub-report
        • Defining the Details band
        • Defining the Group Footer and Page Footer
        • Incorporating the invoice report into your J2EE environment
      • Summary
    • 4. Design and Layout in Pentahos Report Designer
      • Report Designer user interface components
        • Menu and toolbar
        • Report element palette
        • Report canvas tab panel
        • Report Explorer
        • Element Properties
        • Messages
      • Report bands
        • Common properties
          • Size and position properties
          • Padding and border properties
          • Page behavior properties
          • Foreground and background color properties
          • Excel properties
          • Attribute properties
          • Style inheritance
        • Page Header and Page Footer
        • Report Header and Report Footer
        • Group Header and Group Footer
        • Details Body
        • Watermark
      • Report elements
        • Common properties
        • Common text properties
          • Font style properties
          • Text style properties
          • Text spacing properties
          • Link properties
          • Excel properties
        • label
        • text-field
        • message
        • number-field
        • date-field
        • resource-label
        • resource-message
        • resource-field
        • chart
        • content (static image)
        • content-field (dynamic image)
        • rectangle
        • ellipse
        • horizontal-line and vertical-line
        • band
        • sub-report
        • survey-scale
        • line-sparkline
        • bar-sparkline
        • pie-sparkline
        • simple-barcodes
      • Visual layout in Report Designer
        • The Grid
        • Guide lines
        • Additional visual indicators
        • Moving and aligning single elements
        • Ali gning groups of elements
        • Miscellaneous layout capabilities
      • Pentaho Report Designer shortcut keys
      • Working with fonts
      • Considerations for different output formats
        • Cell output
        • Paging
        • Limits to rich graphics and charts
      • Summary
    • 5. Working with Data Sources
      • Pentaho Reporting Engine Data API
        • The DataFactory interface
        • The ContextAwareDataFactory interface
        • The TableModel interface
        • DataFactory serialization
        • Additional data source metadata
      • Existing DataFactory implementations
        • TableDataFactory
        • NamedStaticDataFactory
          • Query syntax
          • NamedStaticDataFactory example
        • SQLReportDataFactory
          • StaticConnectionProvider
          • DriverConnectionProvider
          • JndiConnectionProvider
          • SQLReportDataFactory example
        • XPathDataFactory
          • XPathDataFactory example
        • HQLDataFactory
          • StaticSessionProvider
          • DefaultSessionProvider
          • HQLDataFactory Example
        • PmdDataFactory
          • XMI file
          • Domain Id
          • IPmdConnectionProvider
          • Registering MQL Queries
          • PmdDataFactory example
        • KettleDataFactory
          • KettleDataFactory example
        • BandedMDXDataFactory
          • BandedMDXDataFactory example
        • DenormalizedMDXDataFactory
        • CompoundDataFactory
        • Experimental data factories
      • Accessing data throughout a report
      • Summary
    • 6. Including Charts and Graphics in Reports
      • Supported charts
        • Common chart rendering properties
        • Common category series rendering properties
        • Common XY series rendering properties
        • Common dataset properties
        • Common category series dataset properties
        • Common XY series dataset properties
        • Area chart
          • Area chart example
        • Bar chart
          • Bar chart example
        • Line chart
          • Line chart example
        • Pie chart
          • Pie chart example
        • Ring chart
          • Ring chart example
        • Multi pie chart
          • Multi pie chart example
        • Waterfall chart
          • Waterfall chart example
        • Bar line chart
          • Bar line chart example
        • Bubble chart
          • Bubble chart example
        • Scatter chart
          • Scatter chart example
        • XY Area, XY Bar and XY Line charts
          • XY charts example
        • Extended XY Line chart
          • Extended XY Line chart example
        • Radar chart
          • Radar chart example
      • Including static images in your report
      • Including dynamic images in your report
      • Summary
    • 7. Parameterization, Functions, Formulas, and Internationalization in Reports
      • Report parameterization
        • Providing report parameters
        • Available report parameter types
      • Working with functions and expressions
        • Common functions
        • Report functions
        • Summary functions
        • Running functions
        • Advanced functions
        • Image functions
        • Script functions
      • Working with formulas
        • Formula syntax
        • Formula data types
        • Formula operators
        • Formula functions
          • Date time functions
          • Logical functions
          • Mathematical functions
          • Text functions
          • Reporting Specific functions
          • Miscellaneous functions
      • Internationalization and localization of reports
        • Localizing fields
        • Localization example
      • Summary
    • 8. Adding Sub-Reports and Cross Tabs to Reports
      • Adding sub-reports
        • Multi-page sub-report example
        • Chart sub-report example
        • Side-by-side sub-report example
      • Adding cross tabs
        • Cross tab MDX example
        • Cross tab SQL example
        • Multiple row and column cross tab example
      • Summary
    • 9. Building Interactive Reports
      • Interactive reports in Swing
        • Registering event callbacks
          • ReportHyperlinkListener
          • ReportActionListener
          • ReportMouseListener
        • Interactive Swing example
      • Interactive reports in HTML
        • Interactive HTML report properties
        • Manipulating the reporting HTML DOM
        • Including an external CSS or JavaScript resource
        • Interactive HTML example
          • Adding interactive elements to the dashboard
      • Summary
    • 10. API-based Report Generation
      • Understanding the serialized report format
        • settings.xml
        • datadefinition.xml and the datasources folder
          • Parameters
          • Data source reference
          • Functions and expressions
        • Data sources folder
        • layout.xml
          • Group and detail band hierarchy
          • Report elements
          • Example layout.xml file
        • styles.xml
          • Example styles.xml file
        • Additional required files
        • Building and running a .prpt bundle example file
      • Building a report using Pentaho Reporting's Java API
        • Adding a data source
        • Defining parameters
        • Including functions and expressions
        • Defining the report's layout
          • Common report bands
          • Group band hierarchy
        • Adding elements to the report
        • Java API example
      • Wizard Java API
      • Summary
    • 11. Extending Pentaho Reporting
      • Implementing report functions and expressions
        • Implementing expressions
          • Defining an expression class
          • Defining expression metadata
          • An example expression
        • Implementing functions
      • Implementing a formula function
        • Regex formula function example
      • Implementing BeanShell expressions
        • Example BSHExpression
      • Implementing a report element
        • Defining an ElementType class
        • Defining element metadata
        • Defining read and write handlers
        • An example report element
      • Summary
    • 12. Additional Pentaho Reporting Topics
      • Using Pentaho Reporting with Pentaho's Business Intelligence Server
        • Downloading and Installing the BI Server
        • Publishing a report to the BI Server
        • Scheduling reports
        • Configuring permissions
        • Report emailing and bursting
        • Managing database connections and users
        • Creating ad hoc reports
      • Mobile reporting
        • Mobile report server
        • Mobile report design
        • Example: Pentaho's iPhone BI extension
      • Data source metadata in Pentaho Reporting
        • MetaTableModel API
        • Mapping external metadata
        • Using metadata attributes in a report
        • Current MetaTableModel implementations
        • Metadata example: DefaultMetaTableModel
      • Working with Pentaho Reporting's output layer
        • The OutputProcessorMetaData interface
        • The OutputProcessor interface
        • RenderNode Document Object Model
        • Updating Report Designer
        • Example: PojoObject output
      • The Pentaho communitygetting help and contributing
        • Asking questions, helping others
        • Online documentation
        • Submitting bugs and viewing backlogs
        • Contributing code
        • Enterprise support
      • Summary
  • Titel: Pentaho Reporting 3.5 for Java Developers. Create advanced reports, including cross tabs, sub-reports, and charts that connect to practically any data source using open source Pentaho Reporting
  • Autor: Lance Walter, Will Gorman
  • Originaler Titel: Pentaho Reporting 3.5 for Java Developers. Create advanced reports, including cross tabs, sub-reports, and charts that connect to practically any data source using open source Pentaho Reporting.
  • ISBN: 9781847193209, 9781847193209
  • Veröffentlichungsdatum: 2009-09-07
  • Format: E-book
  • Artikelkennung: e_3crf
  • Verleger: Packt Publishing