I have a report that pulls off Student Attendance records for each group of students (i.e. 60) and has a page break between each student.
I have added a parameter to the query behind the report to filter by Subject, so that the user can get a report of students who attended their class specifically.
The issue is that because I have used the sort and group functions on the report to add the page break between each student, the report is now prompting multiple times for the query's parameter.
Is there another way I have add the page break and use the query to group and sort as needed?
--------------------
I would also like to add a second filter another version of the report so that the user can select a specific student. Ideally, I would like the user to find the student's record on the input form and be able to print the report from there. Is this possible without adding the StudentID parameter to the query?
TIA
I have added a parameter to the query behind the report to filter by Subject, so that the user can get a report of students who attended their class specifically.
The issue is that because I have used the sort and group functions on the report to add the page break between each student, the report is now prompting multiple times for the query's parameter.
Is there another way I have add the page break and use the query to group and sort as needed?
--------------------
I would also like to add a second filter another version of the report so that the user can select a specific student. Ideally, I would like the user to find the student's record on the input form and be able to print the report from there. Is this possible without adding the StudentID parameter to the query?
TIA