Pentaho Reporting Video Course


I would like to recommend this excellent video course created by my friend Francesco Corti and officially reviewed by Paul Hernandez and me.

Pentaho Reporting [Video]

http://www.packtpub.com/pentaho-reporting/video

Screenshots:

Course Contents:

    1. Getting Started with Pentaho Reporting [15:57 minutes]
      • Installing Pentaho Reporting
      • Loading and Saving Reports and Having a Preview
      • Building a Report Using the Report Wizard
      • Building the ‘My First Report’
      • Customizing the ‘My First Report’
      • Advanced Customization on the My First Report

 

    1. Dive Deeper into the Pentaho Reporting Engine’s XML and Java APIs [11:44 minutes]
      • Setting the Java Development Environment
      • Embedding a Pentaho Report in an Enterprise Web Application
      • Embedding a Pentaho Report in a SWING Application
      • Introducing Serialized Reports
      • Building a Report Using Pentaho Reporting’s Java API

 

    1. Configuring the JDBC Database and Other Data Sources [12:43 minutes]
      • Configuring Your Data Source to a DBMS Using JDBC
      • Configuring Your Data Source to an OLAP Engine (Mondrian)
      • Configuring Your Data Source to an XML File and a Table
      • Configuring Your Data Source to Metadata and PDI
      • Working with Data Sources in Java

 

    1. Introducing Graphic Chart Types – Pie, Bar, Line, and Others [10:36 minutes]
      • Incorporating a Line Chart into a Pentaho Report
      • Incorporating Supported Charts and Common Properties
      • Incorporating and Customizing Charts into a Report
      • Incorporating Images into a Report

 

    1. Modifying Reports Using Parameters and Internationalization [11:14 minutes]
      • Parameterizing a Pentaho Report
      • Parameterizing a Pentaho Report Using Java
      • Working with Functions and Expressions
      • Working with Formulas
      • Internationalization and Localization of Pentaho Reports

 

    1. Adding Subreports and Cross Tabs in Your Reports [09:52 minutes]
      • Adding a Multi-page Subreport in a Pentaho Report
      • Parameterizing and Adding Chart Subreport in a Pentaho Report
      • Adding a Side-by-Side Subreport in a Pentaho Report
      • Adding Cross Tabs in a Pentaho Report

 

    1. Building Interactive SWING and HTML Reports [12:29 minutes]
      • Building Interactive Reports in SWING
      • Building Interactive Reports in HTML

 

  1. Using Pentaho Reporting in the Pentaho Suite [13:10 minutes]
    • Using Pentaho Reporting with Pentaho Business Intelligence Server
    • Using Pentaho Reporting with Pentaho Data Integration (Kettle)

What you will learn from this video course

  • Install Pentaho Report in your development or production environment
  • Create impressive reports with advanced charts, interaction, multi-language support and much more
  • Use the Pentaho Report Engine in your Java environment for web and swing applications
  • Interact and customize your Pentaho reports using Java (in a web and swing application)
  • Develop your basic and advanced reports using several datasources comprised of the OLAP Engines
  • Deploy and use your Pentaho Reports inside the Pentaho suite, in particular in the Pentaho Business Intelligence Server and the Pentaho Data Integration

Who this video course is for

If you are a Java developer or IT professional who wants to assemble custom reporting solutions with Pentaho Reporting, this video course is ideal for you. Master the advanced concepts within Pentaho Reporting such as sub-reports, cross-tabs, data source configuration, and metadata-based reporting.

In Detail

Pentaho Report Designer is one of the most important core modules of the Pentaho BI Suite, that builds impressive reports using Open Source Business Intelligence Solutions . Pentaho Report Designer helps you to develop professional applications, making them interact with a multi-language support as well as parameterized reports.

You will learn exactly how to develop basic and advanced reports using the Pentaho Report Designer environment, and a more customized Java environment. All of the examples are described in-depth with the source code, and you will be guided through this book using a step-by-step approach which will ensure that you’ll achieve impressive results.

This course begins with the installation of the Java Development Environments using practical examples, moving onto how to develop impressive reports using tables, charts and sub-reports. The examples will also be shown in a Java development environment for web and swing applications.

Next, you will be taken on a practical run through the Pentaho Report Designer. This guide will then explain Java APIs, data source connections, and the development of several chart types. You also learn the most relevant, advanced features needed to make a report , such as internationalization, parameterization, interaction, functions, expressions, sub-reports and cross-tabs, leading the way to the use of reports in the Pentaho Suite (especially in the Pentaho BI server and Pentaho Data Integration).

