my assignment is to edit the current rpt file with the following criteria




as shown in the image, the data will be group base on their bill number.. the bill number will be consider in same group under the following condition;

1)  the interval between the first bill number and second number is 11 as display in s/n 4 and 5

2)  if the previous number end with 6, it will be reset to 0 as shown in s/n 7 and 8

3) the group end when the next bill number could not be found in the MS Access DB and the sub total of the group will then be calculated and display

this is my first time using crystal report..

btw i am using crystal report 8


Edited by bczm8703 - 12 Jul 2011 at 2:55am

create a few formulas to start with