How can I get only data from reporting services without using their controls?

B2H

New Member
The architecture of my project is 3 tiers, basically :(1)ASP.NET MVC --> (2) Reporting Service --> (3) Database using store proceduresIn layer (2), I used Report Viewer control in order to support layer (1) displaying the data tables to the end-users. All of materials in this layer are under *.rdl files. So, The reporting service helps layer (1) with its own controls.In layer(1), just use:\[code\] Microsoft.Reporting.WebForms.ReportViewer rvwReportViewer;rvwReportViewer.ServerReport.SetParameters(reportParameter);\[/code\]Then the data table will show within the reportParameterHowerver, I want the layer (1) can get and manage RAW DATA by itselft but always make sure that it still connect to database(layer (3)) via Reporting Service (layer (2)). No longer need the support from report controls of layer(2) but must engage the architectureIn another words, the layer (2) requests and retrieves data from the layer (3), the layer(1) can do it also to get the data from layer(2) then parse that data and display by itselft.Can anyone tell me any solution?Any help would be appreciated. Thank in advanced.
 
Back
Top