Microsoft Office Tutorials and References
In Depth Information
Select Report Builder Model, Report Builder Report, and Report Data Source from the
Available Site Content Types list box, and click Add.
Click OK to return to the Document Library Settings window. Browse back to the Report Library.
Click the FILES tab from the Ribbon Menu. Under New Document, click the New
Document button to view the drop-down list that consists of links to create a Report
Model, Report, or a Report Data Source.
Click on Report Builder Report to load Report Builder 3.0. You can create a new report and
publish it to this document library.
In the examples you’ve seen so far, we’ve used an embedded data source, which means the data source is specific
to this report only. And as we discussed earlier in this chapter, when you want a data source that can be used in other
reports, you need to create a shared data source. The connection information file can be either a report shared data
source (.rsds) file or an office data connection (.odc) file that can be hosted in a SharePoint document library. An .rsds
file is the same as an .rds file, but it has a different schema. When you create a Report Data Source from a new file in a
document library on SharePoint, an .rsds file is created. When you create an .rds file from the SSDT Report Designer
and publish it to a SharePoint document library, it will be converted into an .rsds file.
Creating a Report Data Source
To create an .rsds file on your SharePoint site, open the document library where you used the Reporting Services
content type earlier.
On the Documents tab of the Library Tools tab, click on Report Data Source on the New Document menu.
In the Data Source Properties window, follow these steps:
Enter the Name of the shared data source (.rsds) file.
Select the data source type you’d like to use.
Under Connection String, enter the statement needed to connect with the selected
data source type. For examples of connection strings, visit msdn.microsoft.com/
Server and the Adventure Works database, your connection string would be data
source="(local)";initial catalog=AdventureWorks .
Choose credentials for the report server to use to access the external data source.
Use Windows authentication when you want to use users’ credentials to access data in
the report; this works well when Kerberos is in effect, and it can’t be used when Forms
Based Authentication (FBA) is active on the site. The Windows authentication model
doesn’t fit when subscriptions are scheduled for the report, because the user typically
doesn’t have exclusive permissions to the report data source.
Choose Prompt for credentials when you want users to enter credentials every time
they access the report.
Choose Stored credentials for accessing data with a single set of credentials.
Use Credentials are not required when you are specifying them in the connection
Click on Test Connection to ensure the credentials entered are accurate.
Under Availability, select “Enable this data source” to make the data source active.
Click OK to save the shared data source file.
Search JabSto ::