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: