string selection;
string sqlQry;
ReportDataSource sReportDataSource = new ReportDataSource();
MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["LocalMySqlServer"].ConnectionString);
public void viewreports()
{
this.ReportViewer1.Reset();
sReportDataSource.Name = "dsscpreport_dtscpreport";
sReportDataSource.Value = objImportBal.GetReportData(sqlQry, con);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(sReportDataSource);
ReportViewer1.LocalReport.ReportPath = "Reports/Sales_Reports/Sales_Transaction/rdlcsalesregister.rdlc";
ReportViewer1.LocalReport.Refresh();
}
public DataTable GetReportData(string Query,MySqlConnection con)
{
MySqlDataAdapter adp = new MySqlDataAdapter(Query, con);
DataSet ds = new DataSet();
adp.Fill(ds);
return ds.Tables[0];
}
here Instead Of Query U Have To Call Stored Procedure And Fill The Datatable