Pixel Perfect NPrinting Help

Tue, 11 Oct 2016 16:57:04 GMT

Hello Qlik Community

I am trying to create a PDF report using Pixel Perfect and NPrinting that has a hours of operation field. The issue that I have is that my hours of operation come out on my NPrinting report as a continuous line:

Sun: Pharmacy ClosedMon: 09:00

AM - 05:00 PMTue: 09:00 AM -

05:00 PMWed: 09:00 AM - 05:00

PMThu: 09:00 AM - 05:00 PMFri:

09:00 AM - 05:00 PMSat: Pharmacy

Closed

Instead of:

Sun: Pharmacy Closed

Mon: 09:00AM - 05:00 PM

Tue: 09:00 AM - 05:00 PM

Wed: 09:00 AM - 05:00 PM

Thu: 09:00 AM - 05:00 PM

Fri:09:00 AM - 05:00 PM

Sat: Pharmacy Closed

I have tried creating a text object using the following code:

=if(TwentyFourFlag='X','Open 24 Hours',Sunday_Hours&chr(13)&Monday_Hours&chr(13)&Tuesday_Hours&chr(13)&Wednesday_Hours&chr(13)&Thursday_Hours&chr(13)&Friday_Hours&chr(13)&Saturday_Hours)

I have tried creating a field in the load script:

if(TwentyFourFlag='X','Open 24 Hours',Sunday_Hours&chr(13)&Monday_Hours&chr(13)&Tuesday_Hours&chr(13)&Wednesday_Hours&chr(13)&Thursday_Hours&chr(13)&Friday_Hours&chr(13)&Saturday_Hours) as Operation_Hours

I have tried creating a formula in the Nprinting using the same logic as above as well as replacing the chr(13) with chr(10). Nothing works. The PDF still outputs the hours of operations on one line.

Has anyone been able to create a carriage return or line feed to force a new line in NPrinting? Any help would be greatly appreciated.

Thanks,

Sherry

Re: Pixel Perfect NPrinting Help

rviel_dubo — Tue, 11 Oct 2016 19:32:00 GMT

Hi Sherry,

Go to property grid for your label, select "yes" for "Multiline" under the "Behavior" tab.

It did worked for me using Chr(10).

Regards.

Re: Pixel Perfect NPrinting Help

Tue, 11 Oct 2016 20:48:53 GMT

Works perfectly! Thank you for your assistance on this.

Re: Pixel Perfect NPrinting Help

kdmarkee — Thu, 02 Aug 2018 17:53:59 GMT

Just what I was looking for, thanks. It also works with chr(13). I am using NPrinting April 2018.

topic Pixel Perfect NPrinting Help in Qlik NPrinting

Pixel Perfect NPrinting Help

Re: Pixel Perfect NPrinting Help

Re: Pixel Perfect NPrinting Help

Re: Pixel Perfect NPrinting Help