How do you integrate the SSRS reports in your application?

Question

What are Drill Down Reports in SSRS?
How this functionality can be achieved?

Answer 1

There are 3 ways in which you can integrate reports into your application:

1. Navigating to URL i.e. https:\servername\reportservername\reportname – This is simplest and most popular way. A separate login might be required since we are directly calling the report from report server. Address of report server gets expose to user.

2. Using IFrame, Browser control or Report Viewer Control – In this approach, we embed the URL of report server in our application, hence address of reportserver is not exposed. No separate window opens. A user does not come to know that he has moved to different server.

3. Programmatically sending a web request using SOAP to report server.