With the Pentaho Report basic and advanced development video course, you’ll get in touch with the enterprise development of reports, with one of the most relevant Open Source Business Intelligence solutions.

Pentaho Report Designer Tips Collection


Set encoding for PDF exports

Tired of  errors in character set PDF export… here is a little help.

File –> Configuration –> output-pageable-pdf –> Enable .Encoding checkbox and set for example  ISO-8859-1 character set as value

 

Set Locale for using in date message-fields

Writes multiple data types (text, string field, date field, and numeric field) into one object. We may have a message field including date with the following value $(report.date,date,EEEE, d MMMM yyyy HH:mm) and we want to change development locale, here is how you can modify it.

File –> Configuration –> core-module  –> Enable .environment.designtime.Locale and set for example  es_ES as value for Report Designer development stage locale

 

Set CSV export separator character

File –> Configuration –> output-table-csv –> Enable .Separator and set for example  ; as value to override default , character

Easy way to pass down all parameters to Pentaho subreports


Reblog from http://diethardsteiner.blogspot.co.uk/2014/01/easy-way-to-pass-down-all-parameters-to.html

Easy way to pass down all parameters to Pentaho subreports
At yesterday’s Pentaho London User Group (PLUG) meetup I discussed with Thomas Morgner again the topic sub-reports. For a long time I’ve tried to explain that sub-reports are a concept that shouldn’t be exposed to the actual report designer. We should all just start with a blank canvas (with no bands) and add objects (tables, crosstabs, charts, etc) and then link these objects to the data sources (frankly quite similar to how it is done in some other report designers or CDE). And parameters should just be available everywhere without having to map them to the specific objects.
Anyways, during this discussion Thomas mentioned that there is actually no need to specify all the parameters in the parameter mapping dialog in the subreport. You can just add one mapping with stars (*) in it and all parameters will be passed down automatically to the subreport. Frankly, I was puzzled and astound about this … I remembered the days when I was working on monster reports with 30 or 40 subreports and all the time had to define 17 or so parameters for each of them. Why this was not documented anywhere, I was quite wondering. Needless to say that this is a real time safer!
My next question was then, why this was not the default behaviour? If I don’t specify any parameter mappings, PRD should just pass down all parameters by default. So, I just created this JIRA case therefore and we all hope that this will be implemented as soon as possible. Please vote for it!

So excited as I was about these news, this morning I had to quickly test this approach. Here the mapping in the subreport:

1Then I just output the values in the details band of the sub-report:

2And here is how the preview looks:

3Now that was easy! Thanks Thomas!

Types of Parameters in Pentaho Report Designer


Pentaho Report Designer contains nine new pre built parameters. Below is a quick overview of the nine parameters. Each overview includes:

  • Screenshot and description
  • How to setup your parameter query
  • How to setup your report query to accept the parameter

Every example uses the Steel Wheels sample data:

DROP DOWN

Drop down screenshot

  • Similar to a select box in HTML
  • Displays one active option at a time unless you click on the arrow to display all options
  • Can only select one option at a time


Parameter Query

This query will display a unique list of Product Lines as options inside a drop down.

-- Name: enterProductLine
SELECT DISTINCT `products`. PRODUCTLINE
FROM   `products`

Report Query


This query will display all information for each product by the selected Product Line option from the drop down. As only one option can be selected at a time it is recommended to use a = (equal) in your WHERE clause.

-- Name: stockByProductLine
SELECT *
FROM   `products`
WHERE  `products`.PRODUCTLINE = ${enterProductLine}

Single Value List
Single value screenshot

  • Similar to a list box in HTML
  • Displays more than one option at once (including the active option)
  • To see more than one option at once change the Visible Items count under the parameter’s options window
  • Can only select one option at a time

Parameter Query

This query will display a unique list of Product Lines as options inside a single value list.

-- Name: enterProductLine
SELECT DISTINCT `products`. PRODUCTLINE
FROM   `products`

Report Query

This query will display all information for each product by the selected Product Line option from the single value list. As only one option can be selected it is recommended to use a = (equal) in your WHERE clause.

-- Name: stockByProductLine
SELECT *
FROM   `products`
WHERE  `products`.PRODUCTLINE = ${enterProductLine}

Multi Value List
Multi value screenshot

  • Similar to a multi list box in HTML
  • Displays more than one option at once (including active options)
  • To see more than one option at once change the Visible Items count under the parameter’s options window
  • Can select more than one option at a time

Parameter Query

This query will display a unique list of Product Lines as options inside a multi value list.

-- Name: enterProductLine
SELECT DISTINCT `products`. PRODUCTLINE
FROM   `products`

Report Query

This query will display all information for each product by the selected Product Line options in the multi value list. As multiple options can be selected at a time make sure you use an IN() condition in your WHERE clause.

-- Name: stockByProductLine
SELECT *
FROM   `products`
WHERE  `products`.PRODUCTLINE IN (${enterProductLine})

Radio Button
Radio button screenshot

  • Similar to radio buttons in HTML
  • Displays more than one option at once (including the active option)
  • Can only select one option at a time

Parameter Query

This query will display a unique list of Product Lines options as radio buttons.

-- Name: enterProductLine
SELECT DISTINCT `products`. PRODUCTLINE
FROM   `products`

Report Query

This query will display all information for each product by the checked Product Line radio button. As only one option can be selected at a time it is recommended to use a = (equal) in your WHERE clause.

-- Name: stockByProductLine
SELECT *
FROM   `products`
WHERE  `products`.PRODUCTLINE = ${enterProductLine}

Check Box
Check box screenshot

  • Similar to a check box in HTML
  • Displays more than one option at once (including active options)
  • Can select more than one option at a time

Parameter Query

This query will display a unique list of Product Lines options as check boxes.

-- Name: enterProductLine
SELECT DISTINCT `products`. PRODUCTLINE
FROM   `products`

Report Query

This query will display all information for each product by the checked Product Line check boxes. As multiple options can be selected at a time make sure you use an IN() condition in your WHERE clause.

-- Name: stockByProductLine
SELECT *
FROM   `products`
WHERE  `products`.PRODUCTLINE IN (${enterProductLine})

Single Selection Button
Single selection button screenshot

  • Similar to a buttons in HTML
  • Displays more than one option at once (including the active option)
  • Can only select one option at a time

Parameter Query

This query will display a unique list of Product Lines as single selection buttons.

-- Name: enterProductLine
SELECT DISTINCT `products`. PRODUCTLINE
FROM   `products`

Report Query

This query will display all information for each product by the selected Product Line button. As only one option can be selected at a time it is recommended to use a = (equal) in your WHERE clause.

-- Name: stockByProductLine
SELECT *
FROM   `products`
WHERE  `products`.PRODUCTLINE = ${enterProductLine}

Multi Selection Button
Multi selection button screenshot

  • Similar to a button in HTML
  • Displays more more than one option at once (including active options)
  • Can select more than one option at a time

Parameter Query

This query will display a unique list of Product Lines options as multi selection buttons.

-- Name: enterProductLine
SELECT DISTINCT `products`. PRODUCTLINE
FROM   `products`

Report Query

This query will display all information for each product by the selected Product Line buttons. As multiple options can be selected at a time make sure you use an IN() condition in your WHERE clause.

-- Name: stockByProductLine
SELECT *
FROM   `products`
WHERE  `products`.PRODUCTLINE IN (${enterProductLine})

Text Box
Textbox screenshot

  • Similar to a text boxes in HTML
  • Free text only
  • Is case sensitive and must be exactly the same as the option

Parameter Query

This query will display a unique list of Product Lines which the contents of the text box will match.

-- Name: enterProductLine
SELECT DISTINCT `products`. PRODUCTLINE
FROM   `products`

Report Query

This query will display all information for each product by the contents of the text box matching a Product Line option. As only one option can be selected at a time make sure you use a = (equal) in your WHERE clause.

-- Name: stockByProductLine
SELECT *
FROM   `products`
WHERE  `products`.PRODUCTLINE = ${enterProductLine}

Date Picker
Date picker screenshot

  • Similar to standard JavaScript date pickers
  • No way of formatting the date picker output, for example displays date, time and timezone

Parameter Options

As the date picker is providing the user values to input you do not need to specify a parameter query so your parameter options should look similar to the screenshot below:

Date picker options

Parameter Query

No parameter query is needed as the date picker is generating the parameter value.

Report Query

This query will display all information for orders which are greater than the specified Order Date from the date pickers value. As only one option can be selected at a time make sure you use a = (equal), >, >=, <= or < condition in your WHERE clause.

-- Name: stockByProductLine
SELECT *
FROM   `orders`
WHERE  `orders`.ORDERDATE > ${enterOrderDate}

Hopefully these descriptions  help you with parameters available in Pentaho Report Designer

Publishing Pentaho Reporting Templates Tips!


Yesterday I have issues updating Repository cache after uploading new .PRPT ‘s to my solution repository on a BI Server version 3.6 .

After a while I noticed that reports which failed had éá and latin characters so I turned it into ASCII ea and all worked correctly.

Second problem was to open on my Pentaho User Console, reports with + char on its title. The solution was to avoid the using of this type of strange characters.

Hope you help