• Visit Aspose.Cells for Reporting Services for .Net Download Page and download the Aspose.Cells.ReportingServices.zip archive that contains the latest version of the component and the installed document.
• Unpack the archive into some directory on your hard drive.
• Register the client component.

 

Edit the register table

 

              [HKEY_CLASSES_ROOT\AsposeReport.Connect]

              @="Aspose.Cells.ReportingServices.Connect"

              [HKEY_CLASSES_ROOT\AsposeReport.Connect\CLSID]

              @="{2DD68F66-6B17-4F5E-B982-C4C4CE040458}"

             

              [HKEY_CURRENT_USER\Software\Classes\AsposeReport.Connect]

              @="Aspose.Cells.ReportingServices.Connect"

              [HKEY_CURRENT_USER\Software\Classes\AsposeReport.Connect\CLSID]

              @="{2DD68F66-6B17-4F5E-B982-C4C4CE040458}"

              [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\AsposeReport.Connect]

              @="Aspose.Cells.ReportingServices.Connect"

              [HKEY_LOCAL_MACHINE\SOFTWARE\Classes\AsposeReport.Connect\CLSID]

              @="{2DD68F66-6B17-4F5E-B982-C4C4CE040458}"

             

              [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Excel\Addins\AsposeReport.Connect]

              "FriendlyName"="Aspose.Cells.ReportingServices"

              "Description"="Aspose.Cells.ReportingServices"

              "LoadBehavior"=dword:00000003

             

              [HKEY_CLASSES_ROOT\CLSID\{2DD68F66-6B17-4F5E-B982-C4C4CE040458}]

              @="Aspose.Cells.ReportingServices.Connect"

              [HKEY_CLASSES_ROOT\CLSID\{2DD68F66-6B17-4F5E-B982-C4C4CE040458}\Implemented Categories]

              [HKEY_CLASSES_ROOT\CLSID\{2DD68F66-6B17-4F5E-B982-C4C4CE040458}\Implemented Categories\{62C8FE65-4EBB-45e7-B440-6E39B2CDBF29}]

              [HKEY_CLASSES_ROOT\CLSID\{2DD68F66-6B17-4F5E-B982-C4C4CE040458}\InprocServer32]

              @="mscoree.dll"

              "Assembly"="AsposeReport, Version=0.0.0.1, Culture=neutral, PublicKeyToken=null"

              "Class"="Aspose.Cells.ReportingServices.Connect"

              "CodeBase"="file:///[TARTGETDIR]/AsposeReport.dll"

              "RuntimeVersion"="v2.0.50727"

              "ThreadingModel"="Both"

 

• Register the service component. Put the Aspose.Cells.ReportingServices.dll into …\Microsoft SQL Server\<SQL Server Instance>\Reporting Services\bin folder, where SQL Server version is 9.

• Register Aspose.Cells for Reporting Services as a rendering extension. To do this, open C:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services\ReportServer\rsreportserver.config and add the following lines into the <Render>……</Render> element:

 

<Render>

 

…

 

<!--Start here.-->

 

<Extension Name="ACXLS" Type="Aspose.Cells.ReportingServices.XlsRenderer,Aspose.Cells.ReportingServices" />

      <Extension Name="ACXLSX" Type="Aspose.Cells.ReportingServices.Excel2007XslxRenderer,Aspose.Cells.ReportingServices" />

      <Extension Name="ACXML" Type="Aspose.Cells.ReportingServices.SpreadsheetMLRenderer,Aspose.Cells.ReportingServices" />

<Extension Name="ACCSV" Type="Aspose.Cells.ReportingServices.CSVRenderer,Aspose.Cells.ReportingServices" />

      <Extension Name="ACTXT" Type="Aspose.Cells.ReportingServices.TabDelimitedRenderer,Aspose.Cells.ReportingServices" />

 

 

<!--End here.-->

 

</Render>

 

• Give Aspose.Cells for Reporting Services permissions to execute. To do this, open C:\Program Files\Microsoft SQL Server\MSSQL.x\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.Cells_for_Reporting_Services" Description="This code group grants full trust to the Aspose.Cells for Reporting Services assembly.">

<IMembershipCondition class="StrongNameMembershipCondition" version="1" PublicKeyBlob="00240000048000009400000006020000002400005253413100040000010001002780c08eaa89aedfb00b1b96137cca3e15f32826e0e4fd1da3c98d1e3968a03a019aa7b7228b151f6e5dae4dcb00f98479770f507626b04e786e5e93ec3757c1cc4ed1ac4b72c7649c4438e9d3a5f44d8b7522043686a2e8c2a495e04b917e0505d3201015c828e3c15afc8a46ab78293574b9e0475df68627bbabc5b564addd" />

</CodeGroup>

 

<!--End here.-->

 

</CodeGroup>

 

</CodeGroup>

 

• Verify that Aspose.Cells for Reporting Services is 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 type the Report Manager URL in the address bar (by default it is http://<ComputerName>/Reports). Select one of the reports you have in your server and open the Select Format combo box. You should see the list of export formats provided by Aspose.Cells for Reporting Services. Select “XLS – Excel Workbook via Aspose.Cells”. Click on the Export link. It will generate the report in the selected format, send it to the client and open in an appropriate application. In this case, the report opens in Microsoft Excel:

 

Congratulations, you’ve successfully installed Aspose.Cells for Reporting Services and generated a report as a Microsoft Excel file!

 

• Register Aspose Cells for Reporting Services log. Put the Aspose.Cells.ReportingServices.dll.config into …\Microsoft SQL Server\<SQL Server Instance>\Reporting Services\bin folder, where SQL Server version is 9.

 

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

<configuration>

    <configSections>

        <sectionGroup name="applicationSettings" type="System.Configuration.ApplicationSettingsGroup, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" >

            <section name="Aspose.Cells.ReportingServices.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />

        </sectionGroup>

                            <section name="log4net"   type="log4net.Config.Log4NetConfigurationSectionHandler" />

              </configSections>

    <applicationSettings>

        <Aspose.Cells.ReportingServices.Properties.Settings>

            <setting name="Aspose_Cells_ReportingServices_ReportingService2005_ReportingService2005"

                serializeAs="String">

                <value>http://localhost/ReportServer/ReportService2005.asmx</value>

            </setting>

            <setting name="Aspose_Cells_ReportingServices_ReportExecutionService_ReportExecutionService"

                serializeAs="String">

                <value>http://localhost/ReportServer/ReportExecution2005.asmx</value>

            </setting>

        </Aspose.Cells.ReportingServices.Properties.Settings>

    </applicationSettings>

              <log4net>

                            <!-- Define some output appenders -->

                            <appender name="RollingLogFileAppender" type="log4net.Appender.RollingFileAppender">

                                          <!-- change log file attributes -->

                                          <file value="E:\\MSSQL.3\\Reporting Services\\LogFiles\\aspose_rs_log.txt" />

                                          <appendToFile value="true" />

                                          <maxSizeRollBackups value="10" />

                                          <maximumFileSize value="100KB" />

                                          <rollingStyle value="Composite" />

                                          <staticLogFileName value="true" />

                                          <layout type="log4net.Layout.PatternLayout">

                                                        <header value="[Header]&#13;&#10;" />

                                                        <footer value="[Footer]&#13;&#10;" />

                                                        <conversionPattern value="%date [%thread] %-5level %logger [%ndc] - %message%newline" />

                                          </layout>

                            </appender>

 

                            <!-- Setup the root category, add the appenders and set the default level -->

                            <root>

         <!-- change log level -->

                                          <level value="INFO" />

                                          <appender-ref ref="RollingLogFileAppender" />

                            </root>

              </log4net>

    </configuration>