Export report

To control and customize report export in the Bold Reports® WPF Report Viewer, use its export properties. You can set PDF, Word, Excel, PowerPoint, CSV, and HTML options, protect exported documents, and change the file name and image quality.

PDF export options

The PDFOptions class provides properties to manage PDF export behaviors in the WPF Report Viewer. Set the properties in the application window loaded method.

How do I export reports with complex scripts?

To export reports with complex scripts from the WPF Report Viewer, set the EnableComplexScript property of the PDFOptions instance to true.

this.reportViewer.PDFOptions = new BoldReports.Writer.PDFOptions()
{
    EnableComplexScript = true
};

PDF conformance

To export the report as a PDF/A-1b document from the WPF Report Viewer, specify the conformance level PdfConformanceLevel.Pdf_A1B in the PdfConformanceLevel property.

this.reportViewer.PDFOptions = new BoldReports.Writer.PDFOptions()
{
    PdfConformanceLevel = Syncfusion.Pdf.PdfConformanceLevel.Pdf_A1B
};

Word export options

The WordOptions class provides properties to manage Word document export behaviors in the WPF Report Viewer.

Word document type

To save the report to the required Word document version, set the FormatType property.

this.reportViewer.WordOptions = new BoldReports.Writer.WordOptions();
this.reportViewer.WordOptions.FormatType = BoldReports.Writer.WordFormatType.Docx;

Word document advance layout for merged cells

To eliminate tiny columns, rows, and merged cells, and render the Word document elements without nested grid layout, set the LayoutOption to TopLevel. The ParagraphSpacing is the distance value added between two elements in the document.

this.reportViewer.WordOptions = new BoldReports.Writer.WordOptions();
this.reportViewer.WordOptions.LayoutOption = BoldReports.Writer.WordLayoutOptions.TopLevel;
this.reportViewer.WordOptions.ParagraphSpacing = new BoldReports.Writer.ParagraphSpacing()
{
    Bottom = 0.5f,
    Top = 0.5f
};

A paragraph element is inserted between two tables in the exported document to overcome word document auto merging behavior. The table in a Word document is not a stand-alone object. If you draw two tables one after another, they are automatically merged into a single table. To prevent this merging, an empty paragraph is added between two tables.

How do I protect an exported Word document from editing?

To protect a Word document exported from the WPF Report Viewer, restrict editing either with a password or without a password. The following are the types of protection.

  1. AllowOnlyComments: You can add or modify only the comments in the Word document.
  2. AllowOnlyFormFields: You can modify the form field values in the Word document.
  3. AllowOnlyRevisions: You can accept or reject the revisions in the Word document.
  4. AllowOnlyReading: You can only view the content in the Word document.
  5. NoProtection: You can access or edit the Word document contents as normally.
this.reportViewer.WordOptions = new BoldReports.Writer.WordOptions();
this.reportViewer.WordOptions.ProtectionType = Syncfusion.DocIO.ProtectionType.AllowOnlyReading;

Excel export options

The ExcelOptions class provides properties to manage Excel document export behaviors in the WPF Report Viewer.

Excel document type

To save the report to the required Excel version, set the ExcelSaveType property.

this.reportViewer.ExcelOptions = new BoldReports.Writer.ExcelOptions();
this.reportViewer.ExcelOptions.ExcelSaveType = BoldReports.Writer.ExcelVersion.Excel2013;

Excel document advance layout for merged cells

To eliminate tiny columns, rows, and merged cells for clear readability and data manipulation, set the LayoutOption to IgnoreCellMerge.

this.reportViewer.ExcelOptions = new BoldReports.Writer.ExcelOptions();
this.reportViewer.ExcelOptions.LayoutOption = BoldReports.Writer.ExcelLayoutOptions.IgnoreCellMerge;

How do I protect an exported Excel document from editing?

To protect an Excel document exported from the WPF Report Viewer, restrict editing either by providing the ExcelSheetProtection or enabling the ReadOnlyRecommended properties.

this.reportViewer.ExcelOptions = new BoldReports.Writer.ExcelOptions()
{
    ReadOnlyRecommended = true,
    ExcelSheetProtection = Syncfusion.XlsIO.ExcelSheetProtection.DeletingColumns
};

PowerPoint export options

To save the report to the required PowerPoint version in the WPF Report Viewer, set the FormatType property.

this.reportViewer.PPTOptions = new BoldReports.Writer.PPTOptions();
this.reportViewer.PPTOptions.FormatType = BoldReports.Writer.PPTSaveType.PowerPoint2013;

CSV export options

The CsvOptions class lets you change the encoding, delimiters, qualifiers, extension, and line break of a CSV document exported from the WPF Report Viewer.

this.reportViewer.CsvOptions = new BoldReports.Writer.CsvOptions()
{
    Encoding = System.Text.Encoding.Default,
    FieldDelimiter = ",",
    UseFormattedValues = false,
    Qualifier = "#",
    RecordDelimiter = "@",
    SuppressLineBreaks = true,
    FileExtension = ".txt"
};

HTML export options

To hide the separator added at the end of each page in an HTML export from the WPF Report Viewer, set the HidePageSeparator property to true.

this.reportViewer.HTMLOptions = new BoldReports.Writer.HTMLOptions();
this.reportViewer.HTMLOptions.HidePageSeparator = true;

How do I password protect an exported document?

To protect an exported PDF, Word, Excel, or PowerPoint document from unauthorized users, encrypt the document with an encryption password in the WPF Report Viewer. The following code snippet illustrates how to encrypt the exported document with a user-defined password.

//PDF encryption
this.reportViewer.PDFOptions = new BoldReports.Writer.PDFOptions();
this.reportViewer.PDFOptions.Security = new Syncfusion.Pdf.Security.PdfSecurity()
{
    UserPassword = "Password"
};

//Word encryption
this.reportViewer.WordOptions = new BoldReports.Writer.WordOptions()
{
    EncryptionPassword = "password"
};

//Excel encryption
this.reportViewer.ExcelOptions = new BoldReports.Writer.ExcelOptions()
{
    PasswordToModify = "password",
    PasswordToOpen = "password"
};

//PPT encryption
this.reportViewer.PPTOptions = new BoldReports.Writer.PPTOptions()
{
    EncryptionPassword = "password"
};

Password protection is not supported for HTML export format.

How do I change the file name of an exported report?

To change the file name of a report exported from the WPF Report Viewer, use the FileName property.

this.reportViewer.ExportSettings = new BoldReports.Writer.ExportSettings();
this.reportViewer.ExportSettings.FileName = "Invoice";

How do I change the image quality in an exported report?

To change the image quality of data visualization items in a report exported from the WPF Report Viewer, use the ImageQuality property.

this.reportViewer.ExportSettings = new BoldReports.Writer.ExportSettings();
this.reportViewer.ExportSettings.ImageQuality = 4;