Help with Running Total and Formula

[cyreports]

Attached below is my Crystal report - (please note, I just opened a MediaFire account and hope I attached it correctly). What I need help with is in my Group 1 @UnitTotal summary for the number of days.

I have 6 groupings in this report (AssignedUnit, GurantorName, GroupBy1, GroupBy2, GroupBy3 and PFCDutyStatusId). My client needs to Group by Assigned Unit first then by GurantorName.

The issue I am having is I need in my Group 1 footer total the count of days for each Assigned unit for each guarantor, for each distinct case type. I am not sure how with how I have it set in my report.

 

[Madawc]

Have you tried a Crosstab? You find it under Insert on the menu and it would seem to fit.

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