I have a table with employees and percentages. There are more than one percentage record for each employee. For example employee A has four records with four percentages. Percentage is to be calculated at run time and if the total is more than 100 then all those records (4) of that employee are to skipped. In other words this employee records should not be printed. How do I skip these records on a report. When I read these records they are already printed. Please help.
The problem is when I calculate those records at run time they are already printed and then I come to know if they are over or less than 100. Afterwards if they are over 100, I cannot skip the. Thanks for your help.
Customer A, percent 4: Customer A percent 50: Customer A, percent 50
now 4 is not more than 100 so I let it print. Then I get the next record of customer A and the percent is 50. 4+50 is still not more than 100 and I let it print. Then next record percent of 50 is added to the total. Now the total percent is over 100. How can I go back and skip the records which already printed. Hope I made you understand?
Customer A, percent 4: Customer A percent 50: Customer A, percent 50
now 4 is not more than 100 so I let it print. Then I get the next record of customer A and the percent is 50. 4+50 is still not more than 100 and I let it print. Then next record percent of 50 is added to the total. Now the total percent is over 100. How can I go back and skip the records which already printed. Hope I made you understand?
Why do you need to read the individual percentage records if all you are looking for is their total? Sum the percentage records, related to the employee, and print or skip the employee based on the results.