title: Exposing Sql Server Reporting Services 2008 R2 over Extranet while integrating with Java web application with LDAP authentication
body: <p>As part of a development project I need to Integrate SSRS 2008 R2 with a Java application and expose to Internet/Extranet. The additional requirement is that we have LDAP authentication, so ideally when a user logs in to the webapp it gets authenticated to LDAP and when he clicks on Reports link in the Web App, he should get authenticated to the SSRS as well (more like a SSO) without asking any credentials. The reports should not loose any interactive features like Drill down, pagination, charts, sorting etc. Also there shouldn't be much overload on the Webfront as we have limited resource there. </p>
  
  <p>I have gone through the below articles from Microsoft site where they have mentioned that we can expose SSRS configured in Report Manager Mode over Intranet. This I am already aware of and I know it works well with .net Platform. But what I need clarification is that when we integrate with Web developed in Java Platform whether this will work.  Since I am not from a Web background I am not sure how Java integration will happen. If you feel that Java integration will not be problem/ I have missed something let me know.</p>
  
  <p><a href="http://msdn.microsoft.com/en-us/library/ms159272(v=sql.105).aspx" rel="nofollow noreferrer">http://msdn.microsoft.com/en-us/library/ms159272(v=sql.105).aspx</a></p>
  
  <p><a href="http://msdn.microsoft.com/en-us/library/ms153697.aspx" rel="nofollow noreferrer">http://msdn.microsoft.com/en-us/library/ms153697.aspx</a></p>
  
  <p><a href="http://msdn.microsoft.com/en-us/library/ms345248(v=sql.105).aspx" rel="nofollow noreferrer">http://msdn.microsoft.com/en-us/library/ms345248(v=sql.105).aspx</a></p>
  
  <p><a href="http://searchitchannel.techtarget.com/feature/SQL-Server-2008-Reporting-Services-for-Internet-deployment" rel="nofollow noreferrer">http://searchitchannel.techtarget.com/feature/SQL-Server-2008-Reporting-Services-for-Internet-deployment</a></p>
  
  <p>We can expose Report Manager to extranet, but we need to write custom security extension for Form Based Authentication. But this will work more as a standalone  application and will not be integrated with our web application. So user may have to login separately which may not be ideal. </p>
  
  <p>So  I was exploring  at other alternate option like using SSRS web service to integrate with Java.</p>
  
  <p>The articles what I was going through was based on web service some of them are given below</p>
  
  <p><a href="https://stackoverflow.com/questions/142690/calling-reporting-services-rdl-in-java-application">Calling Reporting services rdl in Java application</a></p>
  
  <p><a href="http://blog.ponytailbob.com/2012/04/ssrs-reporting-in-java-web-site.html" rel="nofollow noreferrer">http://blog.ponytailbob.com/2012/04/ssrs-reporting-in-java-web-site.html</a></p>
  
  <p><a href="http://javaworld.com/javaworld/jw-01-2005/jw-0110-sqlrs.html?page=1" rel="nofollow noreferrer">http://javaworld.com/javaworld/jw-01-2005/jw-0110-sqlrs.html?page=1</a></p>
  
  <p>Couple of issues that we could face -</p>
  
  <ol>
  <li><p>The report comes as an html – It looses lot of interactive features like Sorting, Drill through etc which are part of our reporting requirements of the project</p></li>
  <li><p>We loose pagination and incremental fetch in reporting</p></li>
  <li>We may end up taking additional effort in Web front if we want bring tool bars etc from reporting .</li>
  <li>They have mentioned that Images can be passed from SSRS to Java but we are not sure that Charts and other Graphs will be coming as static or it will can be generated dynamically.</li>
  </ol>
  
  <p>Any help will be sincerely appreaciated.</p>
  
  <p>Vyshak</p>