I'm trying to run a report that has 2 columns in the Details.
This report is for a school and all the data is grouped by student id.
However, some students may have up to 10 items listed in the Details, so I want to split it up so that the report will fit on one page, rather than a single column of 10 or more items, which causes the report to flow to a second page.
I've searched the forum and tried different things (Page Setup, Column settings, subreports) but I'm missing something.
I'm using the student id to group the report so the report has a student id header and student id footer.
I'm not an expert user, so if you can help, please be as detailed as possible.
thanks
This report is for a school and all the data is grouped by student id.
However, some students may have up to 10 items listed in the Details, so I want to split it up so that the report will fit on one page, rather than a single column of 10 or more items, which causes the report to flow to a second page.
I've searched the forum and tried different things (Page Setup, Column settings, subreports) but I'm missing something.
I'm using the student id to group the report so the report has a student id header and student id footer.
I'm not an expert user, so if you can help, please be as detailed as possible.
thanks