ssrs rdl file

Your dataset or query might not be carrying forward the previous day's closing balance when the report date changes. If your SQL query just pulls daily data, it doesn’t know what happened before @FromDate.

So the report always starts fresh from @FromDate, instead of continuing from where the balance left off.

You need to calculate and include the opening balance before @FromDate, then use a running total logic to track balances.

-- First, get opening balance before the report start date
SELECT 
    State,
    District,
    CommodityName,
    SchemeName,
    SUM(ClosingBalance) AS OpeningBalance
FROM YourTable
WHERE TransactionDate < @FromDate
    AND State IN (@State)
    AND District IN (@District)
    AND CommodityName IN (@CommodityName)
    AND SchemeName IN (@SchemeName)
GROUP BY State, District, CommodityName, SchemeName

 

Then UNION it with the main data between @FromDate and @ToDate:

-- Then get transactions within selected date range
SELECT 
    State,
    District,
    CommodityName,
    SchemeName,
    TransactionDate,
    OpeningBalance,
    Profit,
    Loss,
    (OpeningBalance + Profit - Loss) AS ClosingBalance
FROM YourTable
WHERE TransactionDate BETWEEN @FromDate AND @ToDate
    AND State IN (@State)
    AND District IN (@District)
    AND CommodityName IN (@CommodityName)
    AND SchemeName IN (@SchemeName)

 

If you cannot modify the query or want to calculate balances in SSRS, you can use RunningValue in the report:

=RunningValue(Fields!Profit.Value - Fields!Loss.Value, Sum, "DataSet1") + First(Fields!OpeningBalance.Value, "DataSet1")