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.

Add comment


Send

Comments   

0 Hany Z Wednesday, 20th March 2013, 3:17 pm
ok, but in my case, i have a concatenated text, like Name1%&Name2%&N ame3, Team1%&Team1&%team3
where the Name1, and name2 are in the same team
what i have done is:
Replace(MyString,"%&",vbCrLf)
which separated every name into 1 line in the text box.
however i want to SSRS create a new row in the tablix for every detail
to be like
Row1: Name1 Team1 Email
Row2: Name2 Team1 Email
Row3: Name3 Team2 Email