How to remove the extra report format

Aspose.Words Product Family
1

We have installed the trial version to be able to export report generated from SSRS to word format. But we just wonder how we can remove the formats which we don’t want, like TIFF… Thanks.

2

Hi

Thanks for your inquiry. You can change “C:\Program Files\Microsoft SQL Server\Reporting Services\ReportServer\rsreportserver.config” configuration file and remove unnecessary extensions. Please refer the link to learn more:
https://docs.aspose.com/words/reportingservices/installing-on-the-server-manually/
Hope this helps.
Best regards.

3

Can we control from the web application instead of changing in the configuration file.
We have different reports and will prefer different export format. Thanks.

4

Hi

Thanks for your inquiry. If you use ReportViwer to display your report, you can use code provided in the following article to hide render extensions:
http://mikemason.ca/index-old.html
Here is simple example that hides DOC extension:

protected void Page_Load(object sender, EventArgs e)
{
    ReportViewer1.ServerReport.ReportServerCredentials = new MyReportServerCredentials();
    foreach (RenderingExtension extension in ReportViewer1.ServerReport.ListRenderingExtensions())
    {
        if (extension.Name == "AWDOC")
            ReflectivelySetVisibilityFalse(extension);
    }
}

///
/// Hides report extension
///
///
private void ReflectivelySetVisibilityFalse(RenderingExtension extension)
{
    FieldInfo info = extension.GetType().GetField("m_serverExtension", BindingFlags.NonPublic | BindingFlags.Instance);
    if (info != null)
    {
        Microsoft.SqlServer.ReportingServices2005.Execution.Extension rsExtension = info.GetValue(extension) as Microsoft.SqlServer.ReportingServices2005.Execution.Extension;
        if (rsExtension != null)
        {
            rsExtension.Visible = false;
        }
    }
}

Hope this could help you.
Best regards.