Crystal Reports 9 - Running Total Help needed

[cyreports]

I have a field in my report titled "cnt_day".

I have set up a running total titled "Days Total" that sums cnt_day > evaluates for each record and resets on change of field "PFCDutyStatusID".

I have a set of days with the same unique "PFCDutyStatusID" and it is continuely just pulling back "1" as the number of days. I am not sure what to do to get it to pull back the right value. Any help is appreciated.

 

[Madawc]

I'd advise a different method. Group by "PFCDutyStatusID". Use a summary total to get the minimum and maximum dates for the group. Use DateDiff to find the days between the two.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[lbass]

I think you should show some sample data and also show a column with the results you expect to see. Identify the fields clearly. This might be an issue of how you are sorting. Make sure the field you are resetting on is your primary sort field or group.

-LB