How to create a report with sections and page breaks using SSRS

Danny Cullen picture Danny Cullen · Nov 6, 2012 · Viewed 38.3k times · Source

I'm trying to create a report that looks like this: Tables

using a select from this table: (fiddler here for query and data)

CREATE TABLE StudentData
(
id int PRIMARY KEY IDENTITY,
name varchar(30),
subject varchar(30),
currentGrade varchar(2),
targetGrade varchar(2),
note1 varchar(100),
note2 varchar(100),
note3 varchar(100),
UNIQUE (id)
)

Basically I want to display each student on a new page, with their subject split up into sections, and their grades and notes in each of these subject sections.

I am trying to do this within Business Intelligence Development Studio

Any help with how I would go about that would be great, thanks.

Answer

Rednaxel picture Rednaxel · Nov 6, 2012

I can upload the images now.

  1. First you add a List Tablix to the report with the name and add a TextBox enter image description here

  2. Add a Parent Group to the list in the Row Group category enter image description here

  3. Choose name as the Group By Column enter image description here

  4. You will have two columns, one with the group and another with the TextBox created previously enter image description here

  5. Add more TextBox with the rest of the columns missing. enter image description here

  6. Now we're going to set the break on each group, select on the Row Groups section the group name and right click and select Group Properties enter image description here

  7. Select the Page Break page and then check the option Between each instance of a group enter image description here

  8. You should have something like this now. enter image description here

  9. Now let's configure the name to appear to the top of each page, select in the Row Groups section the Details Group and add a Total Before enter image description here

  10. And after add some TextBox and some colors you will have something like this. enter image description here

I hope this can help you.