In this chapter, you built from scratch examples of subreports and cross tabs, exploring the capabilities offered by Pentaho Reporting. You built a master-detail subreport, which demonstrated the use of the parameters passed between the two. You also built a subreport containing the index of data (in our example, customer names). To have a reference for your future developments, you also read about a list of possible uses of subreports in advanced practical cases.

You also built cross tab reports based on MDX and SQL queries. These cross tab reports contained multiple row and column headers, and displayed summary data regarding sales numbers and actuals, budget, and variance.

Now that you have read this chapter, you should feel comfortable with all the features of Pentaho Report Designer (not only about subreports and cross tabs). From here ahead, the book...