Loading .rdlc report in Reportviewer manually in VB.Net

Question

I need a serious help in reportviewer. I seen a lot links, tried a lot codes every way but cannot find a proper solution. Please make me understand and clear my doubts even. Totally confused which dataset to select during code and what is datasource.value thing which gives me error everytime... I am showing the steps how I created the report and trying to make it work. This because I might have done any mistake in creating the reports and you people may catch it. Now the problem is described below, I have many .rdlc reporting my project. What I done is Note : Reportviewer containing form name is Reports.vb RDLC reports are Reports1.rdlc,Report2.rdlc,... 1) Created Report like Add -> New Item -> Reporting -> Report -> Report1.rdlc Report Name: Report1.rdlc 2) Then I add dataset from here like this … 3) DataSet properties opens, it even opens DataSource configuration Wizard. I select stored procedures because I want to fetch data from my stored procedures and pressed Finish. Here DataSe…

Accepted Answer

You should consider these notes:

You have a compoile-time error saying:

BC30311 : Value of type 'ReportDataSource' cannot be converted to 'ReportDataSource'

So you should check if you are using correct reference for `ReportDataSource` and using the class from correct namespace. A common problem is when you added `Microsoft.Reporting.WebForms.dll` as reference in a Windows Forms Project and added `Import Microsoft.Reporting.WebForms` namespace, so you will receive such exception.

After fixing that, you should pay attention the name of `DataSet` in your report should be the same name which you use when creating a new `ReportDataSource`. For example if the name of `DataSet` is `DataSet1`, you should use such code:

```
Dim rds = New ReportDataSource("DataSet1", data)
```

The `data` which you want to pass to the report should be in the same structure which is used by report. For example, it should be an instance of a `DataTable`:

```
TableAdapter1.Fill(Me.DataSet1, "Table1")
Dim rds = New ReportDataSource("DataSet1", Me.DataSet1.Table1)
```

When setting which report you are using, use correct resource name. For example if you have a `Report1` in root of your project, and default namspace of your project is `YourProjectNamespace` then the resource name would be:

```
ReportViewer.LocalReport.ReportEmbeddedResource = "YourProjectNamespace.Report1.rdlc"
```

When your report is in a folder, the folder name also will be added to its resource name.

Loading .rdlc report in Reportviewer manually in VB.Net

Solution

Problem