Thursday, June 23, 2011

Rendering SSRS Report in HTML / WORD / RTF format (SSRS 2005)


The following steps.
Step1 – Download .msi file(Aspose.Words.ReportingServices.msi)
Step2 – Open the rsreportserver.config (C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer)
Step3 – Add the content in config file.
Step4 – Restart Reporting services
Software
- Aspose. Words. Reporting Services. MSI
File Path - C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer
FileName - rsreportserver.config
<Extension
Name="AWDOCX"
Type="Aspose.Words.ReportingServices.DocxRenderer,Aspose.Words.ReportingServices" />
<Extension
Name="AWRTF"
Type="Aspose.Words.ReportingServices.RtfRenderer,Aspose.Words.ReportingServices" />
<Extension
Name="AWWML"
Type="Aspose.Words.ReportingServices.WordMLRenderer,Aspose.Words.ReportingServices" />
        <Extension
Name="AWHTML"
Type="Aspose.Words.ReportingServices.HtmlRenderer,Aspose.Words.ReportingServices" >
            <Configuration>
                <EnableHTMLFormatting>True</EnableHTMLFormatting>
            </Configuration>
        </Extension>
<Extension
Name="AWMHTML"
Type="Aspose.Words.ReportingServices.MhtmlRenderer,Aspose.Words.ReportingServices" />
<Extension
Name="AWODT"
Type="Aspose.Words.ReportingServices.OdtRenderer,Aspose.Words.ReportingServices" />
<Extension
Name="AWTXT"
Type="Aspose.Words.ReportingServices.TxtRenderer,Aspose.Words.ReportingServices" />
<Extension
Name="AWXPS"
Type="Aspose.Words.ReportingServices.XpsRenderer,Aspose.Words.ReportingServices" />
<Extension
Name="AWEPUB"
Type="Aspose.Words.ReportingServices.EpubRenderer,Aspose.Words.ReportingServices" />
Screen Shot from Reportserver