run report using node-jasper

[itranga]

I have attached my jrxml here .

How do i run this report using node-jasper ? I mean how do i pass 'data: ..' .here . Do you have example for mysql ?

app.get('/pdf', function(req, res, next) { //beware of the datatype of your parameter. var report = { report: 'hw', data: { id: parseInt(req.query.id, 10) secundaryDataset: jasper.toJsonDataSource({ data: ... },'data') } dataset: //main dataset }; var pdf = jasper.pdf(report); res.set({ 'Content-type': 'application/pdf', 'Content-Length': pdf.length }); res.send(pdf); });

..................................................................................................

WHERE b.date = '2021-11-17' UNION ALL SELECT 2 sort,a.batchid, g.name compname, c.batchcode, c.batchvehicleno, c.date, d.routename, a.container, h.name supname, b.itmdesc, a.finaldrc, a.kgs, a.liters, a.metrolac, a.nh3, a.remarks, a.sampledrc, a.tz, a.temp, 0 accqty, 0 accltr, 0 dryweightdif, 0 findryweight, 0 fldltr, 0 fldqty, 0 invqty, 0 samdryweight, ' ' vfa, ' ' drc FROM batchitempicitem a INNER JOIN itemmaster b ON a.companyid = b.companyid AND a.itemmasterid = b.id INNER JOIN batch c ON a.batchid = c.id INNER JOIN route d ON c.companyid = d.companyid AND c.locationid = d.locationid AND c.routeid = d.id LEFT OUTER JOIN batchitem e ON a.companyid = e.companyid AND a.batchid = e.batchid AND a.batchitemid = e.id INNER JOIN location f ON a.companyid = f.companyid AND a.locationid = f.id INNER JOIN company g ON a.companyid = g.id INNER JOIN custsup h ON a.companyid = h.companyid AND h.custsup = 'S' AND e.custsupid = h.id WHERE DATE(c.date) = '2021-11-17' ) X ORDER BY batchcode,sort,supname,container]]> </queryString> <groupExpression></groupExpression> <groupHeader> <band height="35" splitType="Stretch"> <textField isBlankWhenNull="false"> <reportElement key="textField" x="0" y="21" width="59" height="13" uuid="8abbe83b-371f-41a9-a4c3-9bfbf210b2d5"/> <textElement> <font fontName="Times New Roman" isBold="true" pdfFontName="Helvetica-Bold"/> </textElement> <textFieldExpression></textFieldExpression>

..........................................................