CHAPTER 12 DELIVERING BUSINESS INTELLIGENCE WITH SSRSFigure 12-29. Deployed report with SharePoint document features
Before running the report, let’s change the PatRef_DS data source to use Stored Credentials, like we
did in Chapter 10 when configuring the data source for Subscriptions. We do this because the
permissions between SharePoint and the data source may be different than Windows Authentication. If
you are having permission-related issues when running a report, this is the first place that I would
troubleshoot. Navigate to your deployed data source in SharePoint and alter your data source by clicking
on the PatRef_DS link, or clicking the down arrow and selecting Edit Data Source Definition. Select the
option to use Stored Credentials under the Credentials section. Enter a valid username and credentials
as shown in Figure 12-30. If you are using Windows Credentials, be sure to select the option to Use as
Windows Credentials. Click the Test Connection to make sure that you entered valid credentials. If the
connection is created successfully, then click OK to save your settings.