Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

florianmayr
New Contributor III

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

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?

1 Solution

Accepted Solutions
Employee
Employee

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

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.

6 Replies
Employee
Employee

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

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.

florianmayr
New Contributor III

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

Awesome, thank you very much!

Easier than i thought

Not applicable

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

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

Not applicable

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

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.

Not applicable

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

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

Employee
Employee

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

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.

Community Browser