hello there,

i have a main report with a subreport. the subreport is placed in the details section.

the problem is, when i called the running total from the subreprt to the main, it doesnt total up but instead show the last figure from the subreport.

here is an example;

Invoice number   Description    Amount
inv001                 paper A             2
inv001                 replacement      1 <-----From subreport
inv002                 paper B             3
inv003                 paper C             4
inv003                 replacement      2 <-----From subreport

                            Total                 6 <----- this shud be the correct one but mine came out 7.

The subreport links the invoice number with the main report. I calculate the total by having the running total of the main report minus the subreport. Apparently the figures came out correctly during preview but not the total. it seems that the running total from my subreport is only 2 instead of 3.

Anyone has a solution to this problem? I'm sorry for the long story as i try my best to explain. Your help would be much appreciated. thank you in advance

hey,

thanks for replying. yeap, i used shared variable and i don't get the part "if the subreport is being called before the use of the variable". Mind explaining me more about that part? perhaps  that could be the problem


Edited by me_kenny - 07 Dec 2009 at 9:19pm

yea, i get the picture. .i shall try it out and let u knw how it goes. .hopefully this works. .