We will modify our principal data set to practice each of the following points. We will create a subreport, and within it we will create and configure two sparklines.
customer_idat the end of the list of fields in the
SELECTstatement. Our query should look like the following:
SELECT country.country_id, country.country, customer.first_name,customer.last_name, SUM(payment.amount) sum_amount, payment.customer_id FROM payment INNER JOIN customer ON customer.customer_id=payment.customer_id INNER JOIN address ON address.address_id=customer.address_id INNER JOIN city ON city.city_id=address.city_id INNER JOIN ...