general forum

• F

  How can I merge docx with barcode?
  • Footfall

  9
  9
  Posts
  8211
  Views

  F

  I'll try, thank you for help

• 

  Can you please explain about components in jsreport
  • Reshma Jacob

  4
  4
  Posts
  5630
  Views

  

  Complexity is meant as it's common in software coding.
  If you have a big function in code, you typically decompose it into several smaller functions.
  The same applies to jsreport templates. If you have a lot of code in the template, you can decompose the template into several smaller components.

  The components example is in the docs
  https://playground.jsreport.net/w/admin/mcb0pE1a

• H

  How to use shared js file for multiple templates
  • Happy Patel

  12
  12
  Posts
  14039
  Views

  H

  Thanks! @jan_blaha

• G

  NPM Fetch issue
  • geoffatsource

  2
  2
  Posts
  2684
  Views

  G

  Weird. Seems to have fixed itself!

• H

  We're sorry, we couldn't open your workbook. It's possibly corrupt or using a file format that's not supported.
  • Harishkanagvel

  2
  2
  Posts
  3209
  Views

  

  hi @Harishkanagvel

  it is likely some of your xlsx transformations is causing this. you can try to comment some parts and try again until you get a not corrupted xlsx, you will be able to identify which xlsx helper call is causing that problem and probably be able to adapt it and fix it.

• A

  How missing image/ failed download image for docxImage
  • andy-yeung-raspect

  2
  2
  Posts
  2486
  Views

  

  You can implement a custom helper, that will check the existence of the remote image and fall-back into a custom image if it cannot reach it.

  const jsreport = require('jsreport-proxy') const fallbackImgSrc = 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAK8AAAAtCAIAAABXiKzxAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAgdSURBVHhe7Zj9T1NXGMeX/brsD1iWJZtZtv2wDbVoeRNqQUFaaXlTQJGIjGWmugW2xfoSDA6WaRHHL84tEzZXnNJoeNFVnVQddQhVpC6jikuj7iaGGg3l7fJ2u3PPObf3lRYEEmTnk/7Afc5zzrnP83w5L/clFYHAQdRA4CFqIPAQNRB4iBoIPEQNBB6iBgIPUQOBh6iBwEPUQOAhaiDwEDUQeIgaCDxzpoaCgoL6+vqurq7e3t47d+40Njbu2LFjxYoVuJnwIjAHatBoNC0tLQElXC6X0WjEfoQFz2zVoNVqwUqAi69En8+Xk5ODvQkLm+dXg1qtXhWfcOHiJVz2QKCnp8disezcubO8vLy9vR1bA4F7vb3xCQm42/SxOH2039NUjB9faEw2t4+GyaAcJdi2AHkeNSQb0nWH618/+XdOWx/DMDDIQENDw8qVK7EHBCgDNQG+qjmKrdPH6gb5oxxm/PgCU+b0gRz4KZfDbq8tw8aFyIzVkF2y99XmJ69cGHj5/MBpahwVu7u7WyIFxNmzZ5HDH3cfLI+KxdZFR5MXhOhtwk8yzKwYaHctflzAzEwNEQWfvtE6+NrlwSWND3WVP3j+fYyKfeDAAewhBlw0kMPQREC9q3pZbDxuWFyEUYPF5Qcrg8uCHxcwM1DD8ui49073vNU6pG74S7s2OTo6+vFjrIbCwkLsJCYpKam/vx84gO3E2DnyZuOj94t24bawSJKoN1tdFLBA/D6PvUKPGrCf3UmxOzPXQehO+71Bb1Q6j13QSrmsJtyIMFmdXj/a5lHfXNwgm6uVfRYgkwScjScYjr7C7vFxfcEeYjVz76cUj0xuwtzgv2324Dv7KWdNLohCOQEhmJ4aIiMjUrOWln3/4bXhJVeGDfls7WNiYh49eoRmKy0tRY4S0tPTR0dHgcPo+ISx3f/O1eG3rwxn7/4aN4dGGLFKb/WAUGmfG2y9dgc6kvmccA+Gfiy0z+v1upvYg4apyQs80E5tB6XlvYP18XudbJsHDgXWcS5ZxbArbnaghIK3QM3Sub4pLjGbzQ4KWMAJx2w2BXWDyTWZzVY3G4jbCtpLiuE4aBiagtGgV6C9TViSCvGEVwPrDofDbxzwA2mg+PkYYNdQhFdDanpmwonrS9tGVM6RiLaReNsd3KBStbW1sRMHAi0tLdgkprq6Gjl4HzyMztj0wU8dy50j7/7er98gzZoCwohRPig7VzIkDr+rAvyNshEsGAAUFHoH/+NNsF4eK/s3bBN6ozMeZUeXlxr27CpsRsISKU/YzCIrlhhRIIBiO1QP/3p6NKzHBkdVmGMaahBFywYktNSioNhshSSMGlKNGZG/UcucdPR1Ouri4whHv/4YX/iKigp2WsiuXdItIC8v79mzZ6j151MNwLJ89Vr1uQcRTjq1xoZ8QiFKIiqSR7CgBhH5sehh8lDtMfAgh3zkpdPD6iATzJvPKbrICGyyuSAzU0OxQJocQpvCHOHVIPKH7vy/DoC1yF5bThg1JB9vXXF9NMbxVL19rypmlVqTpE1ag9tUKnB06OnpATMDxsbGamtrjUZjXFxcSkrKwYMHg1IYGhrKyMxCXaLKvov5c3TNuX/UajWyTIk4SpPVDRUPTD6v21FbJt3L+VChQQHko1A62AGVW7Gw0AhLJc88i2InHkknxTEEr6DQLptA6CP3l78Pa5FOqUAoNaxLM0a1DSZ2jMWXKqwx4L6wf/9+i8WCzokIcEro6+sbHh7GzxCwhOA+QA0ffaHpGFt/zbdaq8WmqZBHmWuqsTndXnz6AjsxXNxlftBAw31fhM3C+iuUDnaYWg1o7fi/q2Fz8faEjvH0GwNxyTps4jh06BCYEDAwMHDmzJngcVICTdOVlZW4DyS2tHJN57ihlYqNi8OmqRBGyR7GBEc0vRkWSHBuEIaKl120C8uQp2px7hRzrYaNW4sSXRMZXWMJxg3YBBF+ZAR0dnYmJibW1dVRFDU5OYmMT548aW5uzs7Oxn041py8kXxzIuOkEz+HQBil1QPG5G4FLDB9qFGeDTM8RvmcgkuVyWa3oTMHTBVwD7ahI+YMTpGiuVhmpoZpnSLFc0hNehubD2yQ+8+LGjTaxJSrPuPtyaRv+UNfVVUVmEpIR0cHaoqMjNTpdLm5uQaDQfFYoCk/lg5Gc01uKtmNTSEQRYnyhe9k+M5Iu2tkfgicXtrngdsFusP5XTUFoA2mKtjmcHO3eq784W+YsrRCBdGUi9uMJMg7iaJRvGFK5oAziC/FQR+5/7yoAZBXdXzdLSa7m1n346WYAtPnh4/C9+AZZQL7jp1Iyy/MKtqesfVjw5ZthvxC45Zt4G9gwb9tn2z+sizt1/asbib9NrPpl8t49NBIohR9r6FBYrhPRkrZk7jDj1V4n4Gpohyz+vokTavJ5kGDgfUImwQodQr/9Uk8B/CH/wGcu4Mvr9x/vtQQFR2db2013GYyu5nP7jI03gcw40zgyINAyi0mtYvRhfyt72I2uJmNbialrjV21fS+T0+R+dkiTxWBI4waAGDNz9t3UH/uXnnPEBIBYmxi4si9wYyOwfybQ2F/m9ufZto6taY9YDvB44YFqoFyKCy9s4KoYWrCqyHIulTd/fv3kRTATdK8Z49mtXZtcsp0fgkaDR5lWpTV4q/P+GgwlxA1TM0M1ABIS0s7derU+fPni4qKsGlegBUDu7BbsqHPBUQNUzMzNRAWN0QNBB6iBgIPUQOBh6iBwEPUQOAhaiDwEDUQeIgaCDxEDQQeogYCh0r1H3rynmXRZBCKAAAAAElFTkSuQmCC' const axios = await jsreport.npm.require('axios@0.27.2') async function docxImageWithFallback(options) { try { await axios.get(options.hash.src) return docxImage(options) } catch (e) { options.hash.src = fallbackImgSrc return docxImage(options) } }

  https://playground.jsreport.net/w/anon/2R6FUdOX

• D

  JS heap out of memory - bwip-js
  • danielferenc

  6
  6
  Posts
  5751
  Views

  

  Update: This is actually really a bug. It is likely a nodejs bug that started to occur since nodejs 16.
  We've implemented a workaround which we are testing now.

• 

  JSReport Studio User Different Password per Environment
  • Matthew Kee

  2
  2
  Posts
  2481
  Views

  

  You can make the following change to your server.js file which boots jsreport.
  This will update the jsreport user password during the startup to an env variable value,

  const jsreport = require('jsreport')() if (process.env.JSREPORT_CLI) { // export jsreport instance to make it possible to use jsreport-cli module.exports = jsreport } else { jsreport.init().then(() => { // *** here is the change return jsreport.documentStore.collection('users').update({ username: 'jsreport' }, { $set: { password: require('password-hash').generate(process.env.YOUR_VARIABLE) } }) // *** change end // running }).catch((e) => { // error during startup console.error(e.stack) process.exit(1) }) }
• 

  502 Bad Gateway .NET long data XLSX
  • Haritz Lopez

  4
  4
  Posts
  5089
  Views

  

  I have installed localy and I am making some new tests. How could I change the xlsx.maxRows and xlsx.bufferSize? I am getting an error if the json is too big. with 15000 rows now works but with 20000 no.

  preview error Got not ok response, status: 500 Error: Got not ok response, status: 500 at http://localhost:5488/studio/assets/client.a5efe5637ea659b2401f.js:41:78261 at m (http://localhost:5488/studio/assets/client.a5efe5637ea659b2401f.js:311:73091) at Generator._invoke (http://localhost:5488/studio/assets/client.a5efe5637ea659b2401f.js:311:72844) at forEach.e.<computed> [as next] (http://localhost:5488/studio/assets/client.a5efe5637ea659b2401f.js:311:73271) at i (http://localhost:5488/studio/assets/client.a5efe5637ea659b2401f.js:3:368084) at http://localhost:5488/studio/assets/client.a5efe5637ea659b2401f.js:3:368181

  I changed already the timeout value.

  { "httpPort": 5488, "store": { "provider": "fs" }, "blobStorage": { "provider": "fs" }, "logger": { "console": { "transport": "console", "level": "debug" }, "file": { "transport": "file", "level": "info", "filename": "logs/reporter.log" }, "error": { "transport": "file", "level": "error", "filename": "logs/error.log" } }, "trustUserCode": false, "reportTimeout": 60000000, "workers": { "numberOfWorkers": 2 }, "extensions": { "authentication": { "cookieSession": {}, "admin": { "username": "admin", "password": "password" }, "enabled": false } } }
• 

  Use SEQ as a transport for winston logging of errors inside JSReport
  • Matthew Kee

  3
  3
  Posts
  3332
  Views

  

  Worked like a charm. Thanks for all the help!

• 

  Xlsx recipe much slower than html-to-xlsx
  • Manu Latasa

  6
  6
  Posts
  5317
  Views

  

  Yes, we are currently implementing optimizations. I let you know when I have some details when we ship it.

• D

  Changing & to &amp;
  • dpkpanchal-hg

  5
  5
  Posts
  4346
  Views

  D

  It is working for me Thank you

• A

  Merge Page Number Overwriting for every page
  • aravinthvr

  4
  4
  Posts
  5007
  Views

  

  https://stackoverflow.com/questions/16183748/how-to-escape-html-in-node-js-ejs-view
  ejs is probably escaping it, try using this

  <%- pdfAddPageItem(content1) -%>

• A

  JSReport Studio in Kubernetes Write Back To Host FS On Save
  • amihaiemil

  2
  2
  Posts
  2751
  Views

  

  It seems you should use kubernetes volumes and mount it from the host to the pod jsreportapp/data path.
  https://kubernetes.io/docs/concepts/storage/volumes/

  However, I am not Kubernetes expert as well. This is more a general kubernetes question and you may get better answers in kubernetes or general dev forums like stackoverflow.

• D

  Subreport - trying to call and run from main report
  • dqueubed

  15
  15
  Posts
  13161
  Views

  D

  @bjrmatos ... great food for thought. We do indeed feed data to our reports dynamically and render from a script, but I'm always curious about options and other opportunities, so I may mess around with the browser-based method as well. In all instances, I am most appreciative of your help here. Thanks as always for your support ... you guys are awesome.

• 

  Higher timeout on the SaaS Solution
  • Felipe Gaya Scandiffio

  6
  6
  Posts
  5363
  Views

  

  Going to send you the data.json file via email

  One weird thing that I noticed: this report without images is 1.9Mb and with images is 80Mb
  But all the images together are around 3Mb

  I send those images as s3 signed urls and jsreport download them, idk if something happens on the render that makes this pdf so much bigger

  Just FYI, my SaaS solution is basically checklists that the user can create and later generate reports about it

• 

  log files delete
  • FuckOffWorld_

  4
  4
  Posts
  3657
  Views

  

  https://jsreport.net/learn/configuration#logging

• M

  Footer breaking to next page
  • Mike-Taiki

  4
  4
  Posts
  3639
  Views

  M

  @jan_blaha I am importing fonts ttf file and using as an asset like is on the playground.

• C

  browser client not print
  • Chago Morales Andrade

  4
  4
  Posts
  4979
  Views

  

  I've tried the following code and the download works for me.

  jsreportInit = function () { jsreport.serverUrl = 'http://localhost:5488' jsreport.renderAsync({ template: { recipe: 'chrome-pdf', engine: 'none', content: 'hello' } }).then(function (res) { var html = '<html>' + '<style>html,body {padding:0;margin:0;} iframe {width:100%;height:100%;border:0}</style>' + '<body>' + '<iframe type="application/pdf" src="' + res.toObjectURL() + '"></iframe>' + '</body></html>'; var a = window.open("about:blank", "Report") a.document.write(html) a.document.close() }) }
• H

  Australia date format (DD Month YYYY) is not working in 2.11.0 version of jsreport
  • Happy Patel

  7
  7
  Posts
  8300
  Views

  H

  Thanks @bjrmatos