Suppress Duplicates in Group footer?

[CrysUser]

Hi,
I would like to suppress the duplicate values on the group footer, To explain it further,

Group A - Manager
Group B - Employee hometime hours (values would be something like Get employee home every 14 hours, Get home every 40 hours etc.,)

Hidden details

display in group footer B is the following,

Hours EmplCount Priority Attempts Success

14 hours 12 10 2 1
14 hours 15 20 4 2
14 hours 5 10 1 0


But the user wants to see the report as follows,

Group A Header - Manager's name

Group B Footer
Hours Emplcount Priority Attempts Success

14 hours 12 10 2 1
15 20 4 2
5 10 1 0

The Hours column should not repeat in the group footer. Obviously, I could add it on the header but the users are particular to get the 14 hours displayed in the same line as that of the other details and it should show only on the first line of each group.
Could someone help me find a solution to this? Any help would be greatly appreciated.

 

[Reebo99]

You can create a formula like :

If StringVar KeepDetails <> {Hoursfield} then
StringVar KeepDetails := {Hoursfield};
Hours := {Hoursfield};
else
Hours := &quot;&quot;;

P{lace this in the group footer, and see if it works, I haven't tested it yet.....

Reebo
Scotland (Sunny with a Smile)

 

[CrysUser]

Thank you very much.
the formula works like a charm with a few variations.
I had to reset the Keepdetails at the Group1 header and had to declare it as a shared stringvar.

Thanks Again