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