Hi, I've got a table with records in it including StartDates and EndDates (and times). How can I print a report which shows the hours of the day (down the left) and the item records alongside the appropriate time slot? Even if the timeslots are broken down into set intervals? Any ideas? Thanks, Edmund

you can use datapart to get the Hour part from your date time field, than use this column in matrix or table grouping , Gaurav Gupta http://sqlservermsbiblog.blogspot.com/

Hi Edmund, Just add to Gaurav's response, if we want to print a report daily or schedule a report to be printed, we need to implement customized delivery extension. By default, there is a sample named P"rinterDelivery Sample " in the SQL Server Reporting Services(SSRS) samples. If we have installed the SSRS samples, we can find the sample from: C:\Program Files\Microsoft SQL Server\100\Samples\Reporting Services\Extension Samples The samples can be downloaded from: http://msftrsprodsamples.codeplex.com/ If you have any more questions, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT