Reminder on SSRS row separator

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.

Related Articles

Joes Revolver Map

Joes Word Cloud

Accreditation

Badge - Certified Zoho Creator Associate
Badge - Certified Zoho Creator Associate

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin - Valid till 8 May 2022 3QnhmaBX7LQSRsC9hh6Je9rGQKEGNQNfPb
© 2021 Joel Lipman .com. All Rights Reserved.