Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
prasadcm
Creator II
Creator II

Nprinting 17.1 filters

Hi All,

In my QV file,i have filters like Year,month,currency whose properties say 'Always 1 selected'.

Now i want this filters to be applied to in Nprinting,i created filters using following

d1.png

I also tried max() in evaluate value,but it doesn't work

When i hard code this values,it works fine.

How am i suppose to do ?

gwassenaar

djk

Regards,

Prasad

7 Replies
cesaraccardi
Specialist
Specialist

Hi,

Have you tried using Only() instead?

=Only([last year])

=Only([acct month])

=Only([tocurrency])

ramchalla
Creator
Creator

Hi Prasad,

Use max function, check the values for those filters when you run the task and place a screenshot.

prasadcm
Creator II
Creator II
Author

Hi,

I have tried using max function,but data doesn't get filtered.

When we run the task,QV which runs behind shows no selection in filters

Regards,

Prasad

Daniel_Jenkins
Specialist III
Specialist III

Hi Prasad,

You should not use Always One Selected Value. See this discussion for more information: Re: Nprinting Excel Report Page

HTH - Daniel.

prasadcm
Creator II
Creator II
Author

Hi djk,

I went through that thread,but i have some doubts.

Case 1: If i don't apply any filters & 'Always 1 selected' is present for filters in QV,will data in NPrinting will come according to QV filters?

Case 2: 'Always 1 selected' is present for filters in QV,how am i supposed to get that data in Nprinting by applying or not applying filters in NPrinting?

Case 3: If i want user selected values to replicate in NPrinting,what filters needs to be applied in Nprinting?

Regards,

Prasad

prasadcm
Creator II
Creator II
Author

Hi,

I tried your way,but it doesn't work.

QV which runs behind shows no selection in filters

Regards,

Prasad

Not applicable

NPrinting does not allow "always one selected value" and will not perform a filter on that specific field.

The only solution I was able to come up with is creating a dummy field on script and having nprinting filter those dummy fields instead of the original one. Also I thing the "only" function works better than "getfieldselections".

Hope it helps.