Specifications

188 CHAPTER 9 Reporting Services Enhancements
create the data source using the Microsoft SharePoint List connection type and provide
credentials for authentication, you must supply a connection string to the site or subsite in
the form of a URL that references the site or subsite. That is, use a connection string such as
http://MySharePointWeb/MySharePointSite or http://MySharePointWeb/MySharePointSite
/Subsite. A query designer is available with this connection provider, as shown in Figure 9-22,
allowing you to select elds from the list to include in your report.
FIGURE 9-22 SharePoint list Query Designer
SharePoint Unied Logging Service
In SharePoint integrated mode, you now have the option to view log information by using the
SharePoint Unied Logging Service. After you enable diagnostic logging, the log les capture
information about activities related to Reporting Services in Central Administration, calls from
client applications to the report server, calls made by the processing and rendering engines
in local mode, calls to Reporting Services Web pages or the Report Viewer Web Part, and
all other calls related to Reporting Services within SharePoint. Having all SharePoint-related
activity, including the report server, in one location should help the troubleshooting process.