Missing DOCX, XLSX, PPTX, XPS export options in viewers or "X rendering format is not available" error message

AUTHOR: Stephania Tapela

DATE POSTED: September 02, 2016

Article information
Article relates to	Telerik Reporting
Created by	Stef, Telerik
Last modified	April 18, 2017
Last modified by	Stef, Telerik

PROBLEM
Missing DOCX, XLSX, PPTX, XPS export options.
If you export programmatically, the error message will be: "X rendering format is not available", where X is DOCX, XLSX, PPTX, XPS.

SOLUTION 
The XPS rendering extension requires the Telerik.Reporting.XpsRendering.dll assembly. 
DOCX/PPTX/XLSX rendering extensions are OpenXML formats and they require Telerik.Reporting.OpenXmlRendering.dll and Open XML SDK 2.0 for Microsoft Office (DocumentFormat.OpenXml.dll v.2.0.5022.0 or above).

If you are using DocumentFormat.OpenXml of version 2.5.5631.0, you will need binding redirect for the DocumentFormat.OpenXml.dll assembly - Deploy Telerik Reporting with newer OpenXML SDK version. 

In newer versions the DocumentFormat.OpenXml assembly the PublicKeyToken is changed. Thus if you are using DocumentFormat.OpenXml of version 2.7.2.0 you have to reference Telerik.Reporting.OpenXmlRendering.2.7.2. For even newer versions add and the required binding redirect.

The assembly references must be added in the project that handles reports:

• If the project uses ReportProcessor instance, assembly references must be added in that project's configuration file;
• If the project uses a viewer that operates via Telerik Reporting Service, the assembly references must be added in the service project's configuration file;
• If the project uses a desktop viewer or the obsolete ASP.NET WebForms ReportViewer control, assembly references must be added in the viewer project's configuration file;
• If you are testing the design-time preview in the Standalone Report Designer, it is configured to let export in DOCX, PPTX, XLSX and XPS without additional settings;
• If you are testing the design-time preview in Visual Studio Report Designer, you may not have all export options, unless OpenXML SDK 2.0 is installed on the machine, or if OpenXML SDK 2.5 or greater is installed and you manually add binding redirect for DocumentFormat.OpenXml.dll assembly in the corresponding devenev.exe.config file (Visual Studio configuration file). On installing, Telerik Reporting assemblies are automatically registered in the machine's GAC and the design-preview will load them automatically.
  If you do not want to install OpenXML SDK, copy DocumentFormat.OpenXml.dll next to the corresponding devenv.exe (Visual Studio exe).

On deploying the application, verify that the above listed assemblies are copied in the bin folder. For the purpose, select the references in Visual Studio and set their CopyLocal to true.

 

NOTE: If you are interested in limiting the export options, please check Limit export options in ReportViewer to certain format only.
If you are deploying in Azure with OpenXML SDK 2.5, you may need an additional configuration file listing the binding redirects from your application - WebRole starts cycling after deploying to Windows Azure.