How to use the ReportDataSource in a report viewer control
Posted on 2014-09-17
Hi I am using a reportviewer control in visual studio 2012 and I want to reset the datasource of the report viewer, but I can't figure out the right name value combination:
The Datasource in my .rdlc is "RF" and the Dataset in the .rdlc is "dsTotalOrderCalls"
I have an Objectdatasource ID: "odsSales" and a type name: "RapidFire.RFTableAdapters.USP_TOTAL_ORDERCALLSTableAdapter"
that is referring to a table adeapter in an .xsd (dataset) that is calling a stored procedure called "USP_TOTAL_ORDERCALLS" and returning a data table called: "USP_TOTAL_ORDERCALLSDataTable"
When I try to open a new instance of the reportdatasource ie,
rv_SalesSC.LocalReport.DataSources.Add(new ReportDataSource("dsTotalOrdersCalls", odsSalesSC));
I receive an error message saying:
Cannot create a connection to data source 'RF'
Can someone help me understand what values go into instantiating a new reportdatasource object?