Here is my scenario: I have 3 servers namely:
A = SSAS server
R = SSRS server
S = Sharepoint server
From Server R reports are deployed in Server S. I have the cube in Server A, and have a report action created with the following values:
Report Server: R/ReportServer/Pages
Report Path: ReportViewer.aspx?http://S/ReportsFolder/SampleReport.rdl
with some parameters passed. This opens up the report in the report server from the Server R.
Coming to my actual question: Is there any way to open the report in the sharepoint site with this report action.
View Complete Post