nerdygirlgear
Programmer
Hi All,
I am working in Crystal Reports and am having a hard time getting the sum of a specific record in each group.
I am basically getting the min level within each group and having that counted towards the grand total.
Basically only counting the most important record and summing that for the full recordset.
I tried formulas and running totals but they don't get me to the result I am after.
As an example;
I would like the summary to be as follows:
F 6
LO 0
M 2
NC 0
Grand Total 8
Client Level Class MSORow fxMSO2 MSODesc
6714 1 F 1 1 1.00
6714 2 M 2 1 0.00
6714 2 M 3 1 0.00
12641 1 F 1 1 1.00
12641 1 F 2 1 0.00
12641 2 M 3 1 0.00
21079 1 F 1 1 1.00
21079 2 M 2 1 0.00
21079 5 LO 3 1 0.00
24734 1 F 1 1 1.00
25346 1 F 1 1 1.00
26437 2 M 1 2 1.00
26437 2 M 2 2 0.00
29039 2 M 1 2 1.00
29039 4 NC 2 2 0.00
29039 4 NC 3 2 0.00
29039 4 NC 4 2 0.00
29039 4 NC 5 2 0.00
29218 1 F 1 1 1.00
29218 1 F 2 1 0.00
29218 2 M 3 1 0.00
29218 2 M 4 1 0.00
29218 2 M 5 1 0.00
Any help is appreciated.
Thanks!
I am working in Crystal Reports and am having a hard time getting the sum of a specific record in each group.
I am basically getting the min level within each group and having that counted towards the grand total.
Basically only counting the most important record and summing that for the full recordset.
I tried formulas and running totals but they don't get me to the result I am after.
As an example;
I would like the summary to be as follows:
F 6
LO 0
M 2
NC 0
Grand Total 8
Client Level Class MSORow fxMSO2 MSODesc
6714 1 F 1 1 1.00
6714 2 M 2 1 0.00
6714 2 M 3 1 0.00
12641 1 F 1 1 1.00
12641 1 F 2 1 0.00
12641 2 M 3 1 0.00
21079 1 F 1 1 1.00
21079 2 M 2 1 0.00
21079 5 LO 3 1 0.00
24734 1 F 1 1 1.00
25346 1 F 1 1 1.00
26437 2 M 1 2 1.00
26437 2 M 2 2 0.00
29039 2 M 1 2 1.00
29039 4 NC 2 2 0.00
29039 4 NC 3 2 0.00
29039 4 NC 4 2 0.00
29039 4 NC 5 2 0.00
29218 1 F 1 1 1.00
29218 1 F 2 1 0.00
29218 2 M 3 1 0.00
29218 2 M 4 1 0.00
29218 2 M 5 1 0.00
Any help is appreciated.
Thanks!