Export Report to 10 formats in code behind

[Ashraf]

Hi , i used the following code to export report to excel by the code ,
i need the same code to export the report to xps format 

void ExportReport(Telerik.Reporting.Report reportToExport)

       {

           Telerik.Reporting.InstanceReportSource instanceReportSource = new Telerik.Reporting.InstanceReportSource();

           instanceReportSource.ReportDocument = reportToExport;

           ReportProcessor reportProcessor = new ReportProcessor();

           RenderingResult result = reportProcessor.RenderReport("XLSX", instanceReportSource, null);

 

           string fileName = result.DocumentName + "." + result.Extension;

 

           Response.Clear();

           Response.ContentType = result.MimeType;

           Response.Cache.SetCacheability(HttpCacheability.Private);

           Response.Expires = -1;

           Response.Buffer = true;

 

           Response.AddHeader("Content-Disposition",

                              string.Format("{0};FileName=\"{1}\"",

                                            "attachment",

                                            fileName));

 

           Response.BinaryWrite(result.DocumentBytes);

           Response.End();

       }

}

[Squall]

Just change the export format from XLSX to XPS.

[Ashraf]

Thanks for reply ,
it makes thread error , STA thread error ."

The calling thread must be STA, because many UI components require this.

"

[IvanY]

Hello Ashraf,

You will have to use a separate STA thread for the XPS export, as pointed out in our online documentation, Exporting Report Programmatically.

Regards,
IvanY
Telerik

[Ashraf]

thanks for you answer !!!!!

[shami]

hello IvanY

I am also using exactly the same code to export report in "XPS" format but it did not allow me,

the error message was, "XPS rendering format is not available" and I am not working in threads

what should I Do help plz?

[Katia]

Hello Shami,

XPS rendering extension requires some additional assemblies - Telerik.Reporting.XpsRendering.dll, Telerik.Reporting.OpenXmlRendering.dll and Open XML SDK 2.0 for Microsoft Office(DocumentFormat.OpenXml.dll v.2.0.5022.0 or above with proper binding redirect).

Those assemblies can be located in Telerik Reporting installation folder: [installation folder]\Telerik\Reporting [version]\Examples\bin and [installation folder]Telerik\Reporting [version]\Bin.

After you add references to those assemblies in your project, set their CopyLocal property to True.


Regards,
Katia
Telerik by Progress