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
Date
Votes
3 comments
-
Jet Reports Historic Posts 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) -
Jet Reports Historic Posts 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 -
Jet Reports Historic Posts 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.
Please sign in to leave a comment.