Group Total Not working right
Hi,
I have a problem that i cannot figure out how to fix.
I have a sub report that i need to have the group totals in the Page header and i cannot for the life of me remember how to do this.
I have grouped by field 2 which gives me a time for Planned and unplanned events, I need to add up the time of the Planned items and put next to my Downtime Planned Text Box, and then sum the Unplanned and do the same against my unplanned downtime box
Regards Steve
[492 byte] By [
snoopsterg] at [2007-11-20 11:00:43]
# 1 Re: Group Total Not working right
Example:
subreport 1 formula:
whileprintingrecords;
shared numbervar x:= sum({table.field})
subreport 2 formula:
whileprintingrecords;
shared numbervar y:= sum({table.field})
Formula in the main report:
whileprintingrecords;
shared numbervar x;
shared numbervar y;
x+y
V361 at 2007-11-9 14:11:36 >
# 2 Re: Group Total Not working right
just to add some thing. You can use the sum function as
sum({table.field}, "Group on the field");
So you can get the planned and unplanned in the same subreport.
# 3 Re: Group Total Not working right
Very confused with First reply, but will have a go at that, Second reply worked fine fo the same report
Regards
Steve
