Can string functions be applied to attributes in dynamic text boxes in Report Services Documents in Strategy 9.x?
No, string functions cannot be directly inserted into Report Services Document dynamic text boxes in Strategy 9.x. Static text will display instead of the function being applied.
However, there are a few options to work around this. One is to apply the desired string function in the definition of the attribute form expression. This will apply it in all instances where the attribute form is displayed, including report results and document dynamic text boxes, along with element browsing.
If the requirement is to apply the string function only in the document dynamic text boxes, a derived metric can be created in the dataset report or document itself. The definition of the derived metric could be something along the lines of the following:
UPPER(Max(Attribute@Attributeform) {~+})
The Max() function is applied since all metrics must apply an aggregation function to the underlying column that it is based on. This derived metric can then be added to the document as dynamic text or added into dataset/document grids to display the desired result.
