topic Re: How to define a PixelPerfect DetailReport Visibility via Script (NPrinting)? in Qlik NPrinting

How to define a PixelPerfect DetailReport Visibility via Script (NPrinting)?

Anonymous — Mon, 02 May 2016 07:17:33 GMT

Hello folks,

i have a problem with my PixelPerfect-Report. I want to make my DetailReports dynamic visible with the help of a QlikView variable. So i thought, this could be possible with the Script-Language (e.g. VB) in NPrinting where i can create/define my PixelPerfect-Report. The problem is, that i have no idea how to set the settings for this issue. I know there is a Visible-Boolean in the Property Grid but how can i use it in the Detail-Report? Is there a API or something?

Or can i directly use a if-method where i check my QlikView-Variable and then set Visible=True or False?

Re: How to define a PixelPerfect DetailReport Visibility via Script (NPrinting)?

Daniel_Jenkins — Mon, 02 May 2016 08:58:18 GMT

Hi Florian,

Yes you can add the variable into the PixelPerfect report and hide/show based on it's value using a rule.

In the attached project I have a QlikView variable vHideDetail

0 = Show (any other value = hide)

Steps:

(i). Add the variable to the report template

(ii). Hide the detail report by default

(iii). Create and apply this conditional rule on the detail report

Output based on the value of vHideDetail:

Extract to folder C:\Temp\Community\065 or change the paths used in the NSQ.

HTH - Daniel.

Re: How to define a PixelPerfect DetailReport Visibility via Script (NPrinting)?

Anonymous — Tue, 03 May 2016 08:58:21 GMT

Awesome, thank you very much!

Easier than i thought

Re: How to define a PixelPerfect DetailReport Visibility via Script (NPrinting)?

Wed, 11 May 2016 18:26:53 GMT

HI Daniel

I am using your exact logic yet the conditional rule is not working. I double checked against your sample. What am I missing.

I have the variable in QV

I set the object default to No for Visible

I used your exact syntax with my variable name in the conditional rule logic yet when I run it, it defaults to not show for all, even where the variable = 1 in my case.

I am using Version 16.0.0.1

Re: How to define a PixelPerfect DetailReport Visibility via Script (NPrinting)?

Wed, 11 May 2016 18:33:38 GMT

AH HA. One step missing. You must make sure you have a Data Member assigned! Walla! All good now.

I am just learning the pixel perfect reports. I don't yet understand the point of the Data Member.

Re: How to define a PixelPerfect DetailReport Visibility via Script (NPrinting)?

Wed, 11 May 2016 18:49:54 GMT

And, another step. You MUST have the variable actually in the report as opposed to just in the field list area. 🙂

Re: How to define a PixelPerfect DetailReport Visibility via Script (NPrinting)?

Daniel_Jenkins — Wed, 11 May 2016 22:08:37 GMT

Hi Deborah,

Glad you got that working. And yes, you need to have the variable somewhere on the actual report, although you can of course hide it. Good catch!

Daniel.

Re: How to define a PixelPerfect DetailReport Visibility via Script (NPrinting)?

mstoler — Fri, 24 Dec 2021 18:15:45 GMT

Hello,

Does this work with the current version (Nov 2020) of NPrinting?

Thanks,

Michael

Re: How to define a PixelPerfect DetailReport Visibility via Script (NPrinting)?

Lech_Miszkiewicz — Sun, 26 Dec 2021 03:00:54 GMT

Hi @mstoler

yes - it does. Keep in mind though that variables work differently so you must have "=" sign in front of variable formula as explained below:

https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/Troubleshooting/Variables-dont-expand-before-calculating.htm

cheers

Re: How to define a PixelPerfect DetailReport Visibility via Script (NPrinting)?

mstoler — Sun, 26 Dec 2021 14:24:45 GMT

Hello,

Yes it does work but it does not appear in the variable section below.

I assume this is correct that the variables are not listed?

Thanks for your help!

Michael

Re: How to define a PixelPerfect DetailReport Visibility via Script (NPrinting)?

Lech_Miszkiewicz — Mon, 27 Dec 2021 02:55:43 GMT

Hi Michael

have you dragged and dropped variable into your detailed report before going into the expression editor? As stated in the above conversation :

"And, another step. You MUST have the variable actually in the report as opposed to just in the field list area. "

EDIT:

ooo.. I understand what you mean now... Yes, you are right - I experience the same - variables seem to be invisible in editor, still they seem to work ok.

Re: How to define a PixelPerfect DetailReport Visibility via Script (NPrinting)?

mstoler — Mon, 27 Dec 2021 12:53:35 GMT

Hello

Thanks for the confirmation.

This is a powerful feature.

Michael