报表列组分页失效问题排查：学期组间无法分页的原因

我正在构建一份课程表报表，希望报表能在学期之间实现分页。数据集包含4个季度，我通过以下查询将季度分配至对应学期：

select distinct t.name AS 'termName', CASE WHEN t.name IN ('Q1', 'Q2') THEN 'S1' 
    WHEN t.name IN ('Q3', 'Q4') THEN 'S2' ELSE NULL END AS 'termLabel'

报表中使用的termName字段来自主查询：

select distinct ps.name AS 'periodScheduleName', pd.name AS 'periodName', CASE WHEN tm.name IN ('Q1', 'Q2') THEN 'S1'
    WHEN tm.name IN ('Q3', 'Q4') THEN 'S2' ELSE NULL END AS 'termName', 
    ISNULL(x.staffNumber, '') AS 'staffNumber', COALESCE(x.employeeName, 'No Staff Assigned') AS 'employeeName', 
    ISNULL(x.departmentName, '') AS 'departmentName',
    c.name AS 'courseName', CAST(c.number as varchar(25)) AS 'courseNumber',  CAST(s.number as varchar(25)) AS 'sectionNumber',
    ca.name AS 'calendarName'

我已基于termName创建列组，下方展示各时段信息，并勾选了列组的「分页选项：在每个组实例之间」。数据显示正常，但学期1（S1）和学期2（S2）并未分开展示在不同页面。请问我遗漏了什么设置？感谢解答！

内容的提问来源于stack exchange，提问作者Michelle