Format a number within a string

Include a formatted number in a text string.

If you want to display a formatted number on its own, you use a Decimal Format Box. However, if you want to include additional text with the number, you must use a Word Box and format the number within the string.

For this example, you set the Text property to the following expression:

"Order "+orderline.orders.orderid.format("---#")+" from "+orderline.orders.orderdate.trim()

Tip:

It is good practice to use the trim() function to remove extra whitespace from a string expression.

The format() method converts the Numeric value to a String representation. This prints text on the report in the format "Order X from Date", for example, "Order 5 from 2014/06/24".