private void GetReportData()
        {
            int storeId = (lkStore.EditValue != null) ? Convert.ToInt32(lkStore.EditValue) : 1;
            int month = Convert.ToInt32(cboMonth.EditValue);
            int year = Convert.ToInt32(cboYear.EditValue);
            int commodityType = Convert.ToInt32(lkCategories.EditValue);

            if (radioViewSelector.EditValue.ToString() == "Readiness View")
            {
                gridDetailReport.DataSource = Balance.GetSohForAllItems(storeId, commodityType, year, month);

                gridDetailReport.MainView = gridReadinessView;
            }
            else if (radioViewSelector.EditValue.ToString() == "Consumption View")
            {
                gridDetailReport.DataSource = Balance.GetSohForAllItems(storeId, commodityType, year, month);
                gridDetailReport.MainView = gridConsumptionView;
            }
            else if (radioViewSelector.EditValue.ToString() == "Price View")
            {
                gridDetailReport.DataSource = Balance.PriceOfAllItems(storeId, year, month);

                gridDetailReport.MainView = gridPriceView;
                gridPriceView.ExpandAllGroups();
            }
            else if (radioViewSelector.EditValue.ToString() == "Supplier View")
            {
                gridDetailReport.DataSource = Balance.GetBalanceBySupplierId(storeId, year, month);
                gridDetailReport.MainView = gridSupplierView;
            }
            else if (radioViewSelector.EditValue.ToString() == "Expiry View")
            {
                Balance bal = new Balance();
                gridDetailReport.DataSource = bal.GetBalanceByExpiryDate(storeId, year, month, commodityType);
                gridDetailReport.MainView = gridExpView;
            }
            else if (radioViewSelector.EditValue.ToString() == "Batch View")
            {
                Balance bal = new Balance();
                gridDetailReport.DataSource = bal.GetBalanceByBatch(storeId, year, month, commodityType);
                gridDetailReport.MainView = gridBatchView;
            }
        }