public void Read(string addgroup, string sy, string ri) { SqlConnection conn = new SqlConnection(this.connectionString); SqlCommand comm = new SqlCommand("dbo.UspSalarySheetLocationMonthReport", conn); comm.CommandType = CommandType.StoredProcedure; comm.Parameters.Add("@Salary_Month", SqlDbType.VarChar, 20); comm.Parameters["@Salary_Month"].Value = comboBox4.Text; comm.Parameters.Add("@Salary_Year", SqlDbType.VarChar, 10); comm.Parameters["@Salary_Year"].Value = comboBox1.Text; comm.Parameters.Add("@Location", SqlDbType.VarChar, 50); comm.Parameters["@Location"].Value = comboBox5.Text; SqlDataAdapter adap = new SqlDataAdapter(); DatabaseDataSet dataset = new DatabaseDataSet(); SalarySheetLocationWiseMonthlyCrystalReport1 crp = new SalarySheetLocationWiseMonthlyCrystalReport1(); try { conn.Open(); adap.SelectCommand = comm; adap.Fill(dataset, "DataTable1"); crp.SetDataSource(dataset); crystalReportViewer2.ReportSource = crp; } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } finally { conn.Close(); } }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { SalarySheetLocationWiseMonthlyCrystalReport1 rpt = new SalarySheetLocationWiseMonthlyCrystalReport1(); rpt.Site = this.Site; return rpt; }