0

Selecting date range and blank dates

Jet Reports Historic Posts

August 24, 2009 14:14

None

Follow

I have a jet report where I have selected a data range for a date field. I also need the blank dates as well. If i select only the date range,
then the report works. If I select only the blank dates, then it works as well. I cannot seem to make it work with both the data range and the blank dates. Any suggestions would be appreciated.

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts August 24, 2009 14:19

  I would start with designing two filters - one with the date ranges and one with blank, then use a union function to join the two together.

• 0
  
  Jet Reports Historic Posts August 24, 2009 14:31

  I have never used a "union" function. Can you provide an example?

• 0
  
  Jet Reports Historic Posts August 24, 2009 14:36

  The Jet help is a great resource - have a look there if this example isn't clear.
  
  This example lists all Customers where their No starts with A or B or G or H. Obviously it could be done with one function but for the purpose of the example it should illistrate it nicely.
  
  E7: =nl("Filter","Customer","No.","No.","A*|B*")
  E8: =nl("Filter","Customer","No.","No.","G*|H*")
  E10: =nl("Rows","Customer",,"No.",np("Union",$E$7,$E$8))
  
  Note the NL Union can not be in its own cell - must be a part of another function.
  
  I believe there is another way to join two arrays together but it escapes me right now.