Calculations among Subreports

I have three subreports in detail section of main report.The first two subreports have detail records.In third subreport i want to diplay result of sum of values on two of the subreports record wise as below :

SUBREPORT 1 SUBREPORT2 SUBREPORT3



55 65 120

100 35

61 45

Problem is only result for first record on subreports is being displayed whereas i want for all.I am doing all this by using shared variables on subreports.I 've also used whileprintingrecords statement before defining shared variables.Is there any way to solve this problem.Can you explain a bit in detail?

Calculations among Subreports

I have three subreports on my main reports.what I need is that on third subreport i have a formula thats subtracting two values from two subreports beside it.Values are defined in shared variable on subreports.Formula on third subreport is accessing those shared
variables and doing calculation.Problem is:

Formula is displaying result only for the first record on subreports ,whereas i want the result of calculation for all the corresponding records.

(First 2 subreports are linked with main report)check in formula functions have you added
WhilePrintingRecords to the start of your formulas.|||I have whileprintingrecods statment in mu formula.formula is :

whileprintingrecords;

shared numbervar firstnumber;
shared numbervar secondnumber;

firstnumber - secondnumber|||Are the variables also defined in the main report?
Do you have WhilePrintingRecords in all formulas using these variables?
And what do you mean by 'from two subreports beside it'. Where are the subreports in the design?|||Here's what i am doing:

1) three subreports on main report.

2) third subreport is using shared variables from two subreport

3) before describing the shared variables in 1st two subreports i am using

whileprintingrecords;
shared numbervar firstnumber := command.hours
(same in 2nd subreport)

4) Formula in 3rd subreport:

whileprintingrecords;
shared numbervar firstnumber;
shared numbervar secondnumber;

secondnumber - firstnumber

5) When report is printing ,its displaying result only for first record.|||Where are the subreports in the main report's design?
What do you mean by "its displaying result only for first record"? The first record in the main report? The first record per subreport? How many records can the subreports have? Can the first two subreports have no records, meaning the variables won't be (re)set.
So many questions...|||Formula is displaying result only for the first record on subreports ,whereas i want the result of calculation for all the corresponding records.

firstly create a formula on main report
called for sample :

init_var

shared numbervar firstnumber:=0;
shared numbervar secondnumber:=0;


it formula put in header of main report.

now on sub report, create formulla
called for sample :

/************************************************/
calculate_values_SR1

shared numbervar firstnumber;
firstnumber:=myfield_value + firstnumber;

it formula put in detail of first sub report.(I assume your data are there.)
in each detail the formula does work again

/************************************************/
calculate_values_SR2

shared numbervar secondnumber;
secondnumber:=myfield_value + secondnumber;

it formula put in detail of second sub report.
/************************************************/
now on yur third sub report

shared numbervar firstnumber;
shared numbervar secondnumber;
secondnumber - firstnumber


I hope it gives a idea.|||Reply to JaganEllis questions:

1) The first record per subreport?

Yes, i need to print resluts of all records on 1st 2 subreport on 3rd subreport correspondingly.
5 10 15
9 11 20

2) How many records can the subreports have?
depends on records in table

3) Can the first two subreports have no records, meaning the variables won't be (re)set.

it is possible.
Subreports are in detail section of Main report.

Reply to Hensa22
--------

Your solution is not working on dummy data (my own test report) but seemed to work on actual report but as table has not enough values so not able to tell how reliable it is.

Calculations among Subreports

Question again regarding calculation on subreports.I have attached a part of my report,so its more clear what i am looking for i.e Subreport 3 is displaying result based on values from subreports 1 and 2 but only result for the first record on subreports is being displayed.Question again regarding calculation on subreports.I have attached a part of my report,so its more clear what i am looking for i.e Subreport 3 is displaying result based on values from subreports 1 and 2 but only result for the first record on subreports is being displayed.

Where is the attachment?|||I myself have no idea where's the attachement gone,but anyways here 's a snapshopt of whats happening:

SUBREPORT 1 SUBREPORT2 SUBREPORT3

5 10 15
9 6
11 3
10 5

i guess its clear now!|||its not displaying the data as required ,the number below the subreport headings are three columns each under corresponding subreports.