Financial Row Designer

The Row Designer form is used to create rows that you want to be shown in your financial reports.  Rows configured in this form directly work with the columns configured in the Column Designer form.

1.        The Row Name field is used to enter a row component name.

2.        The Description field is used to enter a detailed description of the row component name.

Each Column header is described below.

1.        The Delete button at the leftmost part of the form is used to delete  a particular row.

2.        The checkbox box that follows it is used to mark the rows you would want to delete.  This works with the Delete selected rows button, which can be found when you click on the Delete button at the top of the form.  This is best use if you want to delete multiple rows at the same time.

3.        The Ref No. field is a system-generated number.  This number increments as you add a row for the specific report.  Right-click at any part of the row and click Insert to create and insert a new row.

4.        The Description field is used to enter a description/value to name a particular row.  This will be displayed on the report if you set proper column component to match it, which should be Row Desc column type.  The Ellipse button on this field when clicked will open the Row Options form. See Row Description grid to show you sample screenshots on how this works.

3.        The Row Type combo box field is used to select a row type.  Each row type is explained in detail below.

Calculation – This type of row is also known as the calculated row.  When this type is selected, use the Accounts Used field to configure the data you would like to filter and be shown on the specific row.  Filtering of data can be by Account Description, Account Group, Account ID, Account Type, Department and Primary Account.

 From all the row types, only Calculation and Hidden row types can use the Filter Accounts option.  Hidden row type will be discussed in the succeeding examples. See Calculation row type sample to show you how this row type works.

Center Title – This row type will display a title aligned on the center of the row. This will not allow columns on the specified row. The width of the title will take the entire width of the report. See Center Title row type sample to show you how this row type works.

Cash Flow Activity - This row type can be used to display the movement of cash in a particular account for a specified period of time.  This  should be selected if you are  to create Cash Flow Statement.  See Cash Flow Activity row type sample to show you how this row type works.

Desc Title – This row type works with the “Header Caption” field of the Column Component of the Report. The alignment of this title will be based on the alignment selected  in the Alignment field of the Column Component. The width of this title will also be taken from the "Column Width" property of the Column Component. See Desc Title row type sample to show you how this row type works.

Double Underscore – This row type will display a double line on each of the columns except for “Row Desc” and “None”  Column Types. See Double Underscore row type sample to show you how this row type works.

Hidden – This row type is considered as a Calculation row type but is NOT visible in the report.  What makes it different from None row type is it shows No blank row created, None row types also cannot open Filter Types.  Like Calculation row type, this is directly taken from the database and is filtered by Account Description, Account Group, Account ID and Account Type.  Only Calculation and Hidden row type can use the Filter Accounts option. See Hidden row type sample to show you how this row type works.

Left Title – This is a row type will display a title aligned on the left part of the row. This will not allow columns on the specified row. The width of the title will take in the entire width of the report. See Left Title row type sample to show you how this row type works.

None – This is a row type that serves as a blank row. This will be shown into the report but as a blank row only. See None row type sample to show you how this row type works.

Page Break - This row type will simply create a break from where it is inserted on the row designer, moving all rows below it to the next page.  See PageBreak row type sample to show you how this row type works.

Right Title – This row type will display a title aligned on the right part of the row. This will not allow columns on the specified row. The width of the title will take in the entire width of the report. See Right Title row type sample to show you how this row type works.

Total Calculation – This row type will display a summation of Calculation and Total Calculation type of rows. Users can create calculations on the Related Rows property of the row. Only Total Calculations can use the Related Rows property. See Total Calculation row type sample to show you how this row type works.

Underscore – This row type will display a single line on each of the columns except for “Row Desc” and “None” type Columns. See Underscore row type sample to show you how this row type works.

4.        The Related Rows field is used by Total Calculation type rows.  Click the ellipse button on this field to open the Row Calculation form where you can setup or create computations based on the existing Calculation type rows and other Total Calculation type rows.  Hidden type rows are considered as Calculation type rows and can be used in the calculations.

5.        The Balance Side field is used to configure if the row should get the sum of Debit less Credit on GL Accounts, or sum of Credit less Debit.

Debit (Blank) – will sum all transactions on Debit side less the sum of all transactions on Credit side on the GL Accounts. All rows are set to Debit side by default. This will set the field to blank. See Debit balance side sample additional info about this field.

Credit – sums Credit less Debit on the GL Accounts. See Credit balance side sample for additional info about this field.

6.        The Accounts Used field is used when Calculation and Hidden type is selected in the Row Type field.  Click on the ellipse button to open the Filter Accounts form where you can configure how data will be filtered. See Accounts Used sample to show you how this field works.

7.        The Link to GL checkbox is used to enable/disable users to drill down to the General Ledger By Account ID report.  All values can only drill down to this specified report. See Link to GL sample to show you how this works.

Sorting options

Right-click and select Insert on a specific row to insert a new row above it.  You may also use the Sort buttons found at the upper right of the grid area to move the row up and down.

Toolbar buttons

The New button will open the Add New Row form where you can enter new Row Component Name and Description.

The Save button will save the selected row component.

The Find button will enable you to Find Row Components.

The Undo button will cancel out the last change/s done to the record reverting it to its older state.

The Duplicate button will create a duplicate of the selected row component.

The Generate button will open the Generate Rows form where you can create rows for each account on you chart of accounts.

The Synchronize button detects any inserted or deleted rows on your row designer to align the formula on the associated column component with a row calculation column type.

The Import button will overwrite the selected row component with the content of the xml file that you chose to import.

The Export button will create an xml file of the selected row component.

The Delete button will delete the selected row component.

The Close button will close the Row Designer form.

Press F1 or click F1-Help in the Status bar for help on how to use the Row Designer form.