Search code examples
asp.netreporting-servicesssrs-2012

Rendering ssrs reports on an external website, if ssrs server is internal


I have an internal / internal to our organization ssrs set up, means SSRS reports server url is only accessible inside our org. network . There are few ssrs reports which have parameters and drill down options, which need to be make available for our externals users on our public portal. Public portal authentication is a custom form based authentication and Ssrs use active directory windows authentication.

I came across few articles using SSRS web services , so that I can use impersonation with AD accounts. But only issue is reports are rendered in pdf, Excel format, the default ssrs pagination, parameters selection is lost.

How can I bring SSRS reports with their default UX to a public user, without exposing ssrs to outside world? I am using asp.net mvc5. I heard about report viewer controls for asp.net webforms , but can that be achieved without making SSRS public. Please help.


Solution

  • I solved by hosting a Webform in my MVC WebApp and extended ReportViewer inside that webform. This webform is then consumed in my MVC view