Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We are having an issue with Nprinting that I cannot seem to solve. I have the number format for the report correct in Nprinting Designer however when the task runs and the report published the number format changes. Report end user wants the report to use traditional German number format with (.) as the thousand separator and for this report no decimal values. As you can see in the picture below the value generated by the NPrinting Designer preview is correct. The image below that shows the PDF that is being published by the automated task, notice the thousand separator is now the (,). Number format in the QlikSense document itself is correct as well.
So far I have tried formatting the values as text, unchecking keep source formatting in the designer, and publishing as XLSX instead of PDF and end result has been the same.
Nprinting Designer Preview
Published PDF
We are running May 2023 V 23.20.1.0 Nprinting version and Qlik Sense May 2023 Patch 3
I can assume this is because of regional setting on NPrinting engine machine. Since PDF is generated on it it will inherit NPrinting engine settings. Now when it comes to XLSX files those often can change default format for thousand and decimal delimiters depending on the computer regional settings on which such file gets opened.
RDP to your NPrinting Engine server and confirm regional settings of it to be same as you need.
cheers
Hi @JustinRamsey Another thing we dont know is what template you are using. My answer is based on assumption that you are using XLSX template and produce PDF out of it.
I had that thought as well on the regional settings on the Nprint Server however it appears they are set up correctly, and you are correct I am using a blank XLSX template and just publishing as a PDF.
Hi,
Qlik NPrinting uses the regional settings of the computers where Engines are installed. One Engine could be installed in the same computer as the Server but if you are running more than one Engine be sure to change the regional settings of all of them.
Best Regards,
Ruggero
This seems to little bit more complex. Again I am just guessing as there is only as much information as you provided so far. Here are mu gueses:
Have you tried?
Alternatives:
Lastly:
cheers
Lech