Hi all,
This is my first post so apologies in advance for any slip ups!
I have a NL Sheet function within my report, but a minority of the reports I will run using this template require this functionality to be turned off.
Aside from deleting the function before running these particular reports, how can an insert an option to choose whether this function is used?
I did try an IF formula with the logical test based on an entry in the options tab, but the NL functions do not work within another function.
Hope you can help
Many thanks
Date
Votes
4 comments
-
Jet Reports Historic Posts Official comment Hi,
Yes you can "short cut" the evaluation of an NL replicator such as NL(Sheets) but putting an IF function in the Table argument and specifying an empty array (or an array with whatever value you want to be displayed in the cell when it's not replicating). So it would look something like this:=NL("Sheets",IF(Options!C5,"Table",{"Placeholder"}),…)
So this assumes that C5 on the Options tab will have a value indicating whether to replicate sheets or not. If the value is true, the sheets will be replicated from the Table; if it's false, then the value Placeholder will be displayed instead. Does this work for you?
Regards,
Hughes -
Jet Reports Historic Posts Perhaps my solution is overly simplistic - but when faced with such a problem I save two versions of the report - one with the portion I normally need, and one without it.
In a case like this I would probably have a version called - "FILENAME with NL SHEET", and another version called "FILENAME without NL SHEET" (or if others are using it I would probably say it was with or without tabs). -
Jet Reports Historic Posts Thanks for the reply Heather.
I agree that is an option but that raises the problem of any future amendments to the report being carried out twice. But perhaps this will prove to be the only choice! -
Jet Reports Historic Posts Many thanks Hughes, that gives me exactly what I need.
Much appreciated!
Please sign in to leave a comment.