0

I have many reports for my project and I have just a report Viewer and want to open all the reports in this viewer, for this viewer data source is assigned at run time and report name also

DataSet ds = new DataSet();

DataTable dt = new DataTable();              

using (SqlCommand cmd = new SqlCommand("R_PURCHASE_ORDER_DETAIL", parent.v_connection))
{
    cmd.CommandType = CommandType.StoredProcedure;
    cmd.Parameters.Add(new SqlParameter("START_CODE", SqlDbType.VarChar)).Value = "0000000000";
    cmd.Parameters.Add(new SqlParameter("END_CODE", SqlDbType.VarChar)).Value = "9999999999";
    cmd.ExecuteNonQuery();
    SqlDataAdapter da = new SqlDataAdapter(cmd);
    da.Fill(ds);
}
reportViewer1.ProcessingMode = ProcessingMode.Local;
reportViewer1.LocalReport.ReportPath = @"E:\BusinessBook\BusinessBook\BusinessBook\ZReports\Purchase\r_purchase_order_detail.rdlc";

ReportDataSource datasource = new ReportDataSource("R_PURCHASE_ORDER_DETAIL", ds.Tables[0]);

this.reportViewer1.LocalReport.DataSources.Clear();
reportViewer1.LocalReport.DataSources.Add(datasource);
reportViewer1.LocalReport.Refresh();
reportViewer1.RefreshReport();
Vojtěch Dohnal
  • 7,867
  • 3
  • 43
  • 105
alizee
  • 1
  • 1
  • 3

0 Answers0