JavaScript Report Viewer viewing best practices

This section explains the best practices and optimized ways to render RDL/RDLC reports in JavaScript Report Viewer.

View large records in seconds

The PerformanceSetting class provides properties that allows JavaScript Report Viewer to render the millions of records in seconds. Here are the properties associated with it:

• PageCreation
• VirtualEvaluation
• AutoGrowText
• FetchLimit

Note : For optimal rendering, please set the PageCreation property to OnDemand, VirtualEvaluation to true, AutoGrowText to false, and FetchLimit to 1000. Alternatively, you can achieve this optimal rendering setting by just adding report custom property SmartRendering as true as shown below,

Handle page creation and processing

This PageCreation enum helps to define how each page is processed and created in the Report Viewer engine.

Here, the example shows how to configure PageCreation in the ReportViewerController.

public void OnInitReportOptions(ReportViewerOptions reportOption)
{
    reportOption.ReportModel.PerformanceSetting = new BoldReports.RDL.Data.PerformanceSetting
    {
        PageCreation = BoldReports.RDL.Data.PageCreation.OnDemand
    };
}

Also you can set this property for a specific report by using the PageCreation custom property. You can set PageCreation as a custom property as shown below,

The PageCreation property must be added to report properties.

Efficient memory management in table processing

This VirtualEvaluation reuses tablix cell object to reduce memory utilization.

public void OnInitReportOptions(ReportViewerOptions reportOption)
{
    reportOption.ReportModel.PerformanceSetting = new BoldReports.RDL.Data.PerformanceSetting
    {
        VirtualEvaluation = true
    };
}

Also you can set this property for a specific report by using the VirtualEvaluation custom property. You can set the VirtualEvaluation as custom property as shown below,

The VirtualEvaluation property must be added to report properties.

Dynamic textbox size calculation

The AutoGrowText property is used to measure dynamic text height in each text box. Please note: if we set AutoGrowText to true, the viewer will take time to measure the height of each textbox cell, depending on the amount of data. For more information refer this Improve the performance while loading report with huge data

public void OnInitReportOptions(ReportViewerOptions reportOption)
{
    reportOption.ReportModel.PerformanceSetting = new BoldReports.RDL.Data.PerformanceSetting
    {
        AutoGrowText = false
    };
}

Also you can set this property for a specific report by using the AutoGrowText custom property. You can set the AutoGrowText as custom property as shown below,

Limit the data for rendering

The FetchLimit property is used to limit the number of records fetched in a report. For instance, if a report contains huge records by applying a FetchLimit of 1000 will ensure that only 1000 records will fetched from the dataset.

public void OnInitReportOptions(ReportViewerOptions reportOption)
{
    reportOption.ReportModel.PerformanceSetting = new BoldReports.RDL.Data.PerformanceSetting
    {
        FetchLimit = 1000
    };
}

Also you can set this property for a specific report by using the FetchLimit custom property. You can set the FetchLimit as custom property as shown below,

Limitations

We have provided this feature for non-grouping Tablix-based reports. However, there are a few limitations that are listed below.

1. Reports featuring nested tables are not supported.
2. Reports that include multiple tables are not supported.
3. Cells within a Tablix must contain only text; cells with images or charts are not supported.
4. Reports containing image-based content cannot be used.
5. Reports containing toggle items are not supported.
6. Reports that contain sub-reports are not supported.
7. Reports with document mapping or bookmark labels are not supported.
8. Sorting of table cells in the viewer is limited in functionality.
9. Tablix structures with repeat headers are not supported.
10. File storage cache settings are not supported.
11. Tablix structures with column groups are not supported.

View large records on demand data processing engine

The on-demand data processing engine for the report viewer enhances performance and reduces memory usage during report processing. In this on-demand data processing engine, a limited number of records are retrieved from the database in batches, rather than fetching the entire dataset at once and loading it into memory. This allows efficient rendering of tables with large datasets.

How this data processing engine will work

The on-demand data retrieval engine initially fetches top 1000 records as the first batch. As users navigate through pages, the next batch of data is fetched and processed, enhancing load times and ensuring efficient memory use. This approach allows seamless navigation without loading the entire dataset into memory, making the system scalable and resource-efficient.

Steps to enable the on demand data fetch engine

You can enable the on demand processing engine using report custom report properties or programmatically via the Performance Setting API in controller

Enable On Demand engine using report custom properties

The above mentioned properties must be added to report properties.

Enable On Demand engine using controller API

Here, the example shows how to configure OnDemand data retrieve mode in the ReportViewerController.

The PerformanceSetting class provides properties that allows to render the larger records reports on demand data processing engine. Here are the properties associated with it:

• ProcessingEngine
• DataFetchLimitPerBatch
• ExportDataFetchLimitPerBatch

This ProcessingEngine enum helps to define in which engine the report pages are processed and created in the Report Viewer.

public void OnInitReportOptions(ReportViewerOptions reportOption)
{
    reportOption.ReportModel.PerformanceSetting = new BoldReports.RDL.Data.PerformanceSetting
    {
        ProcessingEngine = ProcessingEngine.OnDemand,
        DataFetchLimitPerBatch = 1000,
        ExportDataFetchLimitPerBatch = 100000
    };
}

Note : You can use this on demand data processing engine, only if your reports does not have the below mentioned limitations.

Limitations

1. Support single table header alone if table multiple headers placed it does not support.
2. Support table contain text box alone if rectangle placed this will switch to default engine.
3. Its support only SQL data connector and PostgreSQL, and other dataset like web API or Oracle are not supported.
4. Table Repeat headers not supported.
5. Table groups as any Adjacent groups are not supported.
6. Inside table aggregations are not supported.
7. Table Keep together and keep with group are not supported.
8. Report has multiple tables then this new engine will not be support it will switch to default engine.
9. Report table data set bind with SQL stored procedure(SP) will not be support. This new engine will support only query mode.