如何在SSRS报表生成器中按日期范围进行分组？

我整理了这段适用于MS SQL Server的T-SQL代码，用来生成健康计划订阅者的模拟记录，重点展示每位订阅者的计划资格日期范围：

-- qryEligibleSubscribers2018-Q1Simple
WITH S AS (
    -- MOCK LIST OF SUBSCRIBERS TO HEALTH PLAN
    -- WITH ELIGIBILITY TIME FRAMES
    SELECT
        -- CONTINUOUSLY ELIGIBLE SINCE 2017
        '0001' AS ID,
        'MOUSE' AS LASTNAME,
        'MICKEY' AS FIRSTNAME,
        '1/1/2017' AS EligibilityStartDate,
        '3/31/2018' AS EligibilityEndDate
    -- 可通过UNION ALL添加更多模拟订阅者记录
    UNION ALL
    SELECT
        '0002' AS ID,
        'DUCK' AS LASTNAME,
        'DONALD' AS FIRSTNAME,
        '2/1/2018' AS EligibilityStartDate,
        '3/31/2018' AS EligibilityEndDate
)
SELECT * FROM S;

注：原代码片段未完整展示，我补充了必要的资格日期字段和示例订阅者，方便你直接测试运行逻辑。

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