topic Re: Number Format Changing Between Designer and Published Report in Qlik NPrinting

Number Format Changing Between Designer and Published Report

JustinRamsey — Wed, 07 Feb 2024 11:59:55 GMT

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

Re: Number Format Changing Between Designer and Published Report

Lech_Miszkiewicz — Wed, 07 Feb 2024 12:42:01 GMT

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

Re: Number Format Changing Between Designer and Published Report

Lech_Miszkiewicz — Wed, 07 Feb 2024 12:44:03 GMT

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.

Re: Number Format Changing Between Designer and Published Report

JustinRamsey — Wed, 07 Feb 2024 13:08:30 GMT

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.

Re: Number Format Changing Between Designer and Published Report

Ruggero_Piccoli — Wed, 07 Feb 2024 14:36:19 GMT

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

Re: Number Format Changing Between Designer and Published Report

Lech_Miszkiewicz — Thu, 08 Feb 2024 00:02:05 GMT

Hi @JustinRamsey

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:

you are using Qlik Sense Pivot Table as a source
you are dumping single pivot table tag to excel
you are NOT able to apply any numerical formatting on cells (because you are using pivot table which does not have this)
Report generates correctly when you press PREVIEW in designer and file gets created?
- this is strange as PREVIEW should really replicate the behaviour of the task
Report generates differently when you generate it via task

Have you tried?

RDP to NPrinting server as NPrinting engine user
Edit report on the server using designer and press PREVIEW to preview it on the server
- what happens?
  - do you get the same results?
  - please take a screenshot of each steps

Alternatives:

I normally dont work with pivot tables and I prefer to build my templates using other methods (straight table with levels) where I have a lot more control over each individual column/values and formatting
- I know it requires a lot of thinking but as long as you can plan for consistent number of columns in your report you are able to build it that way
- With the above in mind you are then able to use excel number formats which will behave more consistent and you can use excel properties to set them as opposed to just pure dump of data from Qlik Sense

Lastly:

What is your expression in Qlik Sense
- What number format you have chosen for expression (Auto, number, custom, measure etc?)
- What are decimal and thousand delimitters in your Qlik Sense app system variables set to?
What is your Qlik Sense version - does it meet compatibility criteria with your NPrinting version as documented? https://help.qlik.com/en-US/nprinting/May2023/Content/NPrinting/DeployingQVNprinting/System-requirements_engine.htm
- this is very important and I am assuming you have provided us with correct information when chosing label with the version of NPrinting you are using.

cheers

Lech