I have multiple expressions which redo the same calculation several times.
Part of the calculation uses an aggregated result of a field.
Is there a way to simplify and increase the maintainability of the report by creating a calculated field for a group? This field would be used multiple times in sub-groups and in the detail section.
Please note that I do not have the power to update the source code and because of this I can not create "custom functions".
I've tried to store the calculated value in an invisible text box but I can't seem to recall this value to be used in subsequent text boxes.
Very Simplified Example
Let f(x) = Avg( Field.x ) <-- How do I set this in the group header so I can reference it in the detail section?
Let textBox7.Value = "Distance From COM: " + Abs( f(x) - Field.x )
Note: If this is not possible across groups, but it is within a group please let me know. This would also greatly simplify the maintainability of my report.
Thank you for taking the time.