SSRS Interview Questions VII

13. What is Caching in Reporting Services ?

Ans. Report server can cache a copy of a processed report and return that copy when a user opens the report. To a user, the only evidence available to indicate the report is a cached copy is the date and time that the report ran. If the date or time is not current and the report is not a snapshot, the report was retrieved from cache.

Caching can shorten the time required to retrieve a report if the report is large or accessed frequently. If the server is rebooted, all cached instances are reinstated when the Report Server Web service comes back online.

Caching is a performance-enhancement technique. The contents of the cache are volatile and can change as reports are added, replaced, or removed. If you require a more predictable caching strategy, you should create a report snapshot.

The report server generally caches one instance of a report based on the report name. However, if a report can contain different data based on query parameters, multiple versions of the report may be cached at any given time. For example, suppose you have a parameterized report that takes a region code as a parameter value. If four different users specify four unique region codes, four cached copies are created.

The first user who runs the report with a unique region code creates a cached report that contains data for that region. Subsequent users who request the report using the same region code get the cached copy.

Not all reports can be cached. If a report includes user-dependent data, prompts users for credentials, or uses Windows Authentication, it cannot be cached.

14. What do you mean by Report Server Web Service ?

Ans. SQL Server Reporting Services provides access to the full functionality of the report server through the Report Server Web service. The Report Server Web service is an XML Web service with a SOAP API. It uses SOAP over HTTP and acts as a communications interface between client programs and the report server. The Web service provides two endpoints – one for report execution and one for report management – with methods that expose the functionality of the report server and enable you to create custom tools for any part of the report life cycle.

There are three primary ways to develop Reporting Services applications based on the Web service. You can:

  • Develop applications using Microsoft Visual Studio and the Microsoft .NET Framework SDK.
  • Develop applications using the rs utility (RS.exe), the Reporting Services script environment. With Reporting Services and Visual Basic scripts, you can run any of the Report Server Web service operations.
  •  Develop applications using any SOAP-enabled set of development tools.

15. What is Report Builder ?

Ans.  Report Builder allows business users to create their own reports based on a user-friendly report model created in Model Designer. Fully integrated with Microsoft SQL Server Reporting Services, Report Builder leverages the full reporting platform to bring ad hoc reporting to all users.

Prev