Hello, I hope that you can lend assistance to me. I am trying to arrange the grouped data in a report (evaluation calculations) so that the data will be the following order:
Total calculations for the entire Course
Calculations for each instructor (at least two)
Total calculations for The Facilities
Total Calculations for Knowledge Level
Total Calculations for Student Information
What I am currently have:
The parameters used is a date range and UserID. I grouped on course, then grouped on the instructor. This makes better sense. I have tried on instructor and then course; and did not receive the results I wanted. Currently, I am able to have the instructors information together, then followed by the Facilities, knowledge level, and student information. I need to place The total calculations for the course above the calculations for the Instructor. Due to total calculations based on change of group or class, I know that I needed to place the calculations in a footer.
Apart from the Header (with the details), the total number of evals collected is off becasue it's listed in the header, not the footer. I could make that calculation a subreport I suppose.