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 = 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 =

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