My first post here, love the forums.  I have tried to search the answer to my problem but I am having a hard time coming up with the right keywords to get to the results I am looking for.  Here is my dilemma:

I have a calendar view (grid) attendance report that fills in the attendance codes, by date, and other assorted info for all the children at the end of the school year.  We have a spot for "First Day" on this report that we need to track for billing and other reporting purposes mostly.

I need to come up with a formula that says if the "Attendance code" field in the "Attendance" table = "X" then display the "attendance date" field in the "Attendance" table (and stop!).  Else move to the next school day. (9/10/12-6/28/13).  And I guess as an exit, else if "X" does not exist Print Line "N/A".

X is our code for "Child Present" within the attendance code field of the attendance table.

I tried to search examples of WHILE DO loops and such but I cannot find anything that is close to what I am looking for, or I would have copied and disassembled it

Any suggestions?

I am using Crystal Reports XI

Thank you Comatt1!

This is the best thing to happen to me today.  I created the running total but got the answer of 11/15/12 for everything.  Then I realized that was the day we switched from entering no code for student present to using an "X".  I did a batch update to change all the blank codes to X's and all the dates are now printing as expected!

Thanks again for your time and your help!

the attendance.code = X should have done the trick. The only explanation I can think of is a data issue. The RT will not pick up those 3,4,6 values unless explicitly told to.

Look at the data for those dates, there must be an X somewhere