Crystal - Count values from group footer
Posted on 2011-03-23
I am a crystal newbie and am trying to figure out how to count a value displayed in the group footer. I have looked around at other requests but can't find one that quite fits my problem.
I have one to many structure, but I only want the Code from the most recent record in TableMany. Then I need to count (or sum) the total number of econDisadvantaged students.
Table1.Student-ID --> TableMany.Student-ID
Formula: if Table3.Code <> "P" then 1 else 0
I do not have anything in the detail. Rather I sorted on Student-ID and Eff-Date and have a group
footer at Student-ID. The report prints the student information just fine, but I can't get my
sum to work properly in the report footer. It is summing for each record out of TableMany
instead of just the last record as displayed in the Group footer.
Student-ID Name EconDisadvantaged (or not)
DistinctCount(Student-ID) # Students that are EconDisadvantaged
Is there a better way? How would I select only the most recent record out of TableMany?
(Which I would rather do than putting this in the footer.) Thanks in advance for helping the newbie.