0

Empty filter error on linking with another table

Jet Reports Historic Posts

February 17, 2015 17:12

None

Follow

Hello Experts,

I have a report that links the purchase header with purchase line and further, with purchase receipt line table.

For the purchase line, I have used a NL row replicator, and then the NF() for Document No. & Line No.

For linking the receipt line, and populating the Document no., I have used the following formula:
=NL("Rows","Purch. Rcpt. Line","Document No.","Order No.",S8,"Order Line No.",T8)

On report execution, the output flashes an error "the filter can not be empty" and the cursor points to the cell, which does not have a corresponding Order Line No. i.e. No value in cell T8

I tried using the "allow special characters" function for the filter values S8 and T8, but it didn't work.

I also tried to tweak the formula by using the IF condition, but it does not work correctly:
=IF(len(T8)>0,NL("Rows","Purch. Rcpt. Line","Document No.","Order No.",S8,"Order Line No.",T8),"")

The issue is how do I deal with this empty filter that links to other table.

Thanks in advance for the help.

• Facebook
• Twitter
• LinkedIn

6 comments

• 0
  
  Jet Reports Historic Posts February 18, 2015 07:31

  =NL("rows";IF (B2=XYZ)….
  
  Hi,
  
  NL(rows) in combination with an "IF-Function" is a little bit tricky.
  
  =NL("Rows",IF(len(T8)>0,"Purch. Rcpt. Line",{" "},"Document No.","Order No.",S8,"Order Line No.",T8)….
  
  i'm not sure, if that works for you, bcause i can't try it with my datasource…
  
  regards
  jetsetter

• 0
  
  Jet Reports Historic Posts February 18, 2015 09:10

  Hi,
  
  You solution is simply great. It worked !
  
  Thanks a lot.
  
  As specified in your formula:
  =NL("Rows",IF(len(T8)>0,"Purch. Rcpt. Line",{" "},"Document No.","Order No.",S8,"Order Line No.",T8)…
  
  What is the significance of {" "} & how is the NL with IF statement executed ?
  
  I am not clear on it, so if you elaborate, it will be really great ?
  
  Thanks.

• 0
  
  Jet Reports Historic Posts February 18, 2015 10:13

  Hi,
  good to hear that it works for you.
  
  {" "} means, that "IF len(T8)<=0", then tere is a "blank"….
  So, if you Change it to {"not found"} , there would be the string "not found" in the cell instead of a blank cell.
  
  regards

• 0
  
  Jet Reports Historic Posts February 20, 2015 05:29

  Thanks. It's clear now.
  
  Was wondering what is the significance of curly braces being wrapped around the " ". In what cases, would the use of curly braces be required ?

• 0
  
  Jet Reports Historic Posts February 20, 2015 20:53

  Hi
  
  Please share the working report
  
  Thanks n regards
  
  Ravi

• 0
  
  Jet Reports Historic Posts February 25, 2015 10:39

  HI,
  
  also look here..
  
  http://kb.jetreports.com/article/AA-00485/25/
  
  regards
  jetsetter