Using Variables in Detail

oharab2000 — Wed, 25 Sep 2019 19:42:54 GMT

I've been fighting this all day and I've got a solution, but I don't know why!!

I've created a PixelPerfect report and it all looks good, but there are times I need to display a warning notice at the beginning of the report. The Load Script sets a variable to the value of 0 or -1 depending on whether or not the warning should be displayed.

In NPrinting I have added the variable and it's all good. So far. I add a couple of sub bands to the detail and add a Formatting Rule to the first one with a condition of:

Iif([vL_ReportIsOutOfDate]=0,True,False)

and set the visible to false.

When I run the report the condition doesn't work and the hidden band is displayed, but if I drag and drop the variable onto the detail band or the page header, then the variable appears to be evaluated and the sub band is hidden. The only way I can get this to work is by putting the variable in a hidden box at the top of the page and I don't know why! Can anyone explain what's going on?

For info, I'm (still) using NPrinting 16.2 with Qlikview 11.2.

Thanks in advance

Ben

Re: Using Variables in Detail

Daniel_Jenkins — Sun, 07 Apr 2019 23:06:56 GMT

Hi Ben,

This is working as intended in that the entity (variable in your case) must be on the report itself for it to be evaluated. There are several examples of this being discussed in these forums, here is one (go through all comments):
https://community.qlik.com/t5/Qlik-NPrinting-Discussions/How-to-define-a-PixelPerfect-DetailReport-Visibility-via-Script/td-p/1054324

HTH - Daniel.

topic Using Variables in Detail in Qlik NPrinting

Using Variables in Detail

Re: Using Variables in Detail