At work, I use Microsoft Access, Excel, and Word with VBA as a report writer/analyst.
The institution is moving to another report writer tool (not Crystal Reports - the one they bought will be be nameless for now... :-) )
I programmatically have Access VBA execute a Word Mail Merge. The Word template is multiple pages.
I got help on EE in the past to do this: create on Mail Merge word doc, then burst it into baby docs, one for each student, and save the student doc with the student's name on the server
The "nameless-report writer" has difficulty creating a more than one page report template, If the template was one page, it can do a word-mail-merge.
I have seen You tube videos of Crystal Reports that show many rows down the page, a traditional report.
In my scenario, one row, creates a report/
If I have 200 students, the result would be with my vba, 200 baby report. Each report with several pages.
Can Crystal create these smaller reports. Or Does crystal just create one big report.