general forum

• P

  Update Template Schedule with API
  • palphonse

  6
  6
  Posts
  10905
  Views

  

  There are likely some small changes in the schema.

  I would use the following flow.

  backup everything create your current db clone install jsreport 2.8.0 and run it configured to the db clone test the app, it can fail on some schema errors, typically with error "missing column jsreport_TemplateType" run alter table jsreport_TemplateType <column> <datatype>, you can get the type from http://localhost:5488/odata/$metadata when everything works, you can use the same alters on your current db and update jsreport
• P

  Scheduling report with params
  • palphonse

  6
  6
  Posts
  10281
  Views

  

  The req.context.isChildRequest determines if its a root parent request or the child nested one.
  I believe this should solve it for you?

  function beforeRender(req, res) { console.log(req.context.isChildRequest) }
• G

  Subtotal on pdf page
  • gth56

  2
  2
  Posts
  4702
  Views

  

  Please try to achieve this with the pdf utils extension.
  https://jsreport.net/learn/pdf-utils
  Especially this example should help
  https://playground.jsreport.net/w/admin/ihh7laK2

• G

  Cannot restart JsReports: Windows Service
  • gastonmunoz

  6
  6
  Posts
  14564
  Views

  G

  Thanks!

• H

  How to integrate jsreport with angular 6
  js-report angular 6 • • hi2azhar

  2
  2
  Posts
  7676
  Views

  

  Hi, no extra document, because in most of the cases you integrate jsreport on the server, not on the client.
  Do you have a specific case when it makes sense to call jsreport directly from the front end?

• N

  This topic is deleted!
  • NickBok

  2
  2
  Posts
  24
  Views
• A

  Chromium revision not downloaded
  • ajphillips

  11
  11
  Posts
  27438
  Views

  ?

  Following up on @ajphillips initial issue, I had a comparable issue when building my own docker container from the published base container and was able to resolve the issue by removing the --no-sandbox argument for chrome-pdf. In my case, I had copied that over from my local install, and did not actually require the argument when building from the base image. Hope this helps anyone else that may be in the same situation.

• 

  Generate pdf from docx template by unoconv always get timeout error.
  • hexl84

  4
  4
  Posts
  12618
  Views

  

  Great! Thank you for sharing the resolution.

• P

  Clone template programatically
  • palphonse

  2
  2
  Posts
  4332
  Views

  

  There isn't a specific API call for clone at this moment.

  However, what you can do, is use ODATA GET, remove from the JSON template the _id and shortid, change the name, and POST back.
  This is basically the same as the clone.

  https://jsreport.net/learn/api#querying-and-crud

• S

  Licence upgrade
  • stevef51

  3
  3
  Posts
  8865
  Views

  C

  Hi Jan,

  I just want to confirm this upgrade pricing is still the case? We are about to purchase annual Enterprise but expect that within half a year or so, all going well, we will need to upgrade to Enterprise Scale. So through the upgrade process we will receive the whole or a partial refund of the Enterprise cost?

• 

  Getting spinner after login , previously it was working fine
  • yyogeshwar

  2
  2
  Posts
  4618
  Views

  

  Hi, this should have nothing to do with the license.

  Please try to clear browser cache or run in an anonymous browser tab, does it help?
  Could you open F12 tools and check the console errors?
  What version do you use?
  Do you have access to the server logs?

• 

  problem with rendering xlsx report
  • Ntinos Kefis

  6
  6
  Posts
  26651
  Views

  S

  Not sure if it is the same issue but I recently had an xlsx corrupt file issue just posting in case anybody else has the same issue

  I amusing html to-xlsx recipe with ejs templating, I figured it out that I was missing the <tbody> tag around the table body and adding that fixed it for me

• A

  JSReport Online "Unauthorized for versions" error
  • aklaffenboeck

  9
  9
  Posts
  14390
  Views

  

  FYI this was hotfixed in jsreportonline some hours ago.

• J

  How to add styling to cell (font color,size,background color etc) to XLSX
  • jabren

  6
  6
  Posts
  24906
  Views

  

  i added an answer here
  https://stackoverflow.com/a/62287482/6945325

• R

  Problem after update version JSReport
  • Romeiros

  2
  2
  Posts
  7131
  Views

  

  Hi,

  unfortunately, the jsreport sql drivers don't handle sql change scripts between versions.
  You need to alter your db on your own and add the missing column that was introduced in the later jsreport version.

  In this case, you should run something like this
  ALTER TABLE jsreport_TemplateType ADD htmlToXlsx_templateAssetShortid nvarchar(255)

• M

  Access REST API from trial instances
  • mikeymop

  3
  3
  Posts
  7340
  Views

  

  Hi,

  I apologize for the confusion, we need to add better documentation to the jsreportonline.

  Is it possible to test the jsreport REST api from a free account's instance?

  Absolutely, there is no limitation regarding API calls.

  If I try to curl this instance directly it redirects me to the sign in page.

  This is probably because you are missing the authorization header.
  https://jsreport.net/learn/api#authentication
  It should look like this, it is common basic auth standard
  Authorization: Basic QWxhZGRpbjpvcGVuIHNlc2FtZQ==
  Where the hash is based on username and password:
  base64(username:password)

  With such a header, you can call for example
  GET https://xxx.jsreportonline.net/odata/templates

  When you want to render something, find details in the API docs
  https://jsreport.net/learn/api

  Is jsreport intended solely to be self-hosted from a node process? Or can it be accessed from an instance hosted by jsreport?

  I am afraid I don't understand what you mean. Can you elaborate?

  Jan

• 

  Data entity
  • Sachin Phatangare

  4
  4
  Posts
  6985
  Views

  M

  I was confused on this too, if you create a new template you have to manually link the data entity by editing the 'sample data' property on whatever html you are using for the template.

• S

  How to store only templates data on docker volume?
  • sergikoff

  4
  4
  Posts
  12210
  Views

  R

  I'm having this very same problem and it seems to me that it is right right that this is what should be happening. After all the jsreport:jsreport has no permissions on that volume.

• F

  Multiple paged Table overflowing to footer
  • forgotten-boi

  4
  4
  Posts
  7476
  Views

  F

  Nevermind, I found the solution. I am posting this anyway for case if anyone else has similar problem.

  var report = await rs.RenderAsync(new RenderRequest() { Template = new Template() { Recipe = Recipe.ChromePdf, Chrome = new Chrome() { MarginTop = "1cm", MarginBottom = "2cm", MarginLeft = "1cm", MarginRight = "1cm" }, Engine = Engine.Handlebars, Content = templateData, PdfOperations = new List<PdfOperation>() { pdfOperation } }, Data = new { item = item, image = imgBaseSixtyFour } }); using (var fs = File.Create(fileName)) { report.Content.CopyTo(fs); } }
• A

  How do you manage secrets in a streamlined way?
  • alight-eskillz

  5
  5
  Posts
  14366
  Views

  

  Glad to hear that!!!