I realise that the Wizard does not use NP (eval) for referencing between worksheets, instead it uses the following method
=NL("Filter","Sales Line","Document No.","no.",Options!$G$6,"Item Category Code",Options!$G$12))
Besides that, i have also noticed a couple of Jet users use the exact method as above in their reports (they probably learn from the wizard)
So my question is, should Np(Eval) be used at all times or just a backup method in case the report get slow.
Do you use NP(Eval) everytime? :|
Date
Votes
2 comments
-
Jet Reports Historic Posts I'd be interested to hear other people's replies as I tend to use NP randomly. I.e. if I'm working on a report that has it, I don't remove it. If I copy from an existing report, I don't remove it. If I'm writing one from scratch, I add it only if it causes me problems by not having it.
Typically I find myself only using it in date range calcuiations (all report I write have some sort of date range associated).
What do others think about this function? -
Jet Reports Historic Posts I use it all the time in my reports. No need to see if the report runs slow to then just add it later. We have soem report templates that have them already started up in the top left corner so that I just have to add the cell name - huge time saver!
Please sign in to leave a comment.