Home DADE

rb newbie using AdoStoredProcedures

edited August 2002 in DADE

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?

Comments

  • edited August 2002
    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

This discussion has been closed.