Getting CR.NET to Automatically Format

I just discovered a new trick for getting CR.NET to automatically format a number as a percentage. For example, let's say you have a number 55.99 and you want it to be printed as 55.99%. What I have done in the past is convert the number to a string and concatenate the '%' character to the end. Not bad if you only have to do this to one number, but a pain if you have to do this to more than one field. I was jealous of how CR stand-alone version has a '%' button that you click and it formats it automatically.

I went into CR10 and analyzed what is happening behind the scenes when you click on the '%' button. I found out that the button tells CR that the field is a currency value and it replaces the '$' with a '%'instead. Plus, it tells it to right-align the “currency symbol“. Wow, what a discovery. Here's how to do it in CR.NET. It looks like a lot of steps, but after you doing it the first time it is a breeze.

To format a number as a percentage in CR.NET:Right-click on the numeric field and select Format.

Go to the Number tab and click Customize.

Click the Currency Symbol tab.

Click Enable Currency Symbol.

Change the Currency Symbol to '%' Change Position combobox to '-123%'

Click OK, OK to exit and save.

Hope this helps,

Brian Bischof