Control Break in Excel

[Kees Boer]

Hi, I was wondering if I could do a "Control Break" Report from Excel.

I'm working in a school with students. Each Student is in a seperate
grade_level and they are taking classes, for which they get grades.

Thus I've got a spreadsheet with the following grades already sorted.

Name GradeLevel Class Grade

The Name Field has the student's Name in it. For instance Barry Jones
The Grade Level has the student's gradelevel. For instance: 10th or 11th
grade.
The Class has the Course name that the student is taking such as: English II
The Grade has the Grade the student gets for the class such as a B, or C, or
A

The data is already sorted by Gradelevel and then by Name and then by Class.

What I want to do is print out report cards on each student. In order to do
that I need the report to do a Control Break when the student name changes.
It needs to forward to the next page and print out a new page. Thus there
will be one page per student.

What I envision is something like this:

Name: Barry Jones Grade Level: 10th

Courses Grade
Logic 88
Algebra II 98
English II 79
Drama 94
Latin II 82
Life Management Skills 91


Then I want it do a pagebreak and then do the next student.

My first question is whether this is possible.

My second question is what is the best way to do this? I looked a little at
Pivot reports, but it didn't seem to give me what I was looking for.

Should I import all of the data into Access and create are report like that?

Thank you so much!

Kees

 

[Guest]

You were on the correct path with the pivot report (in my opinion). Place the
student in the right most position in the Pivot Column. Select the student
name and select field settings -> layout -> Page break between Items

The other option would be to do a subtotal (Data -> Subtotal) and ensure
that page break between groupd is checked...

 

[Dave Peterson]

You have a couple of responses to your other post.