Export Report as XLS

[Michael Faisst]

Hi there,

I'm wondering if there is any way to expert a report loaded in a report viewer as XLS via Code. Especially because the standard report viewer has the capability to export as xls via the menu, but the

"Export" function of the ReportViewer-Object or rather the ExportType-Enumeration has no XLS-Type.

Any advice would be appreciated!

Cheers,

Michael 

[Michael Faisst]

My bad, I meant XPS of course!

[Vinoth Srinivasan]

Hi Michael,

You can export the report to XPS by using the fixed document of the rendered report. ReportViewer has “GetFixedDocument()” that returns the FixedDocument format, it can be given as input to the XPS document generator as shown in below code sample. 

var package = Package.Open(dlg.FileName, FileMode.Create);

                    var xpsDoc = new XpsDocument(package, CompressionOption.Normal);

                    XpsDocumentWriter xpsWriter = XpsDocument.CreateXpsDocumentWriter(xpsDoc);

                    // xps documents are built using fixed document sequences

                    var fixedDocSeq = new FixedDocumentSequence();

                    var docRef = new DocumentReference();

                    docRef.BeginInit();

                    docRef.SetDocument(reportViewerControl.GetFixedDocument());

                    docRef.EndInit();

                    ((IAddChild)fixedDocSeq).AddChild(docRef);

                    // write out our fixed document to xps

                    xpsWriter.Write(fixedDocSeq.DocumentPaginator);

                    xpsDoc.Close();

                    package.Close();

Also we have prepared a sample based on this and it can downloaded from the below link.
http://www.syncfusion.com/downloads/support/directtrac/123606/REPORT~1-1124290928.ZIP

Regards,
Vinoth.S

[Michael Faisst]

Hi Vinoth,

works like a charm!

Thanks very much!

[Vinoth Srinivasan]

Hi Michael

Thanks for your update.

Please let us know if you need any further assistance.

Regards,
Vinoth.S