mpartridge
IS-IT--Management
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.
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.