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;
}