Topic: Grand Total of totals in Subreports Posted: 15 May 2008 at 11:28pm
Hi,
Its a very basic question and I'm sure it will be very easy but I am unable to get on it please help.
I have a report which has 4 subreports, each sub report have a Sum (calculated on a group), I have to show the GRAND TOTAL of all sum calculated in 4 sub reports, For Instance
GRAND TOTAL = SUM(subreport1) + SUM(subreport2) +SUM(subreport3) +SUM(subreport4)
I tried with Global NumberVar GRANDTOTAL in a formula of main report,but GRANDTOTAL is not visible in subreports.
Joined: 14 Nov 2007
Online Status: Offline
Posts: 377
Posted: 16 May 2008 at 4:48am
You have to use a shared variable to cross the "subreport barrier." The scope rules for variables are:
Local - anything in this formula Global - anything in this report Shared - anything in this report or any subreports
Just create either four shared variables or a shared array. In the report footer of each subreport, store the total to the shared variable. In the report footer of the main report, sum the shared variables or array.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
