sub report problem need help plz

[Durango122]

hi folks
I'm stump on how to het this done
cr 9.0
ms sql
i have a main report and a sub report
in my sub report i have a running total that gives me a count of branch
ex:
header
BRANCH_ID----------------Count
branch1-------------------5
branch2-------------------7
branch3-------------------5

in my main report i have this group
branch

layout like this and inserted the sub report at the gr1 level
header
gr1_branch_Id----------------count
*****branch1------------------5****(sub report count)
*****branch2------------------7****(sub report count)
*****branch3------------------5****(sub report count)
gr1ft*Total-------------------?
how can i get the sum of the sub report values into the gr1ft to show 17
please show ne how
thanks



Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40

 

[GJParker]

use shared variables to pass the count values back to te main report. You can then create a formula to sum the values to give you the grand total.

There are plenty of threads on here showing how to do this.

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[Durango122]

Hi
thanks for the replied
i tried to create formula to add my record
i went to the sub report and tried this
@Sum-Branch
sum({#Branch_Count})
and gave me error
cant create summarize on this field

thanks


Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40

 

[GJParker]

You can't sum running totals in that way.

Did you actually do a search to find threads on how to do this ?

Gary Parker
MIS Data Analyst
Manchester, England

 

[Durango122]

hi
Yes i did and found how to create a share var
but i found that my branch id is a varchar so i cant sum only count



Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40