How To Work With Large Dataset with more than 1000 records in report-js for vue 3

[parth.jariwala]

Right now i getting 5000 rows from my database in less than one second but when i pass those data to my .mrt file it took around 1-2 minutes to display data in report and browser crashes sometimes.
Can you help me how to deal with this large dataset??. I am attaching my code source to below
Thanks!!!

CODE:
let options = new Stimulsoft.Viewer.StiViewerOptions();
let report = new Stimulsoft.Report.StiReport();
report.loadFile("reports.mrt");
let designer = new Stimulsoft.Viewer.StiViewer(options, "StiViewer", false);
designer.report = report;
designer.renderHtml("designer");
var dataSet = new Stimulsoft.System.Data.DataSet("DsLedgerPrint");
dataSet.readJson(testJson)
report.regData(dataSet.dataSetName, "", dataSet);
designer.onPrepareVariables= function (args) {
// setting variable values
}

[Lech Kulikowski]

Hello,

Please send us a sample project that reproduces the issue for analysis on support@stimulsoft.com

Thank you.

[parth.jariwala]

CODE:

Code: Select all

let options = new Stimulsoft.Viewer.StiViewerOptions();
    options.appearance.scrollbarsMode = true;
    options.toolbar.displayMode = 1;
    options.height = '75vh';
    options.toolbar.backgroundColor = "white"
    options.toolbar.menuAnimation = true;
    options.toolbar.showPrintButton = false;
    options.exports.showExportDialog = false;
    options.exports.showExportToCsv = false;
    options.exports.showExportToJson = false;
    options.exports.showExportToDbf = false;
    options.exports.showExportToXml = false;
    options.exports.showExportToDif = false;
    options.exports.showExportToSylk = false;
    options.exports.showExportToText = false;
    options.exports.showExportToOpenDocumentWriter = false;
    options.exports.showExportToOpenDocumentCalc = false;
    options.exports.showExportToPowerPoint = false;
    options.exports.showExportToImageSvg = false;
    options.exports.showExportToImagePng = false;
    options.exports.showExportToImageJpeg = false;
    options.exports.showExportToImageSvgz = false;
    options.exports.showExportToImagePcx = false;
    options.exports.showExportToImageBmp = false;
    options.exports.showExportToImageGif = false;
    options.exports.showExportToImageTiff = false;
    options.exports.showExportToXps = false;
    options.exports.showExportDataOnly = false;
    options.exports.showExportToRtf = false;
    let report = new Stimulsoft.Report.StiReport();

    const viewer = new Stimulsoft.Viewer.StiViewer(options, "StiViewer", false);
    report.loadFile("reports/rptLEDGERREPORTNEW.mrt");
    
    viewer.report = report;
    viewer.renderHtml("designer");
    let dataSet = new Stimulsoft.System.Data.DataSet("DsLedgerPrint");
   dataSet.readJsonFile("reports/testData.json");
   report.regData(dataSet.dataSetName, "DsLedgerPrint", dataSet);

I have attached the JSON datafile and MRT file which is used in it. Can you help me with it to work faster and show data in viewer on browser without slowing down system??
Thanks,

testData.json

(6.53 MiB) Downloaded 83 times

rptLEDGERREPORTNEW.mrt

(37.13 KiB) Downloaded 86 times

[/url]

[Lech Kulikowski]

Hello,

We couldn't reproduce the issue. Your report is opened in the browser in the viewer in 10-15 seconds.

Thank you.

[parth.jariwala]

Hello,

Have you tried with duplicating data with JSON file i provided?? And also you have used the code i Provided???.

Can you reproduce the report with following JSON file and provided me code of how to load report and pass data to it??.

Thanks.

[Lech Kulikowski]

Hello,

You can pass data with the regData() method:
https://www.stimulsoft.com/en/documenta ... _files.htm

Thank you.

[parth.jariwala]

Hello,

Code: Select all

let dataSet = new Stimulsoft.System.Data.DataSet("SimpleDataSet");
dataSet.readJson({ "Datatable1": Datatable1,"DT_COMPANYMASTER": DT_COMPANYMASTER });
report.regData(dataSet.dataSetName, "", dataSet);

And it still takes too much load for report to render. Help me with to render report faster.

Thanks.

[Lech Kulikowski]

Hello,

Please send us a sample project that reproduces the issue for analysis on support@stimulsoft.com

Thank you.

[parth.jariwala]

Hello,

I am attaching a zip file of a project that reproduces a issue. Project is in setup in VUE 3.

Thanks.

[Lech Kulikowski]

Hello,

What product and version are you use?

Thank you.