Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 ?
djk
Regards,
Prasad
Hi,
Have you tried using Only() instead?
=Only([last year])
=Only([acct month])
=Only([tocurrency])
Hi Prasad,
Use max function, check the values for those filters when you run the task and place a screenshot.
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
Hi Prasad,
You should not use Always One Selected Value. See this discussion for more information: Re: Nprinting Excel Report Page
HTH - Daniel.
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
Hi,
I tried your way,but it doesn't work.
QV which runs behind shows no selection in filters
Regards,
Prasad
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.