I solved it!
The first step was to simplify everything drastically with a SQL Command. I used something like:
select StudentID, CourseNum, Section, T1_Grade as Grade, 'T1' as Trimester
from Grades
where T1_Active = 'A'
UNION ALL
select StudentID, CourseNum, Section, T2_Grade as Grade...
I need help creating a chart that shows the total number of each grade type for each trimester at an elementary school. I'm using Crystal Reports 2008 querying a SQL Server 2005 database.
My grouping so far is first by grade level then by subject (Math, Language Arts, etc.). Within each of...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.