Qlik Community

Ask a Question

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
florianmayr
Contributor III
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
Daniel_Jenkins
Support
Support

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.

View solution in original post

6 Replies
Daniel_Jenkins
Support
Support

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.

View solution in original post

florianmayr
Contributor III
Contributor III
Author

Awesome, thank you very much!

Easier than i thought

Not applicable

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

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

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

Daniel_Jenkins
Support
Support

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.