I found this fomrula in one report, that apparently worked in CR 8.0, but when i did the conversion to the new version of CR (11.5) it stopped workig.
The formula is the one below, and the errore occured is: “Missing ).” and the program highlights ExecSQL
enter image description here
If I comment that line the formula doesn’t retunr any other error.
I tried different ways of adding or removing the missing parentesis, but I couldn’t make it work.
I found an other way to solve my problem, but I’m curious of the correct way to use it as it was written and to know where the missing parentesis should be
When doing this, the error changes in: “it is expected a number, a currency amount, a Boolean value, a date, date-time, or a string”
Thank you in advance for help 🙂
C.Dan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.