Several times I've been asked "how do I visualize long Report Writer calculated field expressions?". At simple glance, it would seem that the horizontal list box control is all we have to visualize the expression, which could be far too complicated to deal with when working with large computations or even when invoking Report Writer functions.
|RW horizontal list box expression field|
As it turns out, there's a little known feature in this window that allows you to visualize long expressions. If you click on the "Calculated:" or "Conditional:" prompt - depending on the expression type - next to the horizontal list box, it will display the full calculated or conditional expression in the Calculated Expression window.
|Calculated Expression window|
Until next post!
Mariano Gomez, MVP
Intelligent Partnerships, LLC