private void buttonMonthlyReport_Click(object sender, EventArgs e) { string Path = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments); DataSet ds = new DataSet(); if (comboBoxSelectProduct.SelectedIndex > -1) { if (comboBoxSelectProduct.SelectedValue is int) { ds = retrieve.GetOverAllReportDetails(dateTimePickerStock.Value.Month, ProductId); labelReportisGenerating.Visible = true; StocksReport.ExportDataSetToExcelOverAllReport(ds, Path, comboBoxSelectProduct.Text); labelReportisGenerating.Visible = false; MainClass.ShowMessage("Report Generated Sucessfully", "Success", "Success"); } } else { MainClass.ShowMessage("Please Select a Product First.", "Error", "Error"); } }