Datasource for Report Viewer error when loading report

Here is what you need to do.  I'm guessing your .XSD file is named "ReportEvent".  In your visual dataset (the .XSD file), right-click > Add > DataTable.  This will create a blank datatable NOT a table adapter.  Name it the exact name of your manual programmatically datatable.  Also, add all of the columns you wish to include in your report.  You are essentially building this as a link from your programmatically created table to your .rdlc report.
 
Now, if you are trying to use a report that you previously built off of a table adapter you created, you will need to change the datasource of that report to this datatable you just built.  If you can't get this to work because it can be quirky, rebuild the report using this newly created datatable in the .XSD file.
 
Now that you have a report linked to your newly created "datatable" (not table adapter) in the .XSD file, you can add this one line of code to what you were attempting.
 

Me.ReportViewer1.LocalReport.DataSources.Add(New Microsoft.Reporting.WinForms.ReportDataSource("ReportEvent_v_Incident", ds.Tables("v_Incident")))
 
So you're entire code section should look like this code snippet.

            ReportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Local
            Me.ReportViewer1.LocalReport.ReportEmbeddedResource = "Search.Report3.rdlc"
            Me.ReportViewer1.LocalReport.DataSources.Add(New Microsoft.Reporting.WinForms.ReportDataSource("ReportEvent_v_Incident", ds.Tables("v_Incident"))) 
            Me.ReportViewer1.RefreshReport()

Select allOpen in new window

Thanks for the tip so far!

Is there a way to automate the column creation in the new dataset?  I Have 104 columns in this View.

I have the new "DataTable1" listed in the Data Sources Window under the Report (along with the old, auto created table).  Now I use the smart tag in the report viewer window to point to the new datatable1?  If so The Report Data Source won't allow a change but the Data Source Instance will.  I would point the Data Source Instance to the new DataTable1 ?

Thanks again

Awesome Help! Best yet for me.  It was the Report menu telling the report to go to the correct data table that did it.  Hard to find what you don't know to look for :)  Also I needed to fill the dataset (da.Fill(ds, "DataTable1)) NOT  da.Fill(ReportEvent.DataTable1).  Code below in case anyone else wants to deviate from the cookie cutter report building process.  Easy once you know how to.  Probably build most reports this way from now on:


            cmd.Connection = sql
            cmd.CommandType = System.Data.CommandType.Text
            cmd.CommandText = "SELECT * FROM [SomeTable] WHERE [PK] = " + PK

            Try
                If sql.State <> ConnectionState.Open Then sql.Open()
                cmd.ExecuteNonQuery()
                da.SelectCommand = cmd
                ' da.Fill(Me.ReportEvent.DataTable1)  wants a dataset fill not table fill
                da.Fill(ds, "DataTable1")
                ReportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Local
                Me.ReportViewer1.LocalReport.ReportEmbeddedResource = "Search.Report3.rdlc"
                Me.ReportViewer1.LocalReport.DataSources.Add(New Microsoft.Reporting.WinForms.ReportDataSource("ReportEvent_DataTable1", ds.Tables("DataTable1")))
                Me.ReportViewer1.RefreshReport()
            Catch ex As Exception
                MsgBox("The following error prevented the report from loading:" + vbCrLf + ex.Message.ToString, MsgBoxStyle.Critical, "Error Alert!")

            End Try

Awesome help.