Moving reports from local to a remote server

• dpv_ro

  Newbie

  Points: 1

  More actions

  April 18, 2013 at 4:52 pm

  #276673

  Hello,

  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.

  Thank you.