Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
PoojaPrasad
Creator II
Creator II

Nprinting Pixel Perfect Report shows date value as MM/dd/yyyy

Dear Experts,

I am using pixel perfect report. I have a table chart with 2 date columns in Qlik app.In Nprinting Template Editor, I have added this object as Table and then used both the date columns in the report.

After the report is generated, one of the date value is shown and the other is shown as MM/dd/yyyy, despite format being same. Has anyone faced the similar issue and know how to resolve?

Thanks in advance,

Labels (1)
1 Solution

Accepted Solutions
PoojaPrasad
Creator II
Creator II
Author

I was able to solve the issue by loading both the dates as text in Qlik Data Load Editor

text(date( @15,'MM/DD/YYYY')) as [Date of Hire],
text(date( @16,'MM/DD/YYYY')) as [Current Position Date],

I think Nprinting Pixel Perfect Report has issue while printing the date values. If the date column is read as text, it displays it fine.

Thank you,

View solution in original post

6 Replies
Frank_S
Support
Support

Hi @PoojaPrasad 

Try this...

https://support.qlik.com/articles/000034881

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
PoojaPrasad
Creator II
Creator II
Author

Hello @Frank_S ,

 

After I did the change and trying to save the report it says "Unhandled Exception has occurred in a component in your application"

The issue is I have two such columns with the similar issue, I have already applied the code in one of the column before. So when I try to add this code for this column, it is either replaced by previous one or the previous one gets overwritten.

So, the question is, is it possible to apply it for 2 objects in the same report?

Below is the detail code:

See the end of this mesage for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Runtime.InteropServices.COMException (0x8000FFFF): Catastrophic failure
at NPrinting.Reporting.Interfaces.ITemplateEditorFormEvents.SaveTemplate()
at NPrinting.Reporting.ReportingApp.PixelPerfect.Editor.EditorForm.Save()
at NPrinting.Reporting.ReportingApp.PixelPerfect.Editor.EditorForm.ReportsCommandHandler.DevExpress.XtraReports.UserDesigner.ICommandHandler.HandleCommand(ReportCommand command, Object[] args)
at DevExpress.XtraReports.Design.Commands.CommandHandlerCollection.HandleCommand(ReportCommand command, Object[] args)
at DevExpress.XtraReports.UserDesigner.Native.XRMenuCommandService.GlobalInvoke(CommandID commandID, Object[] args)
at DevExpress.XtraReports.UserDesigner.XRDesignPanel.ExecCommand(ReportCommand command, Object[] args)
at DevExpress.XtraReports.UserDesigner.XRDesignPanel.ExecCommand(ReportCommand command)
at DevExpress.XtraReports.UserDesigner.Native.XRDesignItemsLogicBase.ExecuteCommand(ReportCommand command)
at DevExpress.XtraReports.UserDesigner.Native.XRDesignItemsLogicBase.OnManagerItemClick(Object sender, ItemClickEventArgs e)
at DevExpress.XtraBars.ItemClickEventHandler.Invoke(Object sender, ItemClickEventArgs e)
at DevExpress.XtraBars.BarManager.RaiseItemClick(ItemClickEventArgs e)
at DevExpress.XtraBars.BarItem.OnClick(BarItemLink link)
at DevExpress.XtraBars.BarButtonItem.OnClick(BarItemLink link)
at DevExpress.XtraBars.BarItemLink.OnLinkClick()
at DevExpress.XtraBars.BarButtonItemLink.OnLinkClick()
at DevExpress.XtraBars.BarItemLink.OnLinkAction(BarLinkAction action, Object actionArgs)
at DevExpress.XtraBars.BarButtonItemLink.OnLinkAction(BarLinkAction action, Object actionArgs)
at DevExpress.XtraBars.BarItemLink.OnLinkActionCore(BarLinkAction action, Object actionArgs)
at DevExpress.XtraBars.ViewInfo.BarSelectionInfo.ClickLink(BarItemLink link)
at DevExpress.XtraBars.ViewInfo.BarSelectionInfo.UnPressLink(BarItemLink link)
at DevExpress.XtraBars.Ribbon.Handler.BaseRibbonHandler.OnUnPressItem(DXMouseEventArgs e, RibbonHitInfo hitInfo)
at DevExpress.XtraBars.Ribbon.Handler.BaseRibbonHandler.OnUnPress(DXMouseEventArgs e, RibbonHitInfo hitInfo)
at DevExpress.XtraBars.Ribbon.Handler.BaseRibbonHandler.OnMouseUp(DXMouseEventArgs e)
at DevExpress.XtraBars.Ribbon.Handler.RibbonHandler.OnMouseUp(DXMouseEventArgs e)
at DevExpress.XtraBars.Ribbon.RibbonControl.OnMouseUp(MouseEventArgs e)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at DevExpress.Utils.Controls.ControlBase.WndProc(Message& m)
at DevExpress.XtraBars.Ribbon.RibbonControl.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3468.0 built by: NET472REL1LAST_C
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
Syntes.NET.Support
Assembly Version: 1.2.7011.29917
Win32 Version: 4.7.3468.0 built by: NET472REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/mscorlib/v4.0_4.0.0.0__b77a5c561934e089/mscorlib.dll
----------------------------------------
NPrinting.Designer
Assembly Version: 1.2.7139.15785
Win32 Version: 1.2.7139.15785
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/plugins/NPrinting.Designer.dll
----------------------------------------
NPrinting.Reporting.Interfaces
Assembly Version: 2.0.0.0
Win32 Version: 2.0.0.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/NPrinting.Reporting.Interfaces.dll
----------------------------------------
NPrinting.Excel
Assembly Version: 19.29.0.0
Win32 Version: 19.29.0.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/NPrinting.Excel.dll
----------------------------------------
NPrinting.Html
Assembly Version: 19.29.0.0
Win32 Version: 19.29.0.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/NPrinting.Html.dll
----------------------------------------
NPrinting.Powerpoint
Assembly Version: 19.29.0.0
Win32 Version: 19.29.0.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/NPrinting.Powerpoint.dll
----------------------------------------
NPrinting.Powerpoint.Editor
Assembly Version: 19.29.0.0
Win32 Version: 19.29.0.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/NPrinting.Powerpoint.Editor.dll
----------------------------------------
NPrinting.Word
Assembly Version: 19.29.0.0
Win32 Version: 19.29.0.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/NPrinting.Word.dll
----------------------------------------
NPrinting.Word.Editor
Assembly Version: 19.29.0.0
Win32 Version: 19.29.0.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/NPrinting.Word.Editor.dll
----------------------------------------
NPrinting.PixelPerfect
Assembly Version: 19.29.0.0
Win32 Version: 19.29.0.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/NPrinting.PixelPerfect.dll
----------------------------------------
NPrinting.PixelPerfect.Editor
Assembly Version: 19.29.0.0
Win32 Version: 19.29.0.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/NPrinting.PixelPerfect.Editor.dll
----------------------------------------
NPrinting.NewsStand.Client
Assembly Version: 1.2.7139.15780
Win32 Version: 1.2.7139.15780
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/NPrinting.NewsStand.Client.dll
----------------------------------------
Qlik.Reporting.TemplateEditor.Support
Assembly Version: 19.29.0.0
Win32 Version: 19.29.0.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/Qlik.Reporting.TemplateEditor.Support.dll
----------------------------------------
Aspose.Cells
Assembly Version: 19.5.0.0
Win32 Version: 19.5
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/Aspose.Cells.DLL
----------------------------------------
NPrinting.Reporting
Assembly Version: 19.29.0.0
Win32 Version: 19.29.0.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/NPrinting.Reporting.DLL
----------------------------------------
System.Xml
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3451.0 built by: NET472REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Core
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3468.0 built by: NET472REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
Aspose.Slides
Assembly Version: 19.1.0.0
Win32 Version: 19.1
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/Aspose.Slides.DLL
----------------------------------------
Aspose.Pdf
Assembly Version: 10.3.0.0
Win32 Version: 10.3.0.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/Aspose.Pdf.DLL
----------------------------------------
Aspose.Words
Assembly Version: 19.1.0.0
Win32 Version: 19.1.0.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/Aspose.Words.DLL
----------------------------------------
DevExpress.XtraReports.v14.2.Extensions
Assembly Version: 14.2.3.0
Win32 Version: 14.2.3.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/DevExpress.XtraReports.v14.2.Extensions.DLL
----------------------------------------
DevExpress.BonusSkins.v14.2
Assembly Version: 14.2.3.0
Win32 Version: 14.2.3.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/DevExpress.BonusSkins.v14.2.DLL
----------------------------------------
DevExpress.Charts.v14.2.Core
Assembly Version: 14.2.3.0
Win32 Version: 14.2.3.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/DevExpress.Charts.v14.2.Core.DLL
----------------------------------------
DevExpress.CodeParser.v14.2
Assembly Version: 14.2.3.0
Win32 Version: 14.2.3.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/DevExpress.CodeParser.v14.2.DLL
----------------------------------------
DevExpress.Data.v14.2
Assembly Version: 14.2.3.0
Win32 Version: 14.2.3.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/DevExpress.Data.v14.2.DLL
----------------------------------------
DevExpress.DataAccess.v14.2
Assembly Version: 14.2.3.0
Win32 Version: 14.2.3.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/DevExpress.DataAccess.v14.2.DLL
----------------------------------------
DevExpress.DataAccess.v14.2.UI
Assembly Version: 14.2.3.0
Win32 Version: 14.2.3.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/DevExpress.DataAccess.v14.2.UI.DLL
----------------------------------------
System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
DevExpress.Office.v14.2.Core
Assembly Version: 14.2.3.0
Win32 Version: 14.2.3.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/DevExpress.Office.v14.2.Core.DLL
----------------------------------------
DevExpress.PivotGrid.v14.2.Core
Assembly Version: 14.2.3.0
Win32 Version: 14.2.3.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/DevExpress.PivotGrid.v14.2.Core.DLL
----------------------------------------
DevExpress.Printing.v14.2.Core
Assembly Version: 14.2.3.0
Win32 Version: 14.2.3.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/DevExpress.Printing.v14.2.Core.DLL
----------------------------------------
DevExpress.RichEdit.v14.2.Core
Assembly Version: 14.2.3.0
Win32 Version: 14.2.3.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/DevExpress.RichEdit.v14.2.Core.DLL
----------------------------------------
DevExpress.Sparkline.v14.2.Core
Assembly Version: 14.2.3.0
Win32 Version: 14.2.3.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/DevExpress.Sparkline.v14.2.Core.DLL
----------------------------------------
DevExpress.Utils.v14.2
Assembly Version: 14.2.3.0
Win32 Version: 14.2.3.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/DevExpress.Utils.v14.2.DLL
----------------------------------------
System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3324.0 built by: NET472REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
DevExpress.Utils.v14.2.UI
Assembly Version: 14.2.3.0
Win32 Version: 14.2.3.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/DevExpress.Utils.v14.2.UI.DLL
----------------------------------------
DevExpress.Xpo.v14.2
Assembly Version: 14.2.3.0
Win32 Version: 14.2.3.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/DevExpress.Xpo.v14.2.DLL
----------------------------------------
DevExpress.XtraBars.v14.2
Assembly Version: 14.2.3.0
Win32 Version: 14.2.3.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/DevExpress.XtraBars.v14.2.DLL
----------------------------------------
DevExpress.XtraCharts.v14.2
Assembly Version: 14.2.3.0
Win32 Version: 14.2.3.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/DevExpress.XtraCharts.v14.2.DLL
----------------------------------------
DevExpress.XtraCharts.v14.2.Wizard
Assembly Version: 14.2.3.0
Win32 Version: 14.2.3.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/DevExpress.XtraCharts.v14.2.Wizard.DLL
----------------------------------------
DevExpress.XtraGauges.v14.2.Core
Assembly Version: 14.2.3.0
Win32 Version: 14.2.3.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/DevExpress.XtraGauges.v14.2.Core.DLL
----------------------------------------
DevExpress.XtraGauges.v14.2.Presets
Assembly Version: 14.2.3.0
Win32 Version: 14.2.3.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/DevExpress.XtraGauges.v14.2.Presets.DLL
----------------------------------------
DevExpress.XtraGauges.v14.2.Win
Assembly Version: 14.2.3.0
Win32 Version: 14.2.3.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/DevExpress.XtraGauges.v14.2.Win.DLL
----------------------------------------
DevExpress.XtraGrid.v14.2
Assembly Version: 14.2.3.0
Win32 Version: 14.2.3.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/DevExpress.XtraGrid.v14.2.DLL
----------------------------------------
DevExpress.XtraLayout.v14.2
Assembly Version: 14.2.3.0
Win32 Version: 14.2.3.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/DevExpress.XtraLayout.v14.2.DLL
----------------------------------------
DevExpress.XtraNavBar.v14.2
Assembly Version: 14.2.3.0
Win32 Version: 14.2.3.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/DevExpress.XtraNavBar.v14.2.DLL
----------------------------------------
DevExpress.XtraReports.v14.2
Assembly Version: 14.2.3.0
Win32 Version: 14.2.3.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/DevExpress.XtraReports.v14.2.DLL
----------------------------------------
DevExpress.XtraRichEdit.v14.2
Assembly Version: 14.2.3.0
Win32 Version: 14.2.3.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/DevExpress.XtraRichEdit.v14.2.DLL
----------------------------------------
DevExpress.XtraEditors.v14.2
Assembly Version: 14.2.3.0
Win32 Version: 14.2.3.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/DevExpress.XtraEditors.v14.2.DLL
----------------------------------------
DevExpress.XtraTreeList.v14.2
Assembly Version: 14.2.3.0
Win32 Version: 14.2.3.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/DevExpress.XtraTreeList.v14.2.DLL
----------------------------------------
DevExpress.XtraVerticalGrid.v14.2
Assembly Version: 14.2.3.0
Win32 Version: 14.2.3.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/DevExpress.XtraVerticalGrid.v14.2.DLL
----------------------------------------
DevExpress.XtraWizard.v14.2
Assembly Version: 14.2.3.0
Win32 Version: 14.2.3.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/DevExpress.XtraWizard.v14.2.DLL
----------------------------------------
System.Design
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Design/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Design.dll
----------------------------------------
System.Configuration
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
NPrinting.NewsStand.NpClient
Assembly Version: 1.2.7017.22306
Win32 Version: 1.2.7017.22306
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/NPrinting.NewsStand.NpClient.DLL
----------------------------------------
Autofac
Assembly Version: 3.5.0.0
Win32 Version: 3.5.2.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/Autofac.dll
----------------------------------------
Qlik.Printing
Assembly Version: 19.29.0.0
Win32 Version: 19.29.0.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/Qlik.Printing.DLL
----------------------------------------
Qlik.Reporting.Reports.Tree
Assembly Version: 19.29.0.0
Win32 Version: 19.29.0.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/Qlik.Reporting.Reports.Tree.DLL
----------------------------------------
Qlik.Reporting.Engine.Messages
Assembly Version: 19.29.0.0
Win32 Version: 19.29.0.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/Qlik.Reporting.Engine.Messages.DLL
----------------------------------------
Qlik.Reporting.Common
Assembly Version: 19.29.0.0
Win32 Version: 19.29.0.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/Qlik.Reporting.Common.DLL
----------------------------------------
Anonymously Hosted DynamicMethods Assembly
Assembly Version: 0.0.0.0
Win32 Version: 4.7.3468.0 built by: NET472REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/mscorlib/v4.0_4.0.0.0__b77a5c561934e089/mscorlib.dll
----------------------------------------
DevExpress.XtraPrinting.v14.2
Assembly Version: 14.2.3.0
Win32 Version: 14.2.3.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/DevExpress.XtraPrinting.v14.2.DLL
----------------------------------------
System.Net.Http
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Net.Http/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Net.Http.dll
----------------------------------------
System.ComponentModel.DataAnnotations
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.ComponentModel.DataAnnotations/v4.0_4.0.0.0__31bf3856ad364e35/System.ComponentModel.DataAnnotations.dll
----------------------------------------
System.Data
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3260.0 built by: NET472REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
Newtonsoft.Json
Assembly Version: 10.0.0.0
Win32 Version: 10.0.3.21018
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/Newtonsoft.Json.DLL
----------------------------------------
System.Data.Linq
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Data.Linq/v4.0_4.0.0.0__b77a5c561934e089/System.Data.Linq.dll
----------------------------------------
System.Web
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3429.0 built by: NET472REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Web/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Web.dll
----------------------------------------
WindowsBase
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3468.0 built by: NET472REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/WindowsBase/v4.0_4.0.0.0__31bf3856ad364e35/WindowsBase.dll
----------------------------------------
Microsoft.mshtml
Assembly Version: 7.0.3300.0
Win32 Version: 7.0.3300.0
CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.mshtml/7.0.3300.0__b03f5f7f11d50a3a/Microsoft.mshtml.dll
----------------------------------------
HttpMultipartParser
Assembly Version: 2.1.5.0
Win32 Version: 2.1.5.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/HttpMultipartParser.DLL
----------------------------------------
System.Numerics
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll
----------------------------------------
System.Runtime.Serialization
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3440.0 built by: NET472REL1LAST_B
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Serialization/v4.0_4.0.0.0__b77a5c561934e089/System.Runtime.Serialization.dll
----------------------------------------
Qlik.Common.PolymorphTypes
Assembly Version: 0.0.0.0
Win32 Version: 19.29.0.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/Qlik.Reporting.Common.dll
----------------------------------------
tjsnncfe
Assembly Version: 0.0.0.0
Win32 Version: 4.7.3451.0 built by: NET472REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
n50g0pu5
Assembly Version: 0.0.0.0
Win32 Version: 4.7.3451.0 built by: NET472REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
UIAutomationClient
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3468.0 built by: NET472REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/UIAutomationClient/v4.0_4.0.0.0__31bf3856ad364e35/UIAutomationClient.dll
----------------------------------------
System.Data.SqlXml
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Data.SqlXml/v4.0_4.0.0.0__b77a5c561934e089/System.Data.SqlXml.dll
----------------------------------------
System.Security
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3101.0 built by: NET472REL1LAST_B
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Security/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Security.dll
----------------------------------------
System.Transactions
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3221.0 built by: NET472REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
System.DirectoryServices
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.DirectoryServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.DirectoryServices.dll
----------------------------------------
System.Runtime.Remoting
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Remoting/v4.0_4.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
----------------------------------------
System.Web.RegularExpressions
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Web.RegularExpressions/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Web.RegularExpressions.dll
----------------------------------------
Accessibility
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
System.Deployment
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Deployment/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Deployment.dll
----------------------------------------
System.Runtime.Serialization.Formatters.Soap
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Serialization.Formatters.Soap/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Runtime.Serialization.Formatters.Soap.dll
----------------------------------------
System.Data.OracleClient
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Data.OracleClient/v4.0_4.0.0.0__b77a5c561934e089/System.Data.OracleClient.dll
----------------------------------------
System.Drawing.Design
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing.Design/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.Design.dll
----------------------------------------
System.Web.ApplicationServices
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3429.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Web.ApplicationServices/v4.0_4.0.0.0__31bf3856ad364e35/System.Web.ApplicationServices.dll
----------------------------------------
System.DirectoryServices.Protocols
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.DirectoryServices.Protocols/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.DirectoryServices.Protocols.dll
----------------------------------------
System.ServiceProcess
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.ServiceProcess/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.ServiceProcess.dll
----------------------------------------
System.Configuration.Install
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration.Install/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.Install.dll
----------------------------------------
System.ServiceModel.Internals
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3440.0 built by: NET472REL1LAST_B
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.ServiceModel.Internals/v4.0_4.0.0.0__31bf3856ad364e35/System.ServiceModel.Internals.dll
----------------------------------------
SMDiagnostics
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3440.0 built by: NET472REL1LAST_B
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/SMDiagnostics/v4.0_4.0.0.0__b77a5c561934e089/SMDiagnostics.dll
----------------------------------------
System.Web.Services
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Web.Services/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Web.Services.dll
----------------------------------------
Microsoft.Build.Utilities.v4.0
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.Build.Utilities.v4.0/v4.0_4.0.0.0__b03f5f7f11d50a3a/Microsoft.Build.Utilities.v4.0.dll
----------------------------------------
Microsoft.Build.Framework
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.Build.Framework/v4.0_4.0.0.0__b03f5f7f11d50a3a/Microsoft.Build.Framework.dll
----------------------------------------
System.Xaml
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3468.0 built by: NET472REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xaml/v4.0_4.0.0.0__b77a5c561934e089/System.Xaml.dll
----------------------------------------
System.Runtime.Caching
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Caching/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Runtime.Caching.dll
----------------------------------------
Microsoft.Build.Tasks.v4.0
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3131.0 built by: NET472REL1LAST
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.Build.Tasks.v4.0/v4.0_4.0.0.0__b03f5f7f11d50a3a/Microsoft.Build.Tasks.v4.0.dll
----------------------------------------
UIAutomationTypes
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3468.0 built by: NET472REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/UIAutomationTypes/v4.0_4.0.0.0__31bf3856ad364e35/UIAutomationTypes.dll
----------------------------------------
UIAutomationProvider
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3468.0 built by: NET472REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/UIAutomationProvider/v4.0_4.0.0.0__31bf3856ad364e35/UIAutomationProvider.dll
----------------------------------------
PresentationCore
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3468.0 built by: NET472REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/PresentationCore/v4.0_4.0.0.0__31bf3856ad364e35/PresentationCore.dll
----------------------------------------
System.Windows.Input.Manipulations
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Input.Manipulations/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Input.Manipulations.dll
----------------------------------------
System.Xml.Linq
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml.Linq/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.Linq.dll
----------------------------------------
System.ServiceModel
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3440.0 built by: NET472REL1LAST_B
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.ServiceModel/v4.0_4.0.0.0__b77a5c561934e089/System.ServiceModel.dll
----------------------------------------
System.IdentityModel
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3440.0 built by: NET472REL1LAST_B
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.IdentityModel/v4.0_4.0.0.0__b77a5c561934e089/System.IdentityModel.dll
----------------------------------------
Microsoft.Transactions.Bridge
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.Transactions.Bridge/v4.0_4.0.0.0__b03f5f7f11d50a3a/Microsoft.Transactions.Bridge.dll
----------------------------------------
System.IdentityModel.Selectors
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.IdentityModel.Selectors/v4.0_4.0.0.0__b77a5c561934e089/System.IdentityModel.Selectors.dll
----------------------------------------
System.Messaging
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Messaging/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Messaging.dll
----------------------------------------
System.Runtime.DurableInstancing
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.DurableInstancing/v4.0_4.0.0.0__31bf3856ad364e35/System.Runtime.DurableInstancing.dll
----------------------------------------
System.ServiceModel.Activation
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.ServiceModel.Activation/v4.0_4.0.0.0__31bf3856ad364e35/System.ServiceModel.Activation.dll
----------------------------------------
System.ServiceModel.Activities
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.ServiceModel.Activities/v4.0_4.0.0.0__31bf3856ad364e35/System.ServiceModel.Activities.dll
----------------------------------------
System.Activities
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3440.0 built by: NET472REL1LAST_B
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Activities/v4.0_4.0.0.0__31bf3856ad364e35/System.Activities.dll
----------------------------------------
Microsoft.VisualBasic.Activities.Compiler
Assembly Version: 10.0.0.0
Win32 Version: 14.7.3056.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/Microsoft.VisualBasic.Activities.Compiler/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.Activities.Compiler.dll
----------------------------------------
Microsoft.VisualBasic
Assembly Version: 10.0.0.0
Win32 Version: 14.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualBasic/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System.Management
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Management/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Management.dll
----------------------------------------
Microsoft.JScript
Assembly Version: 10.0.0.0
Win32 Version: 14.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.JScript/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.JScript.dll
----------------------------------------
System.Activities.DurableInstancing
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Activities.DurableInstancing/v4.0_4.0.0.0__31bf3856ad364e35/System.Activities.DurableInstancing.dll
----------------------------------------
System.Xaml.Hosting
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xaml.Hosting/v4.0_4.0.0.0__31bf3856ad364e35/System.Xaml.Hosting.dll
----------------------------------------
System.Data.Entity
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Data.Entity/v4.0_4.0.0.0__b77a5c561934e089/System.Data.Entity.dll
----------------------------------------
DevExpress.XtraCharts.v14.2.Extensions
Assembly Version: 14.2.3.0
Win32 Version: 14.2.3.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/DevExpress.XtraCharts.v14.2.Extensions.DLL
----------------------------------------
DevExpress.XtraPivotGrid.v14.2
Assembly Version: 14.2.3.0
Win32 Version: 14.2.3.0
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/DevExpress.XtraPivotGrid.v14.2.DLL
----------------------------------------
System.DirectoryServices.AccountManagement
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0 built by: NET472REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.DirectoryServices.AccountManagement/v4.0_4.0.0.0__b77a5c561934e089/System.DirectoryServices.AccountManagement.dll
----------------------------------------
Ionic.Zip
Assembly Version: 1.9.6.0
Win32 Version: 1.9.6
CodeBase: file:///C:/Program%20Files%20(x86)/NPrinting/Designer/libs/Ionic.Zip.DLL
----------------------------------------
Microsoft.CSharp
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.CSharp/v4.0_4.0.0.0__b03f5f7f11d50a3a/Microsoft.CSharp.dll
----------------------------------------
System.Dynamic
Assembly Version: 4.0.0.0
Win32 Version: 4.7.3056.0
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Dynamic/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Dynamic.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

Frank_S
Support
Support

@PoojaPrasad 

I know this works as I have recently updated this article with the images and results therein.

So there is likely a problem with your syntax or other. If you have two columns with dates, makes sure they are actually both date format in your source QVW/QVF file.

Try create a test report and ensure you use 'levels' only as shown in the article. Do not use tables to do this.

Try one date column at a time in your test report.

Hope this helps...have a good weekend.

 

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Ruggero_Piccoli
Support
Support

Hi,

Did you checked if both Qlik Sense columns have the same settings?

The script code need to be duplicated and customized for each column:

Pixel Perfect Date Formatting when Date Field Used as a Level.png

Could you post some screenshots of your template, script, etc to help us to understand?

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
PoojaPrasad
Creator II
Creator II
Author

Hi @Ruggero_Piccoli ,

I have these 2 date columns in a table in Qlik Sense App.

DateIssue.PNG

Format for both date columns in csv file is same, also the code in Qlik Data Load Editor:

date(@15,'MM/DD/YYYY') as [Date of Hire],
date(@16,'MM/DD/YYYY') as [Current Position Date],

The pixel perfect report showed  it correctly until we upgraded the environment and db and designer to release 2019. After the upgrade,

I was not able to generate the report at first using On demand reporting. So, I recreated the connection in Nprinting and exported back the report for this new connection as per the suggestion in following post and it solved the issue.

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/On-demand-report-quot-Request-failed-quot/t...

 
But the new report shows dates like this:

DateIssue2.PNG

Prior to this issue, I already had similar issue on another date column for which I used the solution:

https://support.qlik.com/articles/000034881?_ga=2.81637207.1360109627.1572533236-1122559782.15627735...

But the same solution not working for these dates.

Please note, these dates are added as objects in Tables and not in Levels. But it was working fine previously without any scripting required.

Kindly let me know how can I fix the date issue on report.

Best Regards,

 

 
 

 

 

 

PoojaPrasad
Creator II
Creator II
Author

I was able to solve the issue by loading both the dates as text in Qlik Data Load Editor

text(date( @15,'MM/DD/YYYY')) as [Date of Hire],
text(date( @16,'MM/DD/YYYY')) as [Current Position Date],

I think Nprinting Pixel Perfect Report has issue while printing the date values. If the date column is read as text, it displays it fine.

Thank you,