|
|
SQL Server
Reporting Services provides a robust report
management system. Report definitions,
folders, and resources are published and
managed as a Web service and can be executed
either on demand or on a specified schedule,
and are cached for consistency and
performance. The reporting services gives
users the ability to perform a wide variety
of management functionality based on their
user role:
-
Execution log -
Stores report execution data, including
the report name, time started and
completed, who executed the report, etc.
-
Job management -
System administrator can view and cancel
reports as they are being generated on a
single server or across a Web farm.
-
Linked report -
Uses the same report definition as
another report, but may have different
properties, permissions, and parameters.
Offers another way for administrators to
control and refine reporting.
-
Logging and performance counters -
Help administrators monitor, manage,
troubleshoot, and debug a Reporting
Services deployment.
-
My Reports -
A predefined security role that allows
users to build reports for personal use
or store reports in a folder on the
user’s computer.
-
Report history -
Automated report snapshots that are
archived for future reference
-
Report Manager -
A Web-based report management
application that manages all aspects of
the report lifecycle.
-
Scripting - Administrators can
use a scripting environment to automate
batch operations on deployed servers.
-
Search -
Report Manager provides a search
component within the Web-based
management application.
-
Shared data sources -
A described connection to a data source
that is maintained independently of any
report. A shared data source may be used
across many reports and
subscriptions.
-
Shared schedules -
Public schedules shared between multiple
reports. These schedules can be managed,
paused, and resumed centrally.
-
Snapshots -
Report snapshots store point-in-time,
intermediate images in a nonvolatile
format. Administrators might schedule a
report snapshot to occur at specific
intervals; all users then accessing that
report on-demand would retrieve the
report from the snapshot, even if the
underlying data has changed.
Please refer to our
Reporting Services Benefits section for
details on why reporting services is the
right solution for your business.
|
i3solutions has a proven
history of implementing reporting solutions for businesses since 1997. For more
information about the Microsoft SQL Server Reporting Services, please email
sales@i3solutions.com or call 703.652.8914.
|
|
|
|
