Format text in Crystal report

Posted on

Question :

Well I need to print a bank slip with following. Our number should be like this.
15 / 200020-3.
This same number is saved in the DB like this: 152000203.
How do I put the bar in the 3rd house, and the 10th hand?


Answer :

What I did to solve my problem was as follows:

I used a formula to display the field in the report in the format you want.
Select Formula Field. Enter the name for the formula and click OK

{boleto1.nossonumero} [1 to 2]+"/"+{boleto1.nossonumero} [3 to 8]+"-"+{boleto1.nossonumero} [9 to 9]

Links with more formatting in Crystal Report:

Macoratti and FabioMed


Leave a Reply

Your email address will not be published. Required fields are marked *