Same Date Running Again After Closing Report .. It Will Excute Quick from Stagging Table

 select _BrandWiseStockValues
            where _BrandWiseStockValues.StockDate == LastOfMth1 && _BrandWiseStockValues.BrandName == brandMasterTable.Brand;

        if(_BrandWiseStockValues)
        {
            globalTable.BrandStockDate_1     = startOfMth1;
            globalTable.StockAmount_1        = _BrandWiseStockValues.StockAmount;
        }
        else
        {
            select crossCompany  InventTable
                GROUP BY InventTable.ItemType, EcoResStorageDimensionGroupItem.StorageDimensionGroup, InventTable.OGSBrand
                where inventTable.ItemType != ItemType::Service && inventTable.OGSBrand == brandMasterTable.Brand
            OUTER JOIN EcoResStorageDimensionGroupItem
                where InventTable.ItemId == EcoResStorageDimensionGroupItem.ItemId && InventTable.dataAreaId == EcoResStorageDimensionGroupItem.ItemDataAreaId
            JOIN SUM(Qty), SUM(Amount) FROM InventValueReportView
                where InventTable.ItemId == InventValueReportView.ItemId && InventValueReportView.InventTransPostingType == InventTransPostingType::Financial
                && InventValueReportView.TransDate > LastOfMth1 && InventValueReportView.TransDate <= _todate
            JOIN InventDim
                where InventValueReportView.InventDimId == InventDim.inventDimId;
            {
                globalTable.StockAmount_1        += InventValueReportView.Amount * -1;
                globalTable.BrandStockDate_1     = startOfMth1;
            }

            if(globalTable.StockAmount_1)
            {
                BrandWiseStockValues.clear();
                BrandWiseStockValues.BrandName = brandMasterTable.Brand;
                BrandWiseStockValues.StockDate = LastOfMth1;
                BrandWiseStockValues.StockAmount = globalTable.StockAmount_1;
                BrandWiseStockValues.insert();
            }
        }