Anaplan XL Reporting can integrate your Reporting Services reports with the Anaplan XL Repository.

The first step is to install the ReportViewer control, available for download from Microsoft.

Next, to configure this, you will need to add the following settings in the web.config file of your AnaplanXLWeb installation:

<appSettings> <!-- Existing settings... --> <add key="ReportingServicesUrl" value="http://my-server:8080/Reports_SQL2008RS" /> <add key="ReportingServicesServerUrl" value="http://my-server:8080/ReportServer_SQL2008RS" /> </appSettings>

And remove the comments around sections of the web.config labeled

<!-- ReportingServices Integration -->

Once this is done, Anaplan XL will query the Reporting Services report list when a user logs in, and create folders for the reports found. These can then be opened directly in the AnaplanXLWeb application.

Reporting Services folders.