retrieving the value from subreport into main report

[reacha]

there is a report which has two groups called
Name,processid in it

The main report is showing the data for yesterday

Name Processid Emailscame emailcomple emailsoldyester

Agency 7 1 0 6
6 2 2 5
Attorney 7 3 2 6
Embassy 7 5 4 4

For emailsolderthanyesterday i am using subreport for each and every group
Now in the main report i need to calculate
emailscame/emailsoldyester

How can i retrieve each and every value from subreport into main report

Please help me out!!


Thanks,
reacha

 

[lbass]

What report sections are we seeing here? How are the subs linked to the main report? Do you need the calculation per name and process ID or at the grand total level?

-LB

 

[reacha]

Thanks for your reply.

The issue is solved now

 

[lbass]

Please explain your solution so others can benefit from the thread.

-LB

 

[reacha]

Actually i had two groups in my main report which calculates emailcamein,emailcompleted,emailsinqueue for yesterday

Group1:Name
Group2rocessID

Subreport
---------
calculates emails not completed older than yesterday

finally i had problem in calculating the percentage

i.e (emailscameinyes)%(emailsnotcompletedolderthanyesterday)

For each group i created one subreport.Place the subreport in that group section but in the subreport suppress the field.

created a shared variable and insert one more section below that group and place the shared variable below the subreport.

Now i calculated percentage using emailscamein/sharedvariable