Page 1 of 3
How To Work With Large Dataset with more than 1000 records in report-js for vue 3
Posted: Thu Dec 12, 2024 10:23 am
by 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
}
Re: How To Work With Large Dataset with more than 1000 records in report-js for vue 3
Posted: Thu Dec 12, 2024 10:50 am
by Lech Kulikowski
Hello,
Please send us a sample project that reproduces the issue for analysis on
support@stimulsoft.com
Thank you.
Re: How To Work With Large Dataset with more than 1000 records in report-js for vue 3
Posted: Tue Dec 17, 2024 8:28 am
by 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,
[/url]
Re: How To Work With Large Dataset with more than 1000 records in report-js for vue 3
Posted: Tue Dec 17, 2024 8:58 pm
by 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.
Re: How To Work With Large Dataset with more than 1000 records in report-js for vue 3
Posted: Wed Dec 18, 2024 5:46 am
by 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.
Re: How To Work With Large Dataset with more than 1000 records in report-js for vue 3
Posted: Wed Dec 18, 2024 11:03 pm
by Lech Kulikowski
Hello,
You can pass data with the regData() method:
https://www.stimulsoft.com/en/documenta ... _files.htm
Thank you.
Re: How To Work With Large Dataset with more than 1000 records in report-js for vue 3
Posted: Thu Dec 19, 2024 7:04 am
by 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.
Re: How To Work With Large Dataset with more than 1000 records in report-js for vue 3
Posted: Thu Dec 19, 2024 7:24 am
by Lech Kulikowski
Hello,
Please send us a sample project that reproduces the issue for analysis on
support@stimulsoft.com
Thank you.
Re: How To Work With Large Dataset with more than 1000 records in report-js for vue 3
Posted: Thu Dec 19, 2024 10:22 am
by parth.jariwala
Hello,
I am attaching a zip file of a project that reproduces a issue. Project is in setup in VUE 3.
Thanks.
Re: How To Work With Large Dataset with more than 1000 records in report-js for vue 3
Posted: Thu Dec 19, 2024 3:30 pm
by Lech Kulikowski
Hello,
What product and version are you use?
Thank you.