NPrinting Number Format

[Gerard1]

Hello everyone!

I am having trouble with NPrinting handling different number formats (thousand and decimal separators). 

In the QS apps, we create variables to give format to the numbers based on the users individual preferences.

"Num(expresion,variable_formatnumber, variable_FormatThousand, variable_FormatDecimal" (format is different depending the user logged).

QV and QV's native reporting tool have no problem dealing with this.

QS has no problem dealing with this.

However, when using NPrinting (manipulating it in Excel and sending in PDF) it ignores the instruction and always uses de same format (i guess based on the server region configuration). I managed to fix this by varying the expression and getting NP to correctly output different formats for the thousands and decimal separators. The problem comes because NP (either Excel or NP itself) only interprets one of the two separators format as number; and the other is interpreted as text. This is causing us problems with column alignment and applying conditions.

Any wisdom would be greatly appreciated.

Thanks everyone in advance!

[Amit_Prajapati]

Hi, please check the source format to see if it's correctly set.

If you're applying any additional styles or formatting in NPrinting, make sure those options are unchecked. You can verify this by checking the properties of the table or field you're using.

[Lech_Miszkiewicz]

Hi, 

yes, Excel reporting will be based on regional setting of the NPrinting server on which report is produced. 

The only workaround would be converting all to text by wrapping your measures in text() function and using text alignment in excel. The problem is that you would loose ability to do any excel summaries/total/subtotals etc...

this however depends on your reports requirements.

cheers

[Lech_Miszkiewicz]

also - surely you are not using NPrinting 16 as that is not suporting Qlik Sense - so make sure you correct that label mistake as it creates misleading content for others searching for answers on community. 

thanks

[Gerard1]

Thanks for the answers.

I tried many other things and still not found an easy and friendly use solution, actually did not found a solution, but seems that if i am finally finding one, not going to be easy and friendly. What @Lech_Miszkiewicz says of giving all Text format, not applies, or i dont know how to when working with pivot tables as you can not apply text alignment for each column separatly. I started to investigate Pixel Perfect but i've seen that it's not possible to work with pivot tables. 

If any new ideas, would be appreciated.

@Lech_Miszkiewicz Correct. apologies. it is NP 24.

Thanks Everyone

[Lech_Miszkiewicz]

Hi @Gerard1 

You would need to give us a hint how your output needs to look like. 

The fact it is a pivot table does not mean we cannot use straight table as a source for it. It really depends on number of dimensions used as columns in your pivot tables and number of values in those dimensions.

Since it is printed report I would assume it will be rather static or it will not fit on single page width. 

thanks

Lech