Dates in NPrinting PixelPerfect displaying as 5 digit number instead of date format

[AlexPettit87]

We had an issue where NPrinting wasn't letting us sort the data in a report by the "Maturity Date". We found out that the SQL used to collect this information was saving the date as a 'String' instead of in a date format, and that was preventing us from sorting the data by this specific column.

We have since made the change to SQL to convert the information into a date format, but now we are trying to format the date appropriately for how we want it displayed(MM-dd-yyyy). Ever since we have this data coming into our report as a Date, NPrinting now spits out some 5 digit number that has nothing to do with any of the info from the results.

We can view the results from the QLIK dashboard, and it shows properly as the date with it being formatted the way we want it to be. But NPrinting doesn't handle this for some reason? I'll attach some screenshots but does anyone have any suggestions for why this would be happening? Is there an updated version of Nprinting that doesn't have this bug in it(we use on-prem solution not Qlik Cloud).

Attached the wrong data from the report itself and the correct data showing in the QLIK dashboard.

from report generationin QLIK dashboard

[AlexPettit87]

Additional information in case it matters. We are using the following version of NPrinting(On-Premise Solution):

[David_Friend]

@AlexPettit87 are you already planning to update NPrinting versions? that version is no longer supported, so would be a good next step.  Also what version is QlikSense?

What format is your NPrinting report in? i.e. Excel, PixelPerfect etc.?

[AlexPettit87]

Yes, I am meeting with our local IT around upgrading the version of NPrinting we use here in the next few weeks. I was hoping a newer version would resolve the issue I am having. I've attached the version of Qliksense we currently have installed on our server:

Our reporting is in a PDF format. We had used Excel formatted reports(not PixelPerfect reports) for the past 10+ years and we are wanting to make them look better than just a list of data in a spreadsheet!

[David_Friend]

Unfortunately your version of NPrinting was never supported to work with that version of QS: https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/DeployingQVNprinting/System-requirem...

So yes upgrade see if that helps, it needs to be done anyway!

[AlexPettit87]

Thanks for the additional information. I will update the thread once we do the upgrade and see if that helps us with the issues we are seeing!

[AlexPettit87]

Updated to the most recent version of NPrinting, same result:

This doesn't make sense. If we couldn't sort by this column because it was a "string" set of data, how does us making it a date formatted column of data break it but allow us to sort?

I was told to add this into the expression for the data too for it to look correct. I have done that(if I remove that expression/formula, it fails to generate the report).

=Date(Floor([Maturity Date]),'MM-dd-yyyy')

This same column of data in QLIKSENSE Hub/Dashboard also still shows properly as MM-dd-yyyy. Not making much sense to me!