Page History

The Total Calculation row should need to be configured properly to work with your report column. There are instances where balances for this row may or may not be shown in a specific column and that is what this page will explain.

Follow the steps below to guide you on how to configure Total Calculation row and show row balances on Credit and Debit columns only.

1. Open row designer record.
2. In that record, there should be Total Calculation row. Select that row and click the Total Calculations toolbar button.
   Image Modified
3. Total Calculations screen will open. In that screen, check Show Credit and Show Debit checkboxes.
   Image Modified
4. In your column designer record, there should be Debit and Credit columns to go with this setup. Here is the column designer record we will use for this illustration.
   Image Modified
5. Generate the report. You can generate report either way:
   1. Click Print toolbar button from Financial Reports screen. See How to Print Report from Financial Report Viewer screen.
   2. Click Generate toolbar button from Report Builder screen. See How to Print Report from the Report Builder screen.
6. If Show Report Settings checkbox is checked in the Report builder for a specific report, then Report Settings will be shown. In that screen, click Print toolbar button. See also How to Show Report Settings screen before report preview.

This is how the report will look like with the above setup. Total is shown only on Debit and Credit columns along with underscore and double-underscore preceding or following it.

Image Modified

See How to Configure Total Calculation row to show on Other columns for help on how Show Others works.