I am stumped. I have two subreports in a main report. I am just trying to get a grand total of the second subreport completely separate from any fields in the main or 1st sub.
Grouped by "CCA" with subtotals for each group-I can get this grand total to work fine.
Within each group at the bottom I have "txtAmountAuthorized" which is different for each group and is pulled from a table and CCAAmount subtotal of the group. The "CCAAmount" is subtracted from the "AmountAuthorized" to get the delta for the group.
At the report footer I have the grand total of "CCAAmount" of all groups and need to add the "txtAmountAuthorized" for all groups and get the overall difference between the two. I am getting a number about 35 times what it should be and cannot figure it out.
The Control source for CCAAmount grand total is =Sum([SumOfCost]) with running sum set to OverAll which works and for AmountAuthorized I have =Sum([txtAmountAuthorized]) with running sum set to OverAll. Seems simple but I am definitely missing something.
I would appreciate any point in the right direction as I can't seem to find a lot of info on this in books and/or forums.
Thanks,
Toni
Grouped by "CCA" with subtotals for each group-I can get this grand total to work fine.
Within each group at the bottom I have "txtAmountAuthorized" which is different for each group and is pulled from a table and CCAAmount subtotal of the group. The "CCAAmount" is subtracted from the "AmountAuthorized" to get the delta for the group.
At the report footer I have the grand total of "CCAAmount" of all groups and need to add the "txtAmountAuthorized" for all groups and get the overall difference between the two. I am getting a number about 35 times what it should be and cannot figure it out.
The Control source for CCAAmount grand total is =Sum([SumOfCost]) with running sum set to OverAll which works and for AmountAuthorized I have =Sum([txtAmountAuthorized]) with running sum set to OverAll. Seems simple but I am definitely missing something.
I would appreciate any point in the right direction as I can't seem to find a lot of info on this in books and/or forums.
Thanks,
Toni
