You only need to follow these steps if you install Aspose.Slides for Reporting Services manually, not using the MSI installer. The MSI installer performs all necessary installation and registration actions automatically.

In the following steps, you will need to copy and modify files in the directory where Microsoft SQL Server Reporting Services is installed.

Step 1. Locate the Report Server installation directory. The root directory for Microsoft SQL Server is usually C:\Program Files\Microsoft SQL Server.

• Microsoft SQL Server 2000 – Report Server is installed in the C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer directory.
• Microsoft SQL Server 2005 - There could be several instances of Microsoft SQL Server configured on the machine and they will occupy different MSSQL.x subdirectories such as MSSQL.1, MSSQL.2 and so on. You will need to find the correct C:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services\ReportServer directory before you proceed with the following steps.

All paths used below will refer to this directory as <Instance>.

Step 2. Copy Aspose.Slides.ReportingServices.dll to C:\Program Files\Microsoft SQL Server\<Instance>\Reporting Services\ReportServer\bin folder.

Aspose.Slides.ReportingServices.zip download contains Bin\SSRS2000 and Bin\SSRS\2005 directories which contain Aspose.Slides.ReportingServices.dll for the corresponding Microsoft SQL Server versions.

Note: In some cases, when you copy the DLL to the ReportServer\bin directory, it might get copied together with explicit NTFS file permissions assigned to it. The NTFS permissions might be such that Microsoft SQL Server Reporting Services will be denied access when loading Aspose.Slides.ReportingServices.dll and the new export formats will not be available.

To make sure NTFS permissions are correct, right click on Aspose.Slides.ReportingServices.dll, click Properties and select the Security tab. Remove any explicitly assigned NTFS permissions and leave only inherited permissions.

Step 3. Register Aspose.Slides for Reporting Services as a rendering extension. To do this, open C:\Program Files\Microsoft SQL Server\<Instance>\Reporting Services\ReportServer\rsreportserver.config and add the following lines into the <Render> element:

<Render>

…

<!--Start here.-->

<Extension Name="ASPPT" Type="Aspose.Slides.ReportingServices.PptRenderer,Aspose.Slides.ReportingServices"/>

<Extension Name="ASPPS" Type="Aspose.Slides.ReportingServices.PpsRenderer,Aspose.Slides.ReportingServices"/>

<!--End here.-->

</Render>

 

Step 4. Give Aspose.Slides for Reporting Services permissions to execute. To do this, open C:\Program Files\Microsoft SQL Server\<Instance>\Reporting Services\ReportServer\rssrvpolicy.config and add the following as the last item in the second to outer <CodeGroup> element (which should be <CodeGroup class="FirstMatchCodeGroup" version="1" PermissionSetName="Execution" Description="This code group grants MyComputer code Execution permission. ">):

<CodeGroup>

…

<CodeGroup>

…

<!--Start here.-->

<CodeGroup

class="UnionCodeGroup"

version="1"

PermissionSetName="FullTrust"

Name="Aspose.Slides_for_Reporting_Services"

Description="This code group grants full trust to the AS4SSRS assembly.">

<IMembershipCondition

class="StrongNameMembershipCondition"

version="1"

PublicKeyBlob="00240000048000009400000006020000002400005253413100040000010001005542e

99cecd28842dad186257b2c7b6ae9b5947e51e0b17b4ac6d8cecd3e01c4d20658c5e4ea1b9a6c8f854b2

d796c4fde740dac65e834167758cff283eed1be5c9a812022b015a902e0b97d4e95569eb8c0971834744

e633d9cb4c4a6d8eda03c12f486e13a1a0cb1aa101ad94943236384cbbf5c679944b994de9546e493bf

</CodeGroup>

<!--End here.-->

</CodeGroup>

</CodeGroup>

 

Step 5. Verify that Aspose.Slides for Reporting Services was installed successfully. To do that, open Report Manager and check the list of available export types for a report.

You can launch Report Manager by opening a browser (Microsoft Internet Explorer 6.0 or later) and typing the Report Manager URL in the address bar (by default it is http://<ComputerName>/Reports).

Select one of the reports you have on your server and open the Select Format combo box. You should see the list of export formats provided by Aspose.Slides for Reporting Services. Select PPT – PowerPoint Presentation via Aspose.Slides.

Aspose.Slides for Reporting Services installed successfully and new export formats are available.

Click on the Export link. It will generate the report in the selected format, send to the client and open in an appropriate application, in this case, the report opens in Microsoft PowerPoint:

A PPT report generated by Aspose.Slides for Reporting Services.

Congratulations, you’ve successfully installed Aspose.Slides for Reporting Services and generated a report as a Microsoft PowerPoint presentation!