ridhirao22
Programmer
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
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