Link to home
Start Free TrialLog in
Avatar of schwientekd
schwientekdFlag 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
ASKER CERTIFIED SOLUTION
Avatar of jgv
jgv

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of schwientekd

ASKER

The answer was perfect and exactly what I needed to get to the next step.  Thanks.