Databases Reference
In-Depth Information
• Report parts and reusability
• Customizing reports
• Saving and deploying reports
• Report validation
• Viewing reports
• Managing reports
• New features in RS2012 SharePoint Integrated
• Implementing security - authentication and authorization
• URL access
• Reporting Services extensions
• Reporting Services tools
The RS reports follow XML based report definitions that include report data
and report layout elements. On the file system they have the extension RDL.
A report item is published to a Report Server or SharePoint Site. It is accessed
from a Report Manager, SharePoint Site, or even on an IIS server after some
modification. As mentioned previously, reports on a Report Server installed
in Native mode can be accessed using Web parts on a SharePoint server.
Report definition
Report definition is XML based and complete in all details. This means it is
portable and can be recreated easily. However, one may have to implement
the details in the report definition especially those related to data and the
layout details in the XML file.
XML-based report definition (the .rdl file)
Here is the XML code of a typical report data's shared data source connection
information in XML:
<?xml version="1.0" encoding="utf-8"?>
<RptDataSource
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema" Name="DataSource1">
<ConnectionProperties>
<Extension>SQL</Extension>
<ConnectString>Data Source=HODENTEKWIN7\KAILUA;Initial
Catalog=Northwind</ConnectString>
<IntegratedSecurity>true</IntegratedSecurity>
Search WWH ::
Custom Search