I have created a report for stock transaction within a date range. And it's working fine.

And requested to add 1 column after item description with Last Qty from previous day/month.

There is a table in the system itself which contains that information (table name ItmLcDailyTotal). They are: Date, QtyBeg, PriceBeg, QtyEnd, PriceEnd.
Whenever there is a transaction for an item, it will update this table.

So, my plan is to take the QtyValue from previous date from the "Date From" and read the transactions in date range, and calculate for last final value.

I've tried with Sub-Report to take only the value from date before DateFrom and pass it to Main Report. It worked. But I cannot calculate it for final value.

e.g.:
Item R004-PH02-01, value from last month is 9.
Transactions in current month:
5 Received and 2 Sold.
In this case, Final value will be 9 + 5 - 2 = 12.

My report give me 0.

Can someone help me?

I have created some variables.

Report Header
Global Numbervar TotGrpQty; //GroupTotal;
global numbervar TotQty;
shared numbervar TotGrpQty:=0;
shared numbervar TotQty:=0;

Group Header1 (Location)

Group Header2 (ItmCode)
Global Numbervar TotGrpQty; //GroupTotal;
global numbervar TotQty;
shared numbervar TotGrpQty:=0;
shared numbervar TotQty:=0;

Group Footer2
--> SubReport[StockQtyDaily]
--> Group Header (Date)
--> Group Footer
    whileprintingrecords;
    shared numbervar Totvalue:=
    {INC_ItmLcDailyTotal.DAY_QtyEnd};
    Totvalue
--> Report Footer
    Global Numbervar TotGrpQty; //GroupTotal;
    shared numbervar TotGrpQty;
    Whileprintingrecords;
    TotGrpQty := {INC_ItmLcDailyTotal.DAY_QtyEnd};
    TotGrpQty //GrandTotal
Summary for TotalTransfer; (in MainReport)
Summary for TotalDispose; (in MainReport)
Summary for TotalConsume; (in MainReport)


But it didnot work.
Did I missed something?

my SubReport located in Group Footer 2 (ItmCode) and it's not suppressed.
I suppressed for GH1, GH2, Detail, and GF1.

Double check the name of the shared variable(s) in the main report and the sub-reports.  Easy thing to overlook.

You said that you put the sub-report in GF2?  It appears that you have GF2 suppressed, that will not work.  Sub-reports in suppressed sections do not run.