I have a problem and I need an advice to solve it. I've made some reports locally in an asp.net website in C# and everything worked fine. Now I want to move them on a Reporting Service Server.
I've build the local reports in this way:
- each reports has a datatable in a data set. The data in that table is loaded dynamically from code. I have this code for this:
ReportView.LocalReport.ReportPath = "Modules/Reps/ReportOp.rdlc";
ReportView.LocalReport.DataSources.Add(new ReportDataSource("Reports_DataSet_dtOp", GetData()));
GetData() is a method that returns an IQueryable instance with the data that needs to be inserted in the table used by the report.
I don't know if this method works in Remote mode, and if is working how can I add the Tables used by the report and how can add data in those tables. I don't want that the reports could access the database directly.