Grouping Constant Value

  • Thread starter Thread starter Dean Welch
  • Start date Start date
D

Dean Welch

I have a report with grouping levels in the body. I need to use the value
from one group as input for calculations in the other groups. How can I do
this?

Thanks,
 
Dean said:
I have a report with grouping levels in the body. I need to use the value
from one group as input for calculations in the other groups.
Click to expand...

A lower level group can refer to any control in a higher
level group's header section. There is no way for you to
identify a specific row from one groups detail to another
group's detail.

Post back with a small example of your report so we can see
what you are trying to do.
 
City Delivery Sat Sun Mon Tue Wed Thu Fri Weekly
Annual Leave 48 48
% of Total 100.0%
FD LWOP 48 48
% of Total 100.0%
Customer Service Sat Sun Mon Tue Wed Thu Fri Weekly
FD LWOP 17 17
% of Total 100.0%
Work Hours 48 48
% of Total 100.0%

This is text from the report itself. What I'm trying to do is to use work
hours from each specific sub group (office) as a base to calculate percentage
of leave by leave type for each office.
 
Dean said:
City Delivery Sat Sun Mon Tue Wed Thu Fri Weekly
Annual Leave 48 48
% of Total 100.0%
FD LWOP 48 48
% of Total 100.0%
Customer Service Sat Sun Mon Tue Wed Thu Fri Weekly
FD LWOP 17 17
% of Total 100.0%
Work Hours 48 48
% of Total 100.0%

This is text from the report itself. What I'm trying to do is to use work
hours from each specific sub group (office) as a base to calculate percentage
of leave by leave type for each office.
Click to expand...


Sorry, but I failed to deduce which lines are group headers,
which are details and which are footers. I also have no
idea how any of those numbers relate to any other number.
Nor do I see how any of that relates to your original
question.

Could you walk me through it?
 
Back
Top