-
Book Overview & Buying
-
Table Of Contents
Pentaho 5.0 Reporting by Example: Beginner's Guide
By :
We will add and configure a Sub-report in our report. Then we will add a pie chart to the Sub-report and configure it so that each of its portions has a Hyperlink to a PRD report.
In the space that we left blank in the Group Header section, we add a Sub-report.
We enlarge the Sub-report to occupy the empty space and then double-click on it to begin configuring its contents.
We configure its Import Parameter. In the Data tab, we right-click on Parameters and choose the option Edit Sub-report Parameters....
In the table on the left-hand side (Import Parameter), we click on the button
to create a new row and then establish the following:
Outer Name = co
untry_id
Inner Name = importCountryId.

We add a JDBC type Data Set with the following configuration to the Subreport:
Connections = sakila db
Query Name = RatingAmount
Query =
SELECTfilm.rating,SUM(payment.amount) AS sum_amountFROM filmINNER JOIN inventory ON film.film_id = inventory.film_idINNER...
Change the font size
Change margin width
Change background colour