One of my friends finds difficulty to get detail about Advance features in SQL SERVER 2008 Express Advance features and wants to know weather SSRS supported in it or not.
Look at the detail of features in SQL SERVER 2008 Express with Advance Features
SQL Server Express
provides the following Reporting Services functionality:
·
On-demand report
processing for each user who views a report. When a user opens a report, the
report is initialized, the query is processed, data is merged into the report
layout, and the report is rendered into a presentation format.
·
Rendering formats are
available for HTML, Acrobat, and Excel.
·
Report data sources must
be SQL Server relational databases that run locally in SQL Server Express.
·
Report server management
and report viewing are supported through Report Manager.
·
Configuration is
supported through the Reporting Services Configuration tool.
·
Rs.exe, rsconfig.exe,
and rskeymgmt.exe command line utilities are available in SQL Server Express.
·
Windows Authentication
and predefined roles are used to map existing group and user accounts to a
named collection of operations.
Other editions of SQL
Server include a larger set of Reporting Services features. The following list
describes the features that are documented in SQL Server Books Online, but
cannot be used in this edition:
·
Scheduled report
processing, caching, snapshots, subscriptions, and delivery are not supported.
·
Analysis Services,
Oracle, XML, SAP, SQL Server Integration Services (SSIS), OLE DB, and ODBC
data sources are not supported.
·
Remote data sources are
not supported. Reports that are hosted in a SQL Server Express report server
must retrieve SQL Server relational data from a local SQL Server
Express Database Engine instance.
·
Ad hoc reporting through
semantic models and Report Builder is not supported.
·
TIFF (Image), XML, and
CSV rendering extensions are not supported.
·
The Reporting Services
API extensible platform for delivery, data processing, rendering, and security
is not supported.
·
Custom authentication
extensions and custom role assignments are not supported. You must map existing
Windows domain user and group accounts to predefined role definitions.
·
Custom report items are
not supported.
·
Managing a long-running
report process is not supported. Specifically, you cannot use the Manage Jobs
feature in Report Manager to stop report processing.
·
Scale-out deployment is
not supported.
·
SharePoint integrated
mode is not supported.
·
Report Builder 2.0 is
not supported. Report Builder 2.0 can connect to a SQL Server Express database
on the local computer or on a remote report server.
list of Supported features and not Supported features in SQL SERVER Express 2008
