The Report Viewer provides events and properties to control and customize the report exporting functionality.
You can show the progress information, when the exporting process takes long time to complete using the exportProgressChanged
event.
exportProgressChanged
event in Report Viewer initialization.<bold-reportviewer id="reportViewer_Control"
[reportServiceUrl] = "serviceUrl"
[processingMode] = "Remote"
[reportServerUrl] = "serverUrl"
[reportPath] = "reportPath"
(exportProgressChanged) = "onExportProgressChanged($event)">
</bold-reportviewer>
import { Component, ViewChild } from '@angular/core';
import { BoldReportsAngularModule } from '@boldreports/angular-reporting-components/src/core';
@Component({
selector: 'ej-app',
templateUrl: './app.component.html',
styleUrls: ['./app.component.css']
})
export class AppComponent {
public serviceUrl: string;
public reportPath: string;
public serverUrl: string;
constructor() {
this.serviceUrl = 'https://demos.boldreports.com/services/api/ReportApi';
this.reportPath = 'GroupingAgg.rdl';
}
onExportProgressChanged(event) {
if (event.stage === "beginExport") {
console.log(event.stage);
}
else if (event.stage === "exportStarted") {
console.log(event.stage);
}
else if (event.stage === "preparation") {
console.log(event.stage);
console.log(event.format);
console.log(event.preparationStage);
}
event.handled = true;
}
}
You can change the default file format to any other file format using the excelFormat
and wordFormat
properties. The following code sample changes the default versions.
<bold-reportviewer id="reportViewer_Control"
[reportServiceUrl] = "serviceUrl"
[processingMode] = "Remote"
[reportServerUrl] = "serverUrl"
[reportPath] = "reportPath"
[exportSettings] = "exportSettings">
</bold-reportviewer>
import { Component, ViewChild } from '@angular/core';
import { BoldReportsAngularModule } from '@boldreports/angular-reporting-components/src/core';
@Component({
selector: 'ej-app',
templateUrl: './app.component.html',
styleUrls: ['./app.component.css']
})
export class AppComponent {
public serviceUrl: string;
public reportPath: string;
public serverUrl: string;
public exportSettings: any;
constructor() {
this.serviceUrl = 'https://demos.boldreports.com/services/api/ReportApi';
this.reportPath = 'GroupingAgg.rdl';
this.exportSettings = {
excelFormat: ej.ReportViewer.ExcelFormats.Excel2013,
wordFormat: ej.ReportViewer.WordFormats.Word2013
}
}
}
Show or hide the default export types available in the component using the exportOptions
property. The following code hides the HTML export type from the default export options.
<bold-reportviewer id="reportViewer_Control"
[reportServiceUrl] = "serviceUrl"
[processingMode] = "Remote"
[reportServerUrl] = "serverUrl"
[reportPath] = "reportPath"
[exportSettings] = "exportSettings">
</bold-reportviewer>
import { Component, ViewChild } from '@angular/core';
import { BoldReportsAngularModule } from '@boldreports/angular-reporting-components/src/core';
@Component({
selector: 'ej-app',
templateUrl: './app.component.html',
styleUrls: ['./app.component.css']
})
export class AppComponent {
public serviceUrl: string;
public reportPath: string;
public serverUrl: string;
public exportSettings: any;
constructor() {
this.serviceUrl = 'https://demos.boldreports.com/services/api/ReportApi';
this.reportPath = 'GroupingAgg.rdl';
this.exportSettings = {
exportOptions: ej.ReportViewer.ExportOptions.All & ~ej.ReportViewer.ExportOptions.HTML & ~ej.ReportViewer.ExportOptions.Word
}
}
}
The PDFOptions
provides properties to manage PDF export behaviors. You should set the properties in the OnInitReportOptions
method of the Web API service.
To export reports with the complex scripts, set the ComplexScript
property of PDFOptions
instance to true.
public void OnInitReportOptions(ReportViewerOptions reportOption)
{
reportOption.ReportModel.PDFOptions = new BoldReports.Writer.PDFOptions()
{
EnableComplexScript = true
};
}
You can export the report as a PDF/A-1b
document by specifying the PdfConformanceLevel.Pdf_A1B
conformance level in the PdfConformanceLevel
property.
public void OnInitReportOptions(ReportViewerOptions reportOption)
{
reportOption.ReportModel.PDFOptions = new BoldReports.Writer.PDFOptions()
{
PdfConformanceLevel = Syncfusion.Pdf.PdfConformanceLevel.Pdf_A1B
};
}
You can add custom fonts to the PDF exported document by adding the font streams to Fonts
collection in PDFOptions
instance.
To add custom fonts to the PDF exported document, follow these steps:
.ttf
files into your application App_Data
folder.Font
collection and add the font stream to it.The key value provided in the font collection should be same as in the report item font property.
public void OnInitReportOptions(ReportViewerOptions reportOption)
{
reportOption.ReportModel.PDFOptions = new BoldReports.Writer.PDFOptions()
{
//Load Missing font stream
Fonts = new Dictionary<string, System.IO.Stream>
{
{ "Segoe UI", System.IO.File.OpenRead(System.Web.Hosting.HostingEnvironment.MapPath(@"~/App_Data/font_symbols.ttf")) }
}
};
}
If any fonts used in the report definition is not installed or available in the local system, then you should load the font stream. In the above code,
font_symbols
font stream is loaded to export theSales Order Detail.rdl
report as symbols.
The WordOptions
provides properties to manage Word document export behaviors.
You can save the report to the required document version by setting the FormatType
property.
reportOption.ReportModel.WordOptions = new BoldReports.Writer.WordOptions()
{
FormatType = BoldReports.Writer.WordFormatType.Docx
};
Eliminate the tiny columns, rows, and merged cells and render the word document elements without nested grid layout by setting the LayoutOption
to TopLevel
. The ParagraphSpacing
is the distance value added between two elements in the document.
reportOption.ReportModel.WordOptions = new BoldReports.Writer.WordOptions()
{
LayoutOption = BoldReports.Writer.WordLayoutOptions.TopLevel,
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 the word document is not a stand-alone object. If you draw two tables one after another, it will automatically get merged into a single table. To prevent this merging, added an empty paragraph between two tables.
You can restrict a Word document from editing either by providing a password or without password. The following are the types of protection:
AllowOnlyComments
: Adds or modifies only the comments in the Word document.AllowOnlyFormFields
: Modifies the form field values in the Word document.AllowOnlyRevisions
: Accepts or rejects the revisions in the Word document.AllowOnlyReading
: Allows you to view the content only in the Word document.NoProtection
: Accesses or edits the Word document contents as normally. reportOption.ReportModel.WordOptions = new BoldReports.Writer.WordOptions()
{
ProtectionType = Syncfusion.DocIO.ProtectionType.AllowOnlyReading
};
The ExcelOptions
provides properties to manage Excel document export behaviors.
You can save the report to the required excel version by setting the ExcelSaveType
property.
reportOption.ReportModel.ExcelOptions = new BoldReports.Writer.ExcelOptions()
{
ExcelSaveType = BoldReports.Writer.ExcelVersion.Excel2013
};
Eliminate the tiny columns, rows, and merged cells to provide clear readability and perform data manipulations by setting the LayoutOption
to IgnoreCellMerge
.
reportOption.ReportModel.ExcelOptions = new BoldReports.Writer.ExcelOptions()
{
LayoutOption = BoldReports.Writer.ExcelLayoutOptions.IgnoreCellMerge
};
You can restrict the Excel document from editing either by providing the ExcelSheetProtection
or enabling the ReadOnlyRecommended
properties.
reportOption.ReportModel.ExcelOptions = new BoldReports.Writer.ExcelOptions()
{
ReadOnlyRecommended = true,
ExcelSheetProtection = ExcelSheetProtection.DeletingColumns
};
You can save the report to the required PowerPoint version by setting the FormatType
property.
reportOption.ReportModel.PPTOptions = new BoldReports.Writer.PPTOptions()
{
FormatType = BoldReports.Writer.PPTSaveType.PowerPoint2013
};
The CsvOptions
allows you change encoding, delimiters, qualifiers, extension, and line break of a CSV exported document.
reportOption.ReportModel.CsvOptions = new BoldReports.Writer.CsvOptions()
{
Encoding = System.Text.Encoding.Default,
FieldDelimiter = ",",
UseFormattedValues = false,
Qualifier = "#",
RecordDelimiter = "@",
SuppressLineBreaks = true,
FileExtension = ".txt"
};
You can hide the separator added at the end of each page by setting the HidePageSeparator
property to true.
reportOption.ReportModel.HTMLOptions = new BoldReports.Writer.HTMLOptions()
{
HidePageSeparator = true
};
Allows you protect the exported document such as PDF, Microsoft Word, Microsoft Excel, and PowerPoint from unauthorized users by encrypting the document using encryption password. The following code snippet demonstrates how to encrypt the exported document with user defined password.
public void OnInitReportOptions(ReportViewerOptions reportOption)
{
//PDF encryption
reportOption.ReportModel.PDFOptions = new BoldReports.Writer.PDFOptions();
reportOption.ReportModel.PDFOptions.Security = new Syncfusion.Pdf.Security.PdfSecurity()
{
UserPassword = "password"
};
//Word encryption
reportOption.ReportModel.WordOptions = new BoldReports.Writer.WordOptions()
{
EncryptionPassword = "password"
};
//Excel encryption
reportOption.ReportModel.ExcelOptions = new BoldReports.Writer.ExcelOptions()
{
PasswordToModify = "password",
PasswordToOpen = "password"
};
//PPT encryption
reportOption.ReportModel.PPTOptions = new BoldReports.Writer.PPTOptions()
{
EncryptionPassword = "password"
};
}
Password protection is not supported for HTML export format.