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
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
Last Comment
schwientekd
ASKER CERTIFIED SOLUTION
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.
ASKER
The answer was perfect and exactly what I needed to get to the next step. Thanks.