Public Functions and Calculated Columns
Posted: Mon Feb 03, 2020 5:58 pm
We have some reports that utilize several calculated columns. These columns call a Public Function that is defined in the Code tab, which then calls another Public Function. Both of these Public Functions are not fully defined in the code tab - they reference the assembly code for the full definition. We are seeing where text components in the report, while calling the Public Function, are not utilizing that function.
Example:
Text component is calculating the linear length of materials. The column that has the data is in either millimeters or inches. The function (A) being called converts the linear length to either meters or feet based upon a second function (B) of what format the user is utilizing. In our scenario, if the code tab uses assembly code to define function A and B, the conversion fails with no error message. If we then change the code tab to define the function for A only, the text component works.
We've made sure that the function for A is both alphabetically after B and also farther down in the code tab.
Any thoughts on this? Thank you!
Ben
Example:
Text component is calculating the linear length of materials. The column that has the data is in either millimeters or inches. The function (A) being called converts the linear length to either meters or feet based upon a second function (B) of what format the user is utilizing. In our scenario, if the code tab uses assembly code to define function A and B, the conversion fails with no error message. If we then change the code tab to define the function for A only, the text component works.
We've made sure that the function for A is both alphabetically after B and also farther down in the code tab.
Any thoughts on this? Thank you!
Ben