0

Filter

Jet Reports Historic Posts

August 04, 2016 12:11

None

Follow

Hello all

A filter, which ist generated automaticly and user-dependent by jet, should be limited by a additional manual input (wizzard). It ist not allowed, to expand the automaticly generated filters by the manual input.


Example 1:
user-dependent generated filter: 306*|307*|308*
manual input: 3071*
Result: 3071*

Example 2:
user-dependent generated filter: 306*|307*|308*
manual input: 304*
Result: nothing, because manual input is out of range.



It seems like the NP-Option „intersect“ , but this doesn’t work.

I hope for your help!
Thank you and Regards

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts August 04, 2016 15:25

  Have you tried combining the references? I was able to do it with a test sample in my database.
  
  Assuming data is in these locations:
  C4 = Automatically Generated Cell: 306*|307*|308*
  C5 = Manual Input: 3071*
  
  Combine the two filters in another location (I've added spaces to the formula to make it easier to read)
  C6 = C4 & "|" & C5
  
  Then use C6 as the filter value for your report

• 0
  
  Jet Reports Historic Posts August 04, 2016 15:38

  You don't want to join them with a '|' as that means OR, what you want is & for AND - you only want to return things that are in the first filter AND in the second filter. So you should be able to combine them
  
  3071*&306*|307*|308*
  
  The only thing I'm not sure about is prioritisation, you'll need a Nav expert to tell you whether that's going to give you:
  
  (3071* and 306*) or 307* or 308*
  
  or
  
  3071* and (306* or 307* or 308*)
  
  Can you add brackets?!

• 0
  
  Jet Reports Historic Posts August 05, 2016 09:16

  Success!
  
  the solution:
  
  G6 = automatically generated (example: 306*|307*|308*)
  D10 = manual Input ((example: 3071*)
  
  MyFilter = "("&G6&")"&"&("&D10&")"
  
  it works fine.
  
  
  Thank you all
  Regards