Posted 24 July 2022, 3:49 pm EST
We’re trying to port a SSRS report to ActiveReports v16.
In our report, it is common to want to display a numeric field formatted as a currency. If the field is standalone, we can just set the Format property of the TextBox to the built-in currency format string.
However, generally we want the displayed currency amount to have text following it. The text should follow immediately after the currency amount, and the currency amount could be varying length depending on the value, so we are using a single TextBox with the field value and the following text concatenated.
=Fields!FeeAmount.Value & " per payment"
In SSRS we utilised the Placeholder functionality which allowed setting formatting on fields embedded within a Textbox.
We are not sure how to achieve a similar output in ActiveReports. I was expecting to be able to call a function to format the field value as a string, but there doesn’t appear to be any built-in string formatting functions.
Any suggestions on how to achieve inline formatting of field values?