Database Reference
In-Depth Information
For Analysis Services data sources, setting these options causes Reporting
Services to add the
EffectiveUserName
property into the connection string
and populate it with the user that is running the report. The key requirement
for using the
EffectiveUserName
property with an Analysis Services con-
nection is that the stored credential account must be an Analysis Services
administrator.
In some cases when SharePoint uses a distributed architecture separating the
front-end web server from an application server hosting Reporting Services,
additional configuration of the Analysis Services server to support this capabil-
ity including creating an SPN (Service Principal Name) for the Analysis Services
service account as well as enabling the account's delegation setting within
Active Directory may be required.
For SQL Server data sources, setting these options sets the
SETUSER
function
to be used to impersonate the user to run the data source query. The key
requirement for using
SETUSER
to impersonate another user within SQL Server
with a SQL Server connection is that the stored credential account must be
a member of the SQL Server
sysadmin
fixed server role or be a
db_owner
fixed database role. Additionally, when using SQL Server authentication and
the username and password are database credentials, do not select Use as
Windows credentials when connecting to the data source.
eXPReSSIonS In RePoRTIng SeRVICeS
Reporting Services supports the use of expressions (Visual Basic code) to
control aspects of report content, design, and interactivity. These expressions
include constants, operators, and references to report values (fields, functions,
and collections) or external (custom) code.
You can achieve advanced report designs primarily by successfully using
expressions to control the report content and appearance of report objects.
You may also use expressions to create formulas that evaluate data values
in order to determine what type or format of indicator should be displayed.
This use of report expressions is very useful when creating key performance
indicators (KPIs) within a Reporting Services report. Displaying the current
status of a KPI value an expression can determine if a value was in a desired
range and, if so, to render a stoplight graphic with a green light illuminated.
