Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Summing the subreport results for each group

Status
Not open for further replies.

zambakh

Technical User
Jun 29, 2009
7
TR
I have a main report group name as bank names (codes), and 3 subreports linked to the main report with the bank codes. In each subreport I calculate the following :

subreport A : The letter of Credit (LC) totals that we open from the related bank (shared variable x)

subreport B : The cheques total that we have in related bank (shared variable y)

subreport C : loan totals that are raised from the related bank (shared variable z)

I have defined shared variables as indicated. What I wanted to calculate is x+y+z for each bank. When I did this, the formula is calculated correctly for the first bank but for the remaining banks the results I receive are meaningless for me.

What should I do?
 
Where are these reports located? It sounds like you need to initialize your shared variables.

you can do this for all 3 on the main report (location depends on where your subs are) or intitialize each of them in the RH header of each subreport

i.e
<Report Header of Subreport A>

//Init Formula
shared numbervar x := 0

<Report Header of Subreport B>

//Init Formula
shared numbervar y := 0

<Report Header of Subreport C>

//Init Formula
shared numbervar z := 0
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top