Need help on shared variables

[Hm786]

Hi,

I have a main report and a sub report. I am doing all the calculations in the sub report to get my gltot. The formula goes like this:

Whileprintingrecords;
shared numbervar gltot;

if {@CurrGl} = true then

gltot := {@GL Balance};


I need to use the gltot field to get my grand gl balance by adding the gltot + sum(debit)+sum(credit)on my main report. I am not able to get gltot value in my main report, it returns 0.00 even though I just call the shared numbervar gltot in my formula field. Please help me how to proceed further. My sub report is in the group footer section of the main report.


Thanks,
Hamida

 

[Naith]

Hey Hamida,

I'm going to go ahead and guess that the subreport is placed in the same report section as the variable which is trying to call the gltot variable in the main report.

If this is what you've got, this is why the shared variable value is coming back as 0. The formula calling gltot in the main report must be in the next report section after the subreport at the earliest.

You can achieve this by inserting a new section underneath your subreport, so that you have two group footers for the same group, and insert the shared variable formula in the latter group footer.

Good luck with your report,

Naith

 

[Hm786]

Naith,

Thanks for your help. I inserted the sub report in the page header and created the variable after that and it worked fine.

Thanks,
Hamdia