calculating variances from subreports?

[ridhirao22]

I am working on a report and has a subreport where I will need to find variance between the subreport value and the mainreport values.

Report is group by store#

Date, Store #, store name, saleamt1, saleamt2, varaiance (saleamt1-saleamt2) Saleamt3(subreport) variance(saleamt1-saleamt3)

How can I find the variance between the main report value (saleamt1) and Subreport values (saleamt3)

I have tried the logic from another thread –( thread767-1382752)

Sub report works fine but in the main report the the first value for the store# is showing up as zero. I can’t figure what I am doing wrong please advice.

In my subereport
@Finsales is placed in the RF in the subreport and suppressed section.

whileprintingrecords;
shared numbervar FinSales:= sum(finamt, store#);

In my main report
@variance placed in GF
whileprintingrecords;
shared numbervar FinSales;
sum(saleamt1,store3) – finsales

@reset placed in GF
whileprintingrecords;
shared numbervar FinSales:=0;

TIA,
RR

 

[BobSuruncle]

Make sure that the subreport for each group runs in a section prior to the section where you're calculating the variance.
For example, split the group footer in to GF1a and GF1b.
Place the subreport into GF1a, so that the calculations will be complete.
Place the formula where you'll be calculating variance into GF1b.


Bob Suruncle

 

[ridhirao22]

Thank you Sir Bob. appreciate you reply.

I was confused on where to reset the variable to zero...from your reply I split the GF1 to a,b,c sections and it works ok so far.

Thanks again!
RR