0

IF with NL(Rows)

Jet Reports Historic Posts

January 19, 2016 09:51

None

Follow

Hello,

Please help with with the following issue…

B2 = 19.01.2016
B4 = 04.01.2016
C4 = B2 - B4 (=15 days)
D4 = IF(C4<0,””,NL("Rows","Production Order",,"Initial Unit Price Date",B4))

The thing is that when I Refresh the report it only brings back the first row from the NL function… not all the rows that are allocated to that specific date.
If I modify so that D4 = NL("Rows","Production Order",,"Initial Unit Price Date",B4) it works great. So it has something to do with that IF…

Thanks!
Elena

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts January 19, 2016 15:22

  Hi Elena -
  
  Here is the article from the Jet Knowledgebase concerning conditional replication –> http://kb.jetreports.com/article/AA-00485
  
  As you can see, rather than trying to embed the NL("Rows") function within the Excel IF() statement, you will want to reverse that.
  
  Probably what you would want in cell D4 is
  
  =NL("Rows",IF(C4>=0,"Production Order",{""}),,"Initial Unit Price Date",B4)

• 0
  
  Jet Reports Historic Posts January 20, 2016 09:03

  Thank you!
  Never would have thought of that…
  But won't this kind of approach expand the running time of the report? Will go into a NL(Rows) function for each day of the year (as in my report's case), even if it's not necessary…
  I'll give it a try later today.
  
  Elena

• 0
  
  Jet Reports Historic Posts January 20, 2016 15:07

  Hi Elena -
  
  The Jet Essential reporting engine will evaluate the function. This takes some amount of time regardless of the outcome. So, in short, the answer is yes… although the additional time should not be substantial.