We are using Microsoft SQL Reporting Services for generating Reports in our application. We have a report server where all the reports are deployed. There are two approaches for displaying the reports on the screen. <o:p></o:p>
<o:p> </o:p>
- Web-Service approach.<o:p></o:p>
- URL approach. (Directly hit the URL) <o:p></o:p>
<o:p> </o:p>
In order to access the reports on the report server we have to give the credentials. So whenever a user tries to open the report he has to enter the username and password. <o:p></o:p>
<o:p> </o:p>
This problem can be avoided if we go for the web-service approach because we can pass the credentials to the report service object, Whereas in the URL approach we do not instantiate the object of reporting service but directly hit the URL of the report server where the reports are deployed. Hence we are not able to pass the credentials in this approach.<o:p></o:p>
<o:p> </o:p>
So whenever we try to open the reports it asks for credentials. We do not want this. One solution to this problem is that we can bypass the proxy in Internet browser settings. We tried this and it is working fine now. But still we are looking forward to a better solution because we want to avoid bypassing the proxy.<o:p></o:p>
<o:p> </o:p>
We also want the reports to interact with each other and while implementing this we were facing problems in the web-service approach, so we decided to go for URL approach. Finally we have achieved all our functionalities using URL approach but the only problem we are facing is that it is asking for credentials as described above, and we are finding a solution for the same.<o:p></o:p>
