You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

It is on Column Designer screen where you setup amount format for your financial reports. But there will be some instances where you will want a specific row/s to show other format. This is where Override Column Mask is being used. As the name implies, it overrides the format of your report columns for the selected row/s.

If these are your columns that show amounts,


And you want a specific row in your report to have other format/mask, example for this highlighted row, instead of having the amount format as configured on the column designer (see screenshot above), you wanted this to show in percentage format.  Follow the steps below.



  1. In the Row Designer record, select the row you would want to change/override the masking and click Fonts toolbar button.
  2. The Row Fonts screen will open. In the Override Mask field, set the new format or mask.
  3. Click the Save toolbar button to save it. In case you miss to click this button and you click the Close toolbar button or the x button at the top right corner of the screen, i21 will prompt you if you would like to save it before closing the screen.
  4. You will be back in the Row Designer screen. Click the Close toolbar button or the x button at the top right corner of the screen to close the screen.
  5. Now print your financial report and you will see that the selected row masking is now showing the new format/mask.
  • No labels