0

Filtering with the function wizard

Jet Reports Historic Posts

July 01, 2014 10:40

None

Follow

Hello everyone,

I'm working with Jet Essentials and I want to filter (cq look up) four things out of a database (FilteredIncident):

-a filter per week (hig_registratiedatum) date..date
-a filter on a customername (customeridname)
-a filter on when the incident was closed (date..date)
-a filter on the status (statuscodename)

Whatever I try to do, for example in the JFX function wizard (see printscreen) i get all the information out of the database FilterdIncident.

Is there anyone here who knows what I cannot seem to solve? :o Thanks so much! :lol:

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts July 01, 2014 11:50

  Hi Annelies,
  
  As I do not have this table in my database, I cannot replicate your situation. However, I would at least try the following:
  - Use an option-sheet to generate user-input on the filter values. Use NP("Eval";celladdress) to use the values in your report-sheet(s).
  - Use an NL("Rows";"FilteredIncident";;"hig_registratiedatum";NP("Datefilter";$E$5;$E$6)) in D12? This assuming E5 and E6 hold the start- en enddates for the datefilter. Of course you can change this.
  - NF's to retreive fieldvalues from the filtered records. For example NF($D12;"hig_registratiedatum")
  
  Hope this helps a bit.
  
  Best regards,
  Gerard