THIS IS NOT CRYSTAL REPORTS.....I already know how to do this in CR so that you know.
I have Student IDs
I need to count the number of Discrepancies where the Student passed or failed a class..
We collect the data in a Oracle database and check to see if the grade is passing or not.
If the grade is passing then the row is not flagged
If the grade is failing the row is flagged and brought into the report.
So we have
Student Course Grade Counter RunTotal
Billy Bobby MATH D- 1 1
Billy Bobby ENG F 1 2
Billy Bobby PHY D- 1 3
Ricky Bobby PHY D- 2 1
Ricky Bobby CHM D- 2 2
Ricky Bobby MATH D- 2 3
Ricky Bobby BIO D- 2 4
Billy Bob PHY D- 3 1
Billy Bob MATH F 3 2
If the number of Classes taken that are a failing Grades exceed 3 we need to filter the rest out and show them in the report. This is our way of helping identify students, athletes etc that we can recommend for programs to help get them back on track and put them in tutoring programs as well as check closely the evaluation of the teachers and their performance.
How can I show only the students that have more than 3 failing grades in BOXI Web Intelligence Rich Client.
Can I use a RunningCount or RunningSum combined with some other function?
I was trying this and it does not work Class Nbr is unique and Student ID is too. What am I doing wrong...?
I cannot figure out how to get it to reset to ZERO after the Student ID changes. (like you would in Crystal Reports)
=RunningCount([Class Nbr]) In ([var_Student_ID])
If so how do I write that formula.