October 8, 2008 at 3:36 pm
I want to add the semester balances up if i find a matching debit amount
e.g.
Semester Amount Balance
Semester 1 200 200
Semester 2 750 750
Semester 3 1200 1200
Semester 4 (200) (200)
Since Semester 4 can be applied to Semester 1 to zero it out, I want to show
Semester Amount Balance
Semester 1 200 0
Semester 2 750 750
Semester 3 1200 1200
Semester 4 (200) 0
I've been trying to figure this out for about two weeks now. Help please please!:w00t:
October 9, 2008 at 7:45 am
I'm not sure you can do what you are asking. It would be easier to help if you included more information in your post. Is the balance column coming from the query/dataset or is it a calculation in the report? What is the query that is returning the data? Does the balance need to show on that row or is a total remaining balance in a Student footer acceptable?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply