You show what looks like a standard summary report with sub summary layout parts but do not identify the table occurrence on which it is based. Would it be stock transactions or one of the others?
I normally do it this way:
In the transactions table:
Define a calculation field, cBal as Qty_in - Qty_out
Define a running total summary field as the Total of cBal. This would then be set to restart totals when grouped by location--the "innermost" group in your summary report.
Put this field on your summary report and base the layout on your transaction table. The only relationship that your report would need would be one that matches only by product ID and then only to reference data from the products table if there is data there that you need in your report.
Thanks for your response philmodjunk.
Yes that is correct, the Summary report with sub summary is based on the Stock Transaction table.
I realize my mistake after closely reading your response. I was using Summary to total sBalance but sorting restart using Location_ID from Location table instead of Location_ID from Stock Transaction table!!! OMG! Thanks