Posts made by AB-D

Hi @bjrmatos that worked, thank you

Hi, we are going to update our test and production servers to the latest version, however when I initialise the latest version "start" is not there.

(Also, I used to be able to post pictures when I made a post but it says that I don't have the privileges to do that anymore - here is the text)

Ok, so update:

The file is now working if i use this syntax:

{{#xlsxReplace "xl/styles.xml"}}
{#asset style.xml}
{{/xlsxReplace}}

Just removing the extra curly bracket at the end, the file now works locally, and on the test server.

However, virtually identical files with the extra curly bracket will also work.

It also does not explain why the same file was working locally but not on the test server

Regarding the typo...

This does seem to be a problem. I have one report that uses it and runs perfectly:

This one will run every time:

But this one will not:

Unless you remove that replace code:

But then the files need to be "repaired" because they are not styled properly and are not suitable for client use.

The exact syntax for that replace code I got from here:

https://stackoverflow.com/questions/60283656/jsreport-handlebars-engine-and-xlsx-recipe-how-to-fill-cell-with-color

I thought it was a typo but it turns out that the stackoverflow poster got it right, and this looks like the only way to replace a style file.

Hi Jan,

Yes, I have to include that typo - the style file will not apply unless it is types exactly like that - can you tell me how what the exact syntax should be?

The issue is that the exact same file will work on one environment but not the other - even with that typo, also, I can't send you the export for commercial reasons. But even if I did, you could get the same issue, that it will work locally but not when you upload it to another server.

Hi,

I have jsreport running locally - 3.10.0
My test server is also 3.10.0

My deployment method is to export a .zip from my local and then do a "Full" import to the test server.

I have been working on an xlsx file - on my local it will generate like it is supposed to:

But the exact same file, after an import will not work on the test server:

Your help would be appreciated

So it does, thanks for the confirmation

Hi,

I am attempting to add a col element to an xlsx sheet to define custom column widths.

This works:

The first two columns are wider.

What need to do it add these cols dynamically, from an object in the script colWidths that has two properties, the index and width I want to set the column to.

This does not work, and I assume that it has to do with the double quotes, but I can't wrap the {{values}} in double quotes as that does not work in handlebars.

Any ideas?

Regards,

Ari

Hi Jan,

I got part of the way.

Adding to the pdfMeta will fix how the title appears in the pdf viewer, and will change the title - any idea how to change the file name itself?

Just for context, is a script like this supposed to work?

Is there an agreed upon way of changing the report name from the guid to something else?

There are a number of different (unresolved?) questions on this forum and the solution in the documentation does not seem to work.

Hi, the profiler says that there are some old reports that have been running for a long time:

How do i stop them?

Hi,

I write reports in the studio in html so that I can use google chrome dev tools for debugging.

Recently I have been getting this warning:

It means that when I get an error:

I am not able to locate the code that is causing it:

Do you have any ideas how this happened? It could be a chrome update? I can get around it by using another browser like Safari.

Just FYI I got around this issue by creating a asset js file and just importing that as an asset into the script. So it is not urgent.

Hi,

I am trying to use d3 as a library in a script for an XLSX recipe report.

Using require('d3') like with other libraries results in this error:
Unable to require module d3. require() of ES Module ... [filepath]/workerHandler.js not supported.
Instead change the require of index.js in ... [filepath]workerHandler.js to a dynamic import() which is available in all CommonJS modules.

If I change it to import * as d3 from 'd3' i get this error:

Any advice?

Cheers

I deleted the node_modules then ran npm install but still have cli 2.2.5

The list of global npm packages says 3.2.1 but checking the version always says 2.2.5


This is the package.json

Hi Jan - any tips.

Uninstalling does not seem to work

Ok, I am a bit confused though - version 3.6.2 was working with this cli version yesterday

Also it is not really clear which one to use - and there is nothing on the preferred version that I can find here https://jsreport.net/learn/cli