I've created a school database which produces student reports; however, not all the subjects which a student studies use the same layout, which makes printing an entire set of reports for a single student cumbersome.

So far, we've printed all the reports for subject X then for Subject Y and collated them all together. This is clearly a pain.

Is there a simple way/script which will let me print all the reports collated together for a single pupil (or even better, all pupils) in one operation?

...not all the subjects which a student studies use the same layout...

Can you say why this is designed this way? Why not have Subject just be an attribute (field) of the Course table. In a relational system, you would then print the report from the Student-Course join table (showing the related Subject field on the layout).

For various reasons, the school requires a completely different format/appearance for some subjects' reports. There are 3 separate layout formats for the reports; however, within that, there are 4 or 5 subjects which share a common layout, the rest have a completely different layout, then a final student report has a third layout.

Edited June 7, 200718 yr by Guest

Easy, but you need a script. The script-maker is surprisingly intuitive. I'm new to this myself, but I'll try to give you an example:

Enter Browse Mode

Go to Record/Request/Page[ First ]

Loop

Enter Preview Mode

Go to Layout [ “SubjectX” (tablename) ]

Print [ ]

Go to Layout [ “SubjectY” (tablename) ]

Print [ ]

Enter Browse Mode

Go to Record/Request/Page[ Next ]

End Loop

Use that as a start, and mess around with it until it works. Post any problems here, or if you don't understand the logic.

Many thanks for this. I was hoping there might be a more elegant solution, but it seems not.