Thank you for the reply, we wound up doing an npm install of oracledb and that got us past the startup problem.

It seems you use jsreport.exe binary and it can't run chrome.exe for some unknown reason.
The chrome.exe is extracted to the user temp during the first run.

Please try to remove the [user temp folder]/jsreport and try it again.
Typically its here c:\Users\[user]\AppData\Local\Temp\jsreport\

As you can see, for the string array I had to force quotation marks and commas, but after that, everything worked great!

There are some string chars that can break your code. Therefore toJS helper is recommended.

As always, you guys are right on the money with your solutions. Can't thank you guys enough, and I'm certain I'll have more. :-)

You are more than welcome.

What version of the browser client do you use?
What do you see in the F12 console errors/warns?

I apologize for not mentioning the actual typo. You got it right then.

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

This is actually older v2 syntax. Its still compatible with v3, but now we use the following
https://jsreport.net/learn/assets

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

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

I have tried replicating the issue and getting some hypotheses why it works for you on one server and not on the other, but unfortunately, I don't know.

Try the following
https://stackoverflow.com/a/55090914/1660996

Since as of nov 12 2021 unoconv is deprecated. Its not a speed issue, more of a consern security-vice to be able to have the newer version that atleast have recent changes and are still being maintaned. Not sure if there are any added functionality. Would be nice to see where this upgrade is on the roadmap of jsreport.

Thank you for the fast reply, great support as always for a great product!

You need to configure your web server/nginx properly.
https://www.cyberciti.biz/faq/linux-unix-bsd-nginx-413-request-entity-too-large/
https://medium.com/@svsh227/error-413-request-entity-too-large-in-nginx-with-client-max-body-size-changes-in-nginx-6aacd525fe11

Thanks so much for the quick response! The fix you recommended worked beautifully, and thanks for explaining the differences between v2 and v3 and how it handles the helpers.

Hahaha! Your reply is almost the same as I can expect. However, it is reasonable. The security issue can not be just ignored due to code check tool. I can try to use "overrides" of NPM to upgrade vm2 directly. Maybe we could upgrade to Jsreport V3 as well later.
Thank you! Have a nice day! @jan_blaha

@Ish-Modi it all depends on the pdf viewer you use, in the studio we use the standard pdf viewer which has the limitation I described.

in your app, you don't need to use the same pdf viewer, although it is handy to let the browser handle the preview, it will have the same limitation. instead, you can check other pdf viewers which allow this customization. I think pdf.js is one of those that don't have this problem and will let you have a download button with a custom name. another solution is to add to your app a custom download button that triggers download from jsreport-client.

hi @Happy-Patel

it looks your code is the right way, there are multiple ways you can simplify it, one way is that instead of adding pdf page item per property value, you just use a single call with all the properties. then in the header you are sure your data is in the 0 index, and can create just a single function for all your properties access.

if you need to conditionally render something based on the avatar you can still do it in the header, from the main you can just propagate the avatar value (without the if) no matter if it is undefined or not

here is a demo
https://playground.jsreport.net/w/anon/EoeNYCW3

As you suggested using the pkg tool it is hard to create an exe file, can you provide an alternative way to achieve my requirements?

Thanks @bjrmatos26 in advance for your time and help.

Unfortunately, it works as you observe. The chrome bundled in jsreport.Binary.Linnux doesn't inject pageNumber in docker. I haven't found what is the actual reason for this. It could be an internal deps version mismatch, but I couldn't verify it.

What you can do is use pdf utils to merge footer with page numbers.
https://jsreport.net/learn/dotnet-client#pdf-utils
https://playground.jsreport.net/w/admin/kMI4FBmw

The other option is to boot the whole jsreport in the next docker container and communicate with it with jsreport.Client nuget. This option typically scales the best. Example:
https://github.com/jsreport/jsreport-dotnet-example-docker-compose

@Oleksii-Baula about the column width not being expected, I don't have a good explanation or solution, we use the chrome table layout algorithm so in this case we get the width values from chrome itself.

for the case in which overflow does not work (meaning that it does not make the cell to text wrap) i recommend that you just don't trust what the office preview shows you, i mean that you should download the output and check how it looks when you open the file.

I did a test and when the data in cell has spaces fiveThree fiveThree five... (like it is expected for the text wrap to work) I've observed that it looks different when opening the file locally.

however for the case in which the text does not have spaces fiveThreefiveThreefive... the wrap works but it hides part of the text (which is the result you don't want), basically right now in a case in which the text is long and it does not have spaces it won't work as you lile.

I don't have a lot of experience with windows services..
However, have you tried using environment variables like described here
https://serverfault.com/a/1103091

Thanks for the nice problem description. It is a bug. I've pushed the fix which we should release at the end of the next week. Please use assets without link encoding till then.

Yes. The free license has no other limits than the template count.

I see yes.
The thing is that in this case, the sheet includes references to other files that you need to clone as well.
For example, the filters are defined in the xl/tables xmls. So you need to clone this as well and update the references.
I know its tedious work, but we don't have API that could do this for you at this moment.
You gonna need to unzip the xlsx and check the references in worksheets/sheet*.xml and clone the references xmls as well.

I apologize. I've read the docs now and the maximum leaseDuration in azure is 60s which is the default. So we can't change this. Please skip the lock options.

If the other configs won't help. Please check if you have the storage in the same Azure region as the app.
Also azure provides low-latency premium storage, maybe it will work faster and eliminate the problem.
Another option is to map some file system azure provides and use plain jsreport fs store.