Database Reference
In-Depth Information
The significant consideration with this method is that certain reporting features
(for example, subscriptions) require the data sources to use stored credentials. In
this case, the credentials used to connect to the source system will be those of the
account stored with the data source—typically a common service credential. The
User!UserId
function can then be used to obtain the
DOMAIN\USERNAME
of the user
running the report and passed as a parameter in the query against the source system
to filter the data according to the user running the report.
Summary
In this chapter, we covered the main features and functionalities offered in SQL
Server Reporting Services 2012, including a breakdown of report components,
development experience, extensibility, and security. By now, readers should have a
general understanding of the capabilities offered in SQL Server Reporting Services.
In the next chapter, we are going to roll up our sleeves and step into the shoes of a
report developer to create a report and deploy it to a report server.
