Re: Control Break with a pagebreak in Excel

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Try using Data, Subtotals and selecting to insert a page break; you'll need
to set the Name as the group to say count which you'll then page break on.

HTH Rob

"Kees Boer" <keesboer@xxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:60PKe.73$Sj1.53@xxxxxxxxxxxxx
> 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 spread*** 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
>
>
>


.

Quantcast