My Setup

• XP SP3 Workstation
• Business Intelligence Development Studio 2008 (BIDS)
• SQL Server Reporting Services 2008 R2 (SSRS)

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:

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

And I want:

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

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.

< Prev		Next >