Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Inserting blank rows into my SSRS report

Author  Topic 

mickster
Starting Member

10 Posts

Posted - 2011-01-19 : 22:51:20
I have a SSRS report which is comprised of 2000 rows. The primary column is the student ID, of which there are approximately 105 unique ones. Each student ID is repeated consecutively on anywhere from 15 to 25 rows (one after the other).

When displaying this report, I would like to insert a blank row after each group of student IDs (the blank row will need to be inserted after a row when the next student ID is different from the current one).

Can someone please tell me how I can accomplish this? I don't know much about grouping.

Thanks in advance.

kiruthika.P.
Starting Member

5 Posts

Posted - 2011-01-24 : 07:38:09
hi
group the entire table by means of studentid first,then right click in the studentid column and select insert row below inside the group under the tablix..now i hope ur report wil work as u desire.
Go to Top of Page
   

- Advertisement -