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]


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.

Day against DRM Promotion


Packt Publishing is celebrating ” Day against DRM” by providing all eBooks & Videos for just $10 from its site.

 DRM Info

DRM Frequently Asked Questions

If you have questions or answers to add or to improve upon, feel free to do so on the LibrePlanet wiki.

# What is DRM?

A basic explanation of DRM is here.

# What does DRM stand for?

Industry supporters of DRM refer to it as “digital rights management,” as if to suggest that users should be powerless and relinquish their ability to decide how they can use and interact with their media. DRM is a mechanism to enforce severe restrictions on users’ media that would otherwise be impossible, so DRM is about restrictions, not rights. Users should have control over their own media, not be left at the mercy of major media and technology companies. For that reason, opponents of DRM refer to it as “Digital Restrictions Management”.

# What are some examples of DRM?

Depending on the DRM system, various limits and controls are imposed on both hardware and software. Users may be forced to use certain hardware or software platforms, limited to accessing their media on a predetermined number of devices, required to have a persistent Internet connection to use local files, have their files tied to an online account, unable to use accessibility software such as screen readers, cut off from accessing media in certain locales, or even stripped of their media by having their files silently and remotely deleted at any time.

  • If you purchase electronic copies of games from Steam, you can’t sell them or share them with a friend after you’re done playing them. If you so much as try, Steam will disable your account, which takes away your entire game collection.
  • During the mid-2000s, Sony bundled its music CDs with DRM that tracked users’ listening habits, created security vulnerabilities in their computers, and prevented CD-copying software from functioning.
  • Netflix and YouTube have constructed anti-features to prevent customers from viewing their media in certain countries or on a certain number of devices.
  • In 2009, Amazon remotely deleted copies of George Orwell’s dystopian novel, 1984, that were distributed through the Kindle store. This chilling example of potentially malicious behavior would have never been possible without DRM.

# What is the purpose of DRM?

While it is advertised as a mechanism to prevent copyright infringement, DRM is actually designed to restrict all of the incredible possibilities enabled by digital technologies and place them under the control of a few, who can then micromanage and track every interaction with digital media. In other words, DRM is designed to take away every possible use of digital media, regardless of legal rights, and sell some of these functionalities back as severely limited services.

# Doesn’t DRM limit copyright infringement?

DRM is not about limiting copyright infringement. Such an argument attempts to make DRM appear beneficial to authors and is based entirely on a (very successfully advertised) misrepresentation of DRM’s purpose. To illustrate the absurdity of the argument, consider the nature of file sharing: to obtain a copy of a file without permission, downloaders go to a friend or a file sharing network, not a DRM-encumbered distribution platform. If DRM existed only to prevent unauthorized sharing, every distribution method for that particular piece of media would have to be distributed by an uncrackable DRM-encumbered distribution platform, which is impossible on its own. So long as one copy becomes available without DRM, countless more are easily produced. Industry proponents of DRM are well aware of that DRM is not a copyright enforcement mechanism. DRM is only marketed as a copyright enforcement mechanism to mislead authors into tolerating and even defending it.

# What is the difference between DRM and copyright enforcement?

DRM restricts entirely different activities than copyright does, and serves an entirely separate function. While Copyright restricts who can distribute media, DRM restricts how users can access their media. Copyright already provides leverage against illegal distribution, meaning that the largest distribution platforms must already adhere to the demands of large publishers, studios, music labels, and software companies. DRM provides antifeatures (features that exist only to worsen the service for users) and charges for their removal. This gives major media and technology companies much broader control over the use of media than is enabled by copyright law, while copyright allows them to force all legal media distribution services to use DRM.

# Who does DRM harm?

DRM only restricts and punishes those who have acquired their media legally through DRM-encumbered platforms. Even authors, along with independent labels, studios, and publishers suffer. When a distributor gains significant control over a particular market, DRM enables them to lock in their customers to their platform. Once customers are locked in, so are labels, studios, and publishers. If an independent publisher wants to switch away from a DRM-encumbered distributor, customers might have to re-purchase their media on the new platform. As with any instance of monopolization, businesses which dominate a market can arbitrarily dictate the price they charge, as well as the price they pay for media, because suppliers are dependent on them. Without DRM, users have control over their own media such as where, when, how, and on what platforms they choose to use their files.

# Doesn’t DRM make sense for streaming media and rental services?

The problem with this argument is that it invites a future in which nobody has any control over their devices, and can only access media through DRM-encumbered distribution services. This argument is also based on misinformed claims that DRM prevents copyright infringement (see above). Streaming media services are rising in popularity, and DRM turns this into an opportunity to bring an end to personal media ownership. Rather than having services that can stream a user’s media to any device using whatever software they choose, DRM consolidates distribution and services, such that all access to media must be through these services.

# Isn’t DRM ineffective anyway?

The argument that DRM “doesn’t work” because it can often be circumvented misses the point, because DRM is not about copyright enforcement. DRM is very effective at what it does: limiting the freedom of anyone who uses DRM-encumbered services so that some functionality can be sold back as severely limited services.

# Why is DRM bad for software user freedom?

DRM is incompatible with free software. DRM is only possible by keeping some parts of a computer secret from users and unmodifiable, which is a direct attack on users’s freedom. DRM cannot function while being free software as this would allow the antifeatures enforced by DRM to be undone.

# Are Hollywood and the media companies to blame for DRM?

Not exclusively. Major media companies work in tandem with technology companies to create DRM and force all legal media distributors to encumber files with it. This way, all their customers remain dependent on them, and helps maintain their dominant position in the market.

# Which formats support DRM?

It’s important to remember that sometimes DRM is built into software and not part of a file format, and also file formats that support DRM do not necessarily require it. If you are wondering whether the file you are using could possibly be encumbered by DRM, we maintain the following list. Please note that this is only a list of formats which support DRM, and bears no weight on any other technical merits or restrictions of the formats.

Here is a list of formats that support DRM: