Paul
2008-01-31 11:44:03 UTC
Hi -
I originally posted this issue 10 days ago in the Rave news server -
but so far have had no response. I cant believe that its an unusual
problem (as many people will have resports that require sub-totals)
The news server did not seem that active at the moment (not many
posts/ answers recently) So Im hoping someone can help me from the
Delphi camp ;).
I am using Delphi 2005 with Rave 6.0.1.
Here is a summary of the problem..
I have a report the following structure..
Master...
Detail1
Detail2
------------------------------------------
Group Footer (controlled by Detail1)
Group Footer Total = [Sum(Detail1) + SUm(Detail2)]
I would like to have group totals which sums the totals for Detail1
and Detail2 and adds these together and show on the group footer.
Here is further explanation of what I am attempting to do and the
problems Im having.,.
Loading Image...
Loading Image...
I have 2 CalcTotal components placed on the group footer.
Caltotal1 is set to total a column from Detail1 and has Detail1 set as
its controller. The result is stored in parameter (called param1 for
sake of example)
Caltotal2 is set to total a column from Detail2 and has Detail2 set as
its controller.The result is stored in parameter (called param2 for
sake of example)
I then have a CalcOp component placed on the Group Footer (along with
the 2 CalcTotal components) and this is set to add the 2 parameters
(param1 and Param2) and place the result in another parameter called
GroupTotal.
All seems to work ok - but for some reason - the totals are not in
step with the results expected. The first group total is blank - the
second shows total for the previous group (the missing one.)
Can anyone please advise me as to where I may be going wrong , or how
I can simply add the 2 totals together to give a total for that group
?
Any help would be much appreciated.
Cheers..
Paul.
OS : Windows XP Service Pack 2
Delphi : 2005 Service Pack 3 Installed
Version 9.0.1935.22056
CPU : AMD 3500+
Memory 1Gig
I originally posted this issue 10 days ago in the Rave news server -
but so far have had no response. I cant believe that its an unusual
problem (as many people will have resports that require sub-totals)
The news server did not seem that active at the moment (not many
posts/ answers recently) So Im hoping someone can help me from the
Delphi camp ;).
I am using Delphi 2005 with Rave 6.0.1.
Here is a summary of the problem..
I have a report the following structure..
Master...
Detail1
Detail2
------------------------------------------
Group Footer (controlled by Detail1)
Group Footer Total = [Sum(Detail1) + SUm(Detail2)]
I would like to have group totals which sums the totals for Detail1
and Detail2 and adds these together and show on the group footer.
Here is further explanation of what I am attempting to do and the
problems Im having.,.
Loading Image...
Loading Image...
I have 2 CalcTotal components placed on the group footer.
Caltotal1 is set to total a column from Detail1 and has Detail1 set as
its controller. The result is stored in parameter (called param1 for
sake of example)
Caltotal2 is set to total a column from Detail2 and has Detail2 set as
its controller.The result is stored in parameter (called param2 for
sake of example)
I then have a CalcOp component placed on the Group Footer (along with
the 2 CalcTotal components) and this is set to add the 2 parameters
(param1 and Param2) and place the result in another parameter called
GroupTotal.
All seems to work ok - but for some reason - the totals are not in
step with the results expected. The first group total is blank - the
second shows total for the previous group (the missing one.)
Can anyone please advise me as to where I may be going wrong , or how
I can simply add the 2 totals together to give a total for that group
?
Any help would be much appreciated.
Cheers..
Paul.
OS : Windows XP Service Pack 2
Delphi : 2005 Service Pack 3 Installed
Version 9.0.1935.22056
CPU : AMD 3500+
Memory 1Gig