troubleshooting Question

Business Objects Web Intelligence Reporting. How do you create a Running Total that counts the number of Lines for a given Section (group)

Avatar of RUA Volunteer2?
RUA Volunteer2?Flag for United States of America asked on
DB Reporting ToolsEnterprise Software
6 Comments2 Solutions9289 ViewsLast Modified:
THIS IS NOT CRYSTAL REPORTS.....I already know how to do this in CR so that you know.
The problem:

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.
Please advise.
ASKER CERTIFIED SOLUTION
no worries :-) no nothing

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros