general forum

• M

  docxTable merged cells
  • mettjus

  4
  4
  Posts
  7682
  Views

  M

  ps: just to be clear, the data set behind the above example would be

  [ { "datalogger": "PLV_CEM01", "data": [ {"date": "15/10/2019", "qty": 117.6}, {"date": "14/11/2019", "qty": 192.8}, {"date": "20/12/2019", "qty": 93.2}, {"date": "02/03/2020", "qty": 69.4} ], "aggregated_qty": 625.2 }, { "datalogger": "PLV_PAR01", "data": [ {"date": "15/10/2019", "qty": 122.4}, {"date": "14/11/2019", "qty": 205.8} ], "aggregated_qty": 669.6 }, { "datalogger": "PLV_PAR02", "data": [ {"date": "15/10/2019", "qty": 120.2}, {"date": "14/11/2019", "qty": 172.2}, {"date": "20/12/2019", "qty": 81.6} ], "aggregated_qty": 587.6 } ]
• A

  Convert HTML to pdf report and download in Angular and Fastify
  • apekshawatane

  2
  2
  Posts
  6807
  Views

  

  hi! how are you trying to use jsreport in your app? i ask this because, in node.js, jsreport can be integrated in two modes.

  1.- you can run jsreport standalone, and this means that it is basically a separate app/server.
  2.- you can attach jsreport into an existing express app, and this means that jsreport is just a set of routes specially designed for reporting inside of your app/server

  if you are using fastify, i think your best option will be to try option 1.

  in both cases, when you need to render something from the front-end, all you need to do is a http request from the browser to the jsreport server/routes, we provide a generic browser client to abstract the http requests, this should work in any browser. however since angular has its own way to do http request, you will need to search a bit and replicate the http request to the jsreport server in the angular way. we don't have experience with angular so that is why there is no example with it, however, this should not be too difficult to achieve. here you can find some details about the http request that you need to do.

• C

  Enterprise license Expiration Date
  • chriscrowley

  3
  3
  Posts
  9561
  Views

  C

  That's great news! That gives us more than enough time to have them renew the license. Thanks!

• C

  Shared Script
  • chriscrowley

  2
  2
  Posts
  7482
  Views

  

  One option is to use environment variables to reach connection strings
  https://jsreport.net/learn/scripts#environment-variables-and-configuration

  Another option is to create one script and mark it as global.
  It will run every time and you can set the connection string to req.options.connectionString for example and reach it there in your other scripts.
  https://jsreport.net/learn/scripts#global-scripts

  The third option is to use assets, store there a json with a connection string, and embed it to every script.
  let connectionString = "{#asset connectionString.json @encoding=string}"
  https://jsreport.net/learn/assets

• S

  Excel template deprecated?
  • Samerkassem

  2
  2
  Posts
  8027
  Views

  

  It will be removed at the beginning of the next year in the v3 release.
  Just download the xlsx template "table-chart", upload it as an asset, and reference it in the "xlsx asset" field.

• W

  Would adding aws-s3-storage feature bump the zipped layer by 13MB?
  • weisisheng

  9
  9
  Posts
  18975
  Views

  W

  We can close this for now. I realized I was adding the "aws-sdk" in dependencies which was bloating the layer significantly. It is already included with lambda although best practice is to pin against a specific version. When I get some time, I will look at adding multiple layers or slimming puppeteer further. Thank you!

• W

  how to loop over sample (local) data?
  • weisisheng

  2
  2
  Posts
  5399
  Views

  

  The "invoice" example also uses each loop over sample data. Please check it out.
  https://playground.jsreport.net/w/admin/hBfqC7af

  If you still encounter problems, please create a playground workspace replicating the issue and share it here.
  Thank you

• D

  Intermittent error An error has occurred when trying to initialize jsreport (2). Duplicated entry for key samples (1)
  • dasaev

  5
  5
  Posts
  10832
  Views

  D

  Thank you for your help! Actually, i could've been wrong. Upon double checking, the last failure we saw may not have had the changes above. I will update you if we see this failure again (it's very intermittent for us).

• P

  docxRaw helper
  • pdecat

  4
  4
  Posts
  14122
  Views

  P

  Turns out this way of doing is not compatible with every docx editor, e.g. Word Online displays a broken table and Libreoffice drops the <w:r> tag altogether as it is in a <w:t>.

  I've submitted a PR to try and implement an real docxRaw helper: https://github.com/jsreport/jsreport-docx/pull/23

  Feedback welcome :)

• S

  Azure blob storage not working.
  • Samerkassem

  4
  4
  Posts
  14925
  Views

  S

  Yes, you're right, yesterday I tried it without the azure-sb and it worked, but I don't know why it is crushing on the connection sb string (required by bus).

  Currently I don't need more than one instance, but I'll have to look into it later.

• H

  Issue fetching correct data
  • hazvick

  2
  2
  Posts
  5642
  Views

  

  @hazvick hi! i'm afraid that we won't be able to help so much if we don't see the code that fetch the data, and how it works with the response, according to the error you are describing it seems like a mistake of not using the right variable, this is my best guess without seeing the code

• W

  Really stumped on aws-s3-storage error
  • weisisheng

  2
  2
  Posts
  5252
  Views

  

  Please share the full jsreport startup log/output and how your dockerfile looks like.
  It seems you installed jsreport-azure-storage instead of jsreport-aws-s3-storage.

• W

  This topic is deleted!
  • weisisheng

  1
  1
  Posts
  7
  Views

  No one has replied

• 

  Sample reports will not preview on AWS ami deployment
  • Mike Lim

  10
  10
  Posts
  16563
  Views

  

  Hm, I can't replicate this.
  Maybe something on your network is closing the request. The error "request aborted" could mean that it was aborted by client.

  This is what I do exactly:

  Launch Small EC2 instance
  Ubuntu Server 20.04 LTS (HVM), SSD Volume Type - ami-0c960b947cbb2dd16 (64-bit x86) / ami-0aa72f02ca1be5339 (64-bit Arm)
  64-bit (x86)

  Keep the defaults and just add security policy
  Custom TCP Rule TCP 5488 Anywhere

  Then I ssh to the machine and run the following commands

  # install node.js wget -qO- https://raw.githubusercontent.com/creationix/nvm/v0.33.11/install.sh | bash # you may need to reopen terminal nvm install 8.11.3 mkdir jsreportapp cd jsreportapp npm i -g jsreport-cli jsreport init jsreport configure # chrome dependencies sudo apt-get install -y libgconf-2-4 sudo wget -q -O - https://dl-ssl.google.com/linux/linux_signing_key.pub | sudo apt-key add - sudo sh -c 'echo "deb [arch=amd64] http://dl.google.com/linux/chrome/deb/ stable main" >> /etc/apt/sources.list.d/google.list' sudo apt-get update sudo apt-get install -y google-chrome-unstable fonts-ipafont-gothic fonts-wqy-zenhei fonts-thai-tlwg fonts-kacst --no-install-recommends # on ubuntu 20 run also sudo apt-get install -y libxtst6 libxss1 # start jsreport to see it running on port 5488 jsreport start

  Then I open in the browser http://ec2ipaddress:5488. I see the studio. I can open the invoice sample and render it.

• S

  Issue with Azure functions
  • Samerkassem

  2
  2
  Posts
  9445
  Views

  

  In case the function is properly deployed, you should be able to render this way all the templates you prepared and have them stored in the data folder.

  jsreport returns 400 when the report rendering fails during the templating engine evaluation for example.
  The 400 error response body should contain some additional information. See how we handle errors in our azure functions starter kit.
  Also, jsreport writes by default to the stdout the logs, you should be able to reach this in the azure function and get more information there as well.

• S

  Applying License key to Azure Functions?
  • Samerkassem

  2
  2
  Posts
  9310
  Views

  

  The license key can be applied as every jsreport configuration
  https://jsreport.net/learn/configuration

  You have multiple ways, but the easiest is typically to use jsreport.config.json configuration file and add

  "licenseKey": "XXXX"`

  When you follow azure functions tutorial, you should add it to both jsreport.config.json and prod.config.json.

  The second puplar option is to use environment variables to configure jsreport. In the case of the azure functions, you can set environment variables in azure portal in the Configuration/Application Settings menu. There you can add licenseKey with proper value.

• S

  Also....a problem in jsReport Azure web app
  • Samerkassem

  2
  2
  Posts
  8911
  Views

  S

  I am stupid, i mixed up between 2.1.0 and 2.10

  i am happy with Azure web app and it's way faster than the Azure functions jserport (which is not working as expected).

  Azure web app is working as expected and successful generated reports via post.

• 

  Display data into add-on template, which is attached to the main one with the help of pdf-utils
  • Руслан Ахметвалеев

  5
  5
  Posts
  12110
  Views

  

  Array items[4] returns in my case a number for rows unification. array items [5] returns data on if digital signature is correct or not. I am putting #each in #each to display items[5] value in unified column, which uses colspan property comming from items[4], so colspan ={{strCount}}.

  This may not be the right approach, but I don’t know how to concatenate a column using the colspan parameter outside of #each yet. And then insert into the table the value from the items [5] array..

  Thanks for the help, I will understand further.

• M

  PDF Utils, TOC and multiple page formats
  • msageryd

  8
  8
  Posts
  19617
  Views

  M

  Thanks Jan.
  This would be awesome. I'm hoping for a solution.

• P

  Prevent docxChart errors to fail the complete render?
  • pdecat

  5
  5
  Posts
  18038
  Views

  P

  I'm already using Studio configured to detect filesystem changes, but I'm editing the template document in Word Online as I cannot use Word directly on linux and editing with Libreoffice causes formatting issues. So, I'm downloading a copy once in a while. Poor workflow, I agree...

  An odt recipe would be awesome!