I have an amount in my report which is calculated by using a variable. I need to display this amount with the currency symbol next to it ($140.00). If I use ‘=[Currency.CurySymbol] +$InvcAmt’,in the ‘value’ of the text box, I am unbale to format the ‘amount’.
The only way I am able to format the amount is to create a second text box in front of the amount for the currency symbol. The issue here is that there is now a space between the currency symbol and the amount ($ 140.00).
Is there a way to join the two where there is no space between the two, bearing in mind the number of characters in the amount can vary?