Display dates within date ranges as groups
Hi, I'm pretty new to SSRS. I have events that run over x number of days - fields are start date, end date and number of days. I need to run a report that displays the events that are running every day, so, if the event is from June 1st to June 5th then it needs to group and display under each day/date. What would be the best way to do this? Using SQL Server 2008 R2 Thanks.
May 31st, 2011 9:59am

One thing you could try is to create a "Calendar Table" to join against. Then you can group by each individual date within your range and by event name.
Free Windows Admin Tool Kit Click here and download it now
May 31st, 2011 10:15am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics