Time for action – hyperlinks in charts

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.

1. In the space that we left blank in the Group Header section, we add a Sub-report.
2. 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 = country_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 =

     SELECT
       film.rating,
       SUM(payment.amount) AS sum_amount
     FROM film 
     INNER JOIN inventory ON film.film_id = inventory.film_id
     INNER...