Now I've been looking here including a few answers in here for the same question but none really solved the problem or contained enough info to clarify a few information.
Now first of all I made a .rdl report that connects to an access database. All good so far. Now I want to connect it with my software without a server (local) looked up the codes and the closest I got something to work is this:
Private Sub GenerateLocalReport()
ReportViewer1.ProcessingMode = ProcessingMode.Local
ReportViewer1.LocalReport.ReportPath = "D:\work\OrdersInvoice\ReportInvoice\ReportInvoice\OrdersReport.rdl"
Dim ds = New ReportDataSource("DataSet1",???)
There are two types of Reporting Services files: RDL & RDLC.
Both function very similar.
RDL files are designed to run on a reporting server, where the server takes care of creating and filling the data source based on the connection info provided in the report.
RDLC files are designed to be embedded into your client applications, using a report viewer control, with no server required. You also have to connect and fill your data sources manually in your client application (as you are doing in your answer).