How to Configure Row Calculation row to show on Other columns

Row Calculation row along with Underscore and Double Underscore rows can either be shown or hidden on Other Columns, except Credit and Debit columns. 

Follow the steps below to guide you on how to configure rows to be shown/hidden on Other Columns only.

1. Open selected row designer record.
2. In that record, there should be Underscore, Row Calculation or Double Underscore row. 
3. Click the Show/Hide button. 
   
4. The Show/Hide Rows screen will be opened. Make sure that Underscore, Row Calculation and Double Underscore rows have Show Others checkboxes checked to show these rows when previewing or printing the report.
   
5. In your column designer record, there should be GL Amounts, Beginning Balance, Ending Balance, Debit Units, Credit Units, Budget, or Column Calculation. These columns are intended to show row balances. All the mentioned columns will go with this setup. Here is the column designer record we will use for this illustration.
   
6. 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.
7. 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 when Show Debit and Show Credit are checked for Underscore, Row Calculation and Double Underscore. Total is shown only on Debit and Credit columns along with underscore and double-underscore preceding or following it.

While this is how it will look like when Other Columns, except Debit and Credit, are unchecked.

See How to Configure Row Calculation to show on Credit and Debit columns for help on how Show Credit and Show Debit work.

Row Calculation row along with Underscore and Double Underscore rows can either be shown or hidden on Other Columns, except Credit and Debit columns. 

Follow the steps below to guide you on how to configure rows to be shown/hidden on Other Columns only.

1. Open selected row designer record.
2. In that record, there should be Underscore, Row Calculation or Double Underscore row. 
3. Click the Show/Hide button. 
   
4. The Show/Hide Rows screen will be opened. Make sure that Underscore, Row Calculation and Double Underscore rows have Show Others checkboxes checked to show these rows when previewing or printing the report.
   
5. In your column designer record, there should be GL Amounts, Beginning Balance, Ending Balance, Debit Units, Credit Units, Budget, or Column Calculation. These columns are intended to show row balances. All the mentioned columns will go with this setup. Here is the column designer record we will use for this illustration.
   
6. 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.
7. 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 when Show Debit and Show Credit are checked for Underscore, Row Calculation and Double Underscore. Total is shown only on Debit and Credit columns along with underscore and double-underscore preceding or following it.

While this is how it will look like when Other Columns, except Debit and Credit, are unchecked.

See How to Configure Row Calculation to show on Credit and Debit columns for help on how Show Credit and Show Debit work.

Row Calculation row along with Underscore and Double Underscore rows can either be shown or hidden on Other Columns, except Credit and Debit columns. 

Follow the steps below to guide you on how to configure rows to be shown/hidden on Other Columns only.

1. Open selected row designer record.
2. In that record, there should be Underscore, Row Calculation or Double Underscore row. 
3. Click the Show/Hide button. 
   
4. The Show/Hide Rows screen will be opened. Make sure that Underscore, Row Calculation and Double Underscore rows have Show Others checkboxes checked to show these rows when previewing or printing the report.
   
5. In your column designer record, there should be GL Amounts, Beginning Balance, Ending Balance, Debit Units, Credit Units, Budget, or Column Calculation. These columns are intended to show row balances. All the mentioned columns will go with this setup. Here is the column designer record we will use for this illustration.
   
6. 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.
7. 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 when Show Debit and Show Credit are checked for Underscore, Row Calculation and Double Underscore. Total is shown only on Debit and Credit columns along with underscore and double-underscore preceding or following it.

While this is how it will look like when Other Columns, except Debit and Credit, are unchecked.

See How to Configure Row Calculation to show on Credit and Debit columns for help on how Show Credit and Show Debit work.

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 article will explain.

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

1. Open row designer record.
2. In that record, there should be Total Calculation row. Click Total Calculations toolbar button.
   
3. Total Calculations screen will open. In that screen, check Show Others checkbox.
   
4. In your column designer record, there should be Calculation, Column Calculation or other columns that are intended to show row balances. All of those columns, except Debit and Credit columns, will go with this setup. Here is the column designer record we will use for this illustration.
   
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 on rows that are intended to show balances, except for Debit and Credit columns, along with underscore and double-underscore preceding or following it.

See How to Configure Row Calculation to show on Credit and Debit columns for help on how Show Credit and Show Debit work.

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 article will explain.

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

1. Open row designer record.
2. In that record, there should be Total Calculation row. Click Total Calculations toolbar button.
   
3. Total Calculations screen will open. In that screen, check Show Others checkbox.
   
4. In your column designer record, there should be Calculation, Column Calculation or other columns that are intended to show row balances. All of those columns, except Debit and Credit columns, will go with this setup. Here is the column designer record we will use for this illustration.
   
5. Generate the report. You can generate report either way:
   1. Click Print toolbar button from Financial Reports screen. See How to Print Report.
   2. Click Generate toolbar button from Report Builder screen. See How to Generate Report.
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.

This is how the report will look like with the above setup. Total is shown on rows that are intended to show balances, except for Debit and Credit columns, along with underscore and double-underscore preceding or following it.

See How to Configure Row Calculation to show on Credit and Debit columns for help on how Show Credit and Show Debit work.