rb newbie using AdoStoredProcedures

rbuser

I'm using two AdoStoredProcedure to get tables from the database and I want
to print the contents. The first table contains a field named TeacherId.
Using this Id as a parameter and I'm calling the other AdoStoredProcedure
and I'm getting the students table. How can I print all the students of all
the teachers, one student per page?

digitalmetaphors

Inner Join the two tables together. Now you can create a group in the
report which is based on the student ID. Since you only get one student
record for each student id, then there will only be one record in each
group. Now, you can set the group to be a start new page group in the
groups dialog. This will cause each student to print on a new page.


Cheers,

Jim Bennett
Digital Metaphors