BIRT实现cross table
步骤一:SQL实现业务场景
场景介绍:输出学生工号,学生姓名,以及行转列实现的语文、数学、英语对应的分数(没有建表了~)
```sql
WITH aa AS (
SELECT 1 AS emp_id,'T0001' AS staff_no,'张三' AS employee_name
UNION ALL
SELECT 2 AS emp_id,'T0002','李四'
UNION ALL
SELECT 3,'T0003','王五'
),
bb AS (
SELECT 1 AS emp_id,'语文' AS subject,60 AS "number"
UNION ALL
SELECT 1,'数学',70
UNION ALL
SELECT 1,'英语',80
UNION ALL
SELECT 2,'语文',80
UNION ALL
SELECT 2,'数学',55
UNION ALL
SELECT 2,'英语',90
UNION ALL
SELECT 3,'语文',63
UNION ALL
SELECT 3,'数学',77
UNION ALL
SELECT 3,'英语',61
)
SELECT
aa.emp_id,
MAX(aa.staff_no) AS staff_no,
MAX(aa.employee_name) employee_name,
MAX( CASE WHEN bb.subject = '语文' THEN bb.number ELSE 0 END) AS "语文",
MAX( CASE WHEN