I have need for a report that that I can almost obtain in a crosstab query. The query I am reporting on is structured as below:
Schoolname text
Gradename Text
Gradeid Num
Schoolid Num
TeacherFTE Num
Student_enroll Num
I need a report that is structured with the schoolnames in columns across the top and gradenames as row headings. Under each school I need to report teacherFte and student_enroll and a calculated field. Should look like this:
School 1 school2 school 3
1 grade 100 5.0 75 4.5 102 5.2
2 grade
3 grade
A created a pivot form which easily displayed this. Thanks for any insight.
Patti
Schoolname text
Gradename Text
Gradeid Num
Schoolid Num
TeacherFTE Num
Student_enroll Num
I need a report that is structured with the schoolnames in columns across the top and gradenames as row headings. Under each school I need to report teacherFte and student_enroll and a calculated field. Should look like this:
School 1 school2 school 3
1 grade 100 5.0 75 4.5 102 5.2
2 grade
3 grade
A created a pivot form which easily displayed this. Thanks for any insight.
Patti