中国式报表
中国式报表通常涵盖表头和左侧边组织架构。本例提供统计 Canada、Germany、 Netherlands、 Pakistan、 Peru、Yemen 6个国家，每个城市2005年租金金额，并按国际作统计。
步骤一：配置报表配置
包含报表名称，报表描述，数据源选择，如下图所示。
步骤二：编写SQL语句
SELECT
IFNULL(ci.city, '汇总') AS city,
COALESCE(SUM(p.amount), 0) AS rental_amount
FROM
country co
JOIN city ci ON co.country_id = ci.country_id
LEFT JOIN address a ON ci.city_id = a.city_id
LEFT JOIN customer c ON a.address_id = c.address_id
LEFT JOIN rental r ON c.customer_id = r.customer_id
LEFT JOIN payment p ON r.rental_id = p.rental_id
AND YEAR(p.payment_date) = 2005
WHERE
co.country IN (
'Canada',
'Germany',
'Netherlands',
'Pakistan',
'Peru',
'Yemen'
)
GROUP BY
co.country,
ci.city WITH ROLLUP
HAVING
co.country IS NOT NULL
ORDER BY
country,
city = '汇总',
city
步骤三：配置报表头
展示效果：
