Row Format (Grid Formats) Article

Row Format (Grid Formats) Article

Row Formats enable administrators to provide subtotaling rows to enhance the presentation of both data entry and reporting screens in Dynamic Budgets. 

A single report can be generated and on-the-fly- can be toggled between different Row Formats to present different subtotaling.  For example, raw account data versus company totals versus OrgUnit totals.

After running a search, the format and expansion levels of a screen can be changed on the fly without having to re-run the report, in other words you can run the data to screen once and then on-the-fly, swap out formats to generate different styles of reports from the in memory data.

By using the below Row Format pull down a Define Row Formats that have been setup can be selected. 

If a Row Format has been setup as the default in Define Row Formats whenever a Search is completed, the Search will return the results with default Row Format as been pre-selected if the following setting in App Config/Menu Editor in Configuration Settings/General is set to 1.

This standard functionality is used in conjunction with Show Rollup Sub-totals and Display Level and/or Expand/Collapse Row View both of which control the expansion level of the subtotaling rows.

Below is an example of when no Row Format (Grid Format)  is designated:

Compare the above to the below where a Row Format (Grid Format)  and Show Rollup Sub-totals is selected:

    • Related Articles

    • Define Row Formats Article

      This tool is used to total and subtotal data into user defined formats. After changes are made, please Save. Please note that Expand/Reduce Column Width functionality is available. A) To Add a New Format We will first review the process and then ...
    • Column Formats Article

      Column formats can be defined in the following Setup screens: Define Custom Reports; Define Basic Budgets Entry Forms; and Define Custom Budgets Entry Forms. There are two options to setup Column formats: a) Grid Layout Tab This format supports Copy ...
    • Expand/Collapse Row View Article

      After a report is run, rows can have either a "-" or a "+" symbol to denote an available action to either expand or collapse the account details to reveal or hide the data. ​ On some reports, a Row/Grid Format needs to be selected to activate this ...
    • Row to Row Calculations Article

      This standard functionality is available on a number of screens including Basic Budget Entry/Account Details and Import Budget Assumptions. Please note that this functionality can be used in conjunction with the Exclude Row Function and the ...
    • Exclude Row Function Article

      This standard functionality is available in a number of screens including Basic Budget Entry/Account Details and Import Budget Assumptions. By checking the "Exclude" box, the data on that row is not included in calculations for the Total. This ...