This is fine if you are dealing with the same separators in every occurrence.
I would advise that you add & chr(13) & between fields in the formula that creates the string.
Hi smcnulty2000.
The evaluation is done in the order the objects were placed in the section (they are all in a report header section)
I'm surprised at this, I was expecting them to be evaluated in relation to their positions from left to right.
A problem occurs if you accidently move an...
Hi smcnulty2000 & IdoMillet, thanks for your posts.
Good idea about the position of the number, makes it much easier to edit.
IdoMillet, I think in your idea each formula would still to specify a specific value for the global variable. I'm trying to get away from that and just have one...
Hi,
Is it possible to assign the name of a formula to a variable?
I have 120 formulas which call a function which returns a string.
Each formula name has a number in it's name and I want pass this number to the function.
At the moment each of the 120 formulas uses a unique bit of code e.g...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.