PDA

View Full Version : Group Summary



corey
6-Apr-2010, 10:54 PM
Hi I hope this has not been answered before and comes from a crystal user.

I have a report with multiple groups and in the data details area have multiple numbers representing hours for employees (eg unpaid1, unpaid 2, unpaid3, paid 1, paid 2, paid3). What I want to be able to do is create a summary at the second group level for say unpaid 1 and unpaid3 another one for paid 1 + Paid 2 + Paid 3. Normally from what I am used to I would be able to do this a few ways either create a summary formula and add this to the details area then use the standard sum function to get the result at the group level alternately write a group summary formula that would do this.

My problem is when I create a function field and add this it calculates the value fine in the details area but I can't then use the sum function to generate the group summary as function fields are not show in the available fields list.

Can anyone provide some advice on what I am doing wrong or how to do this?

Thanks.

corey
7-Apr-2010, 12:27 AM
I found the solution thanks to another thread from Micheal and Nick.
Thanks