- XP SP3 Workstation
- Business Intelligence Development Studio 2008 (BIDS)
- SQL Server Reporting Services 2008 R2 (SSRS)
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
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
- 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
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
- 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:
- Right-click the grey header of the tablix row (left-most grey part)
- Select "Add Group" then "Parent Group..."
- Specify the "Group by" (in my case "Day"), the grey part will display a grouping icon
- Now select the column that has just been created (usually "Group1") by clicking the grey part above it
- Delete this column. Check that the grouping grey part (a giant parenthesis) is still there.
- Right-click on the grey header of the tablix row again (left-most grey part)
- Select "Insert Row" and I selected "Outside Group - Below".
- Done.
Category: SQL Server Reporting Services :: Article: 396
