Q: What is report server in SSRS?
A report server is a stateless server that uses the SQL Server Database Engine to store metadata and object definitions. It consists of a pair of core processors plus a collection of special-purpose extensions that handle authentication, data processing, rendering, and delivery operations. Processors are the hub of the report server.
Q: Difference between report manger and report server in SSRS?
The report server is the central component of a Reporting Services installation. It consists of a pair of core processors plus a collection of special-purpose extensions that handle authentication, data processing, rendering, and delivery operations. Processors are the hub of the report server.
Report Manager is an ASP.NET web application that provides report management/viewing capabilities for a Reporting Services instance configured in native mode.
The configuration settings of Report Manager and the Report Server Web service are stored in a single configuration file (rsreportserver.config).
You can also use "Reporting Services Configuration Manager" to configure settings for Report Server and Report Manager.
Q: What is subscription Type?
Snapshot-Based Subscriptions
Notification is sent whenever a snapshot is created
Schedule-Based Subscriptions
Uses a custom schedule (e.g., daily, monthly, etc.)
Can have start and stop dates
Data-Driven Subscriptions
Report recipients are defined by a query
Table and query must be created manually
Useful when managing large or very dynamic lists of recipients
No comments:
Post a Comment