SharePoint report site.

2022-11-03 16:44:05

Create site.
Upload rdl files into Dashboards lib.
Manage Data source.

Select the rdl file and click …

Data sources defined in the rdl file should be listed here.

Click the data source name.

If you select custom data source, you can change the connection string, credentials, etc.

If you select shared data source, shared data source is listed.

How to create shared data source.

Create a xml file and paste the following content into it.

<?xml version="1.0" encoding="utf-8"?>

<DataSourceDefinition xmlns="http://schemas.microsoft.com/sqlserver/reporting/2006/03/reportdatasource">

<Extension>SQL</Extension>

<ConnectString>Data Source=<server>,<port>;Initial Catalog=<database name></ConnectString>

<CredentialRetrieval>Store</CredentialRetrieval>

<WindowsCredentials>False</WindowsCredentials>

<ImpersonateUser>False</ImpersonateUser>

<Enabled>True</Enabled>

</DataSourceDefinition>

And save it with file extension rsds.

After uploading it into the Dashboards library, you can select it when managing data sources for rdl files.