Report Question

[Guest]

Hi,

Before I begin to ask, I want to give you a little background on what I am
trying to do. I have a report that is called a Department Exam Notification.
The report is laid out as DepartmentContact ID Header (Department Contact
Information), ProffessorLastName Header (Professor's name and email address),
Detail (student's name and exam information from the Professor's header.
What I want to do is...I want the list of students that have the same
professor but different courses on 1 page. How do I do that?

When I clicked on Detail for Properties, The Force New Page is "After
Section" then when I view the actual Report the list of students with the
same professor but different courses is on a separate page. I want the list
of students with the same professors but different courses on the same page.

Any feedback or help would be greatly appreciated!

Thanks

 

[Douglas J Steele]

Sounds as though you want to set the ForceNewPage property for the
ProffessorLastName Header section, not for the Detail section.

 

[Guest]

What type of grouping do you have setup? View-->Sorting and Grouping

Try setting the grouping to Professor and Keep Together to Yes.

 

[Guest]

Hi Doug,

When I set the ForceNewPage property for the ProfessorLastName Header
section, student's information doesn't show on the same page. The student's
information is on a separate page.

 

[Guest]

For the Sorting and Grouping, the following is displayed as:

Field/Expression Sort Order
DepartmentContacts Ascending
DepartmentContacts "
DepartmentContactID "
ProfessorLastName "
ExamDate Descending
ScheduledStartTime Ascending

 

[Douglas J Steele]

Try ForceNewPage BeforeSection.

If that still doesn't work, try adding a Footer section for
ProfessorLastName, and use the ForceNewPage there.