Print

Reminder on SSRS row separator

My Setup
What do I want?
I have a report displaying room bookings. Each row lists the day, date, room name, start/finish times, booking details and the staff contact. I want an empty row to appear between each day in the list, so I have:
copyraw 
Monday     03/10/2011    Main Office            09:00     17:00    Notes
Monday     03/10/2011    Boss' Office           09:00     17:00    Notes
Monday     03/10/2011    Stationary Cupboard    09:00     17:00    Notes
Tuesday    04/10/2011    Main Office            09:00     17:00    Notes
Tuesday    04/10/2011    Another Office         09:00     17:00    Notes
  1.  Monday     03/10/2011    Main Office            09:00     17:00    Notes 
  2.  Monday     03/10/2011    Boss' Office           09:00     17:00    Notes 
  3.  Monday     03/10/2011    Stationary Cupboard    09:00     17:00    Notes 
  4.  Tuesday    04/10/2011    Main Office            09:00     17:00    Notes 
  5.  Tuesday    04/10/2011    Another Office         09:00     17:00    Notes 
And I want:
copyraw 
Monday     03/10/2011    Main Office            09:00     17:00    Notes
Monday     03/10/2011    Boss' Office           09:00     17:00    Notes
Monday     03/10/2011    Stationary Cupboard    09:00     17:00    Notes

Tuesday    04/10/2011    Main Office            09:00     17:00    Notes
Tuesday    04/10/2011    Another Office         09:00     17:00    Notes
  1.  Monday     03/10/2011    Main Office            09:00     17:00    Notes 
  2.  Monday     03/10/2011    Boss' Office           09:00     17:00    Notes 
  3.  Monday     03/10/2011    Stationary Cupboard    09:00     17:00    Notes 
  4.   
  5.  Tuesday    04/10/2011    Main Office            09:00     17:00    Notes 
  6.  Tuesday    04/10/2011    Another Office         09:00     17:00    Notes 

Row Seperator
This follows on from my T-SQL Record Separator article. If you are using SQL Server Reporting Services (in my case version 2008 R2), then yes, you won't need to use the database level solution and can follow these quick steps:
  1. Right-click the grey header of the tablix row (left-most grey part)
  2. Select "Add Group" then "Parent Group..."
  3. Specify the "Group by" (in my case "Day"), the grey part will display a grouping icon
  4. Now select the column that has just been created (usually "Group1") by clicking the grey part above it
  5. Delete this column. Check that the grouping grey part (a giant parenthesis) is still there.
  6. Right-click on the grey header of the tablix row again (left-most grey part)
  7. Select "Insert Row" and I selected "Outside Group - Below".
  8. Done.
Category: SQL Server Reporting Services :: Article: 396