Avatar of schwientekd
schwientekd
Flag for United States of America asked on

ssrs date range grouping

I'm building a report that lists records that are BETWEEN two date parameters.  I want to be able to group these by an additional range.  Eventually I'd like to make this group dynamic but for now I just want to look at a way to accomplish the following example.

The dates 1/1/2009 and 12/31/2009 are entered.  Out of those records I would like to include all records in this date range on the report.  However, I want to separate the records by another date range of 4/1/2009 and 8/31/2009.  So on the report I would want to list three groups with details, totals, etc.

Group 1
Records for date range 1/1/2009 - 3/31/2009

Group 2
Records for date range 4/1/2009 - 8/31/2009

Group 3
Records for date range 9/1/2009 - 12/31/2009
DB Reporting ToolsMicrosoft SQL Server 2005SSRS

Avatar of undefined
Last Comment
schwientekd

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
jgv

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
schwientekd

ASKER
The answer was perfect and exactly what I needed to get to the next step.  Thanks.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23