New Features
The View by Rows function can now be docked to a View, allowing you to easily see all the fields for a row on Views with a large number of columns. The Record View window now includes buttons to go to the first and last rows of the View. Double-clicking on a row updates the fields in the Record View.
Adagio Styles are supported. The Auto Styles button on the Font Toolbar automatically applies the record Style from the master record set with the 'Apply Styles' menu choice in other Adagio programs. In order to see the new Auto Styles button, select View | Customize from the menu, then select Font and click the Reset button. If you want to add the automatic Styles to an existing View, enable the option, then select 'Edit Definition' and press the OK button. The Styles will appear on the View.
Filters can be combined into a single composite Filter. This allows you to create simple Filters and then combine them into one complex Filter. From the Filter Toolbox, make your selections for each Filter (Ignore, And, And Not, Or, Or Not) then click the New button to build a complex formula in a single Filter containing the logical functions from all the selections.
The 'Reference filters by name' option allows composite filters to change automatically if a referenced filter is changed. A filter is referenced by its name in square brackets, for example: "[Balance Over 1000]". Disable the option to separate the composite Filter from the underlying simple ones. The filter reference changes to the original filter content, for example: "{Balance Outstanding} > 1000".
Summary Filters allow you to summarize a large number of records into only a few rows in a View, with much faster calculation and load times than summarizing a large number of detail rows. Only the rows needed are created, rather than loading and hiding the rows for all the records that are not required. To create a Summary Filter, click the New Summary button on the Named Filters dialog. You may specify a Filter to apply to records when they are read from the database, and another Filter to apply after the summary records have been created. Separate Row Format rules can be used to highlight summarized rows. Any amount or date field can be summarized (min and max only for dates). Summary Views can have Sorts, Filters and Row formatting attached which allows you to present the summary in any desired sequence with highlighting applied.
A new formula has been added: GLCALC(“spec code”, ”Fiscal year”, ”fiscal period”, ”Account”, ”Dept”[,”Division”]). Automatically calculates the value for the requested spec code for the requested entry. This may be any of the specification codes from the Adagio Financial Reporter. Popular codes include: Balance, YTD, Annual Budget, Budget YTD and Current Period.
For linked rows, an automatic Style is applied to the column to highlight the fact that the value links to another View. The style gives the cell the appearance of a button. Styles named “Link Style 1” to “Link Style 4” are provided by default and will be automatically assigned as linked columns are created.
The option Single Click Link has been added to the context menu for linked rows. When enabled, you need only click once on a linked value in the parent view to drill down and display the related values in the child view. When disabled, a double click is required. You can also press Enter to “Fire” the link and move to the next row.
The attribute 'Blank when zero' has been added to the View definition to have zero values display as white space. This can improve the readability of many Views.
A 'Reset' option has been added to View | Properties to restore the original program values.
Views can have Notes attached to the View or Workspace. Notes can be defined under the View | Notes menu choice. Notes are displayed in a detachable, docking panel when open. Notes support fonts, bold, italics, underline, and bullets. If a View has Notes there will be a check mark next to Notes in the View menu. Clicking this menu choice will open the Notes.
Columns may have notes attached which explain the purpose of a calculation or the information that will be displayed in another View if the column is clicked. Notes are displayed if the user hovers the cursor over the column heading. Notes are added by selecting Add Note from the right mouse context menu on the column heading.
GridView 9.0E has new a new program icon.
Buttons have been added to some dialogs to expose options that were previously only available on the right mouse button context menu.
A new menu choice, File | Gather files for support, is available to assist in tracking down problems in specific Workspaces. This menu choice automatically copies only the necessary files for running the specific Workspace into a single directory for support, including the necessary data dictionaries and data files. The resulting Folder can be Zipped and e-mailed to your support technician.
Workspace Recalc order improved. Workspaces are processed sequentially in the order in the list. One View will be completely processed before the next View is loaded.
If you attempt to Enable Filters, and no Filter has been defined, you will be taken to the Edit Filter dialog to define a new Filter.
You can now select Min/Max values for a date column. A specific Style has been defined to highlight Date Min/Max calculations.
Columns may now have the attribute 'Hide when summarized'. This can automatically hide a column that is not relevant when a View is displayed in summary format.
You now have more control over date formatting. Setting decimals to 0 results in 1/1/12 instead of 01/01/12.
Subtotal formulas are now used in tables where available so that expected values are displayed in the Excel worksheet when ExcelDirect is used.
GridView now reports a wider range of error conditions if the ExcelDirect button fails to connect to Excel.
A new toolbar button is available to reset Workspace Queries. All =QUERYxxx() functions take an optional third parameter that, if non-zero, results in the query being executed once per load of a Workspace or View. In previous versions if you wanted to change an answer supplied to a query function, the View/Workspace had to be reloaded. Clicking this new button will cause the next refresh to re-prompt the user for all =QUERYxxx() values. In order to see the new button, select View | Customize from the menu, then select Toolbars and click the Reset button.
GridView now displays the 10 most recently accessed Dictionaries and Tables.
Help | Active Users now shows Adagio users in all companies if you are logged in as SYS (and not running in RW mode). Also shows the 'Free used' license count (Adagio consumes a "free", module specific license, for the first instance of the module, rather than using a Lanpak license). The Company Name, Data Path, Extension, Computer Name and other new fields are shown in the grid, in addition to just the Adagio User Name and Application in earlier versions. The column editor is enabled on the grid and an Excel Direct button has been added.
Duplicate button on filters allows you to quickly create a new filter with the contents of an existing filter as a starting point, rather than having to created an empty new filter and copy and paste the contents.
Sample Views in \softrak\gvwin\views\Adagio have been updated. They now all use the GETEXTERNALDATA function added in GridView 9.0C (2010.10.01) rather than the composite dictionaries, such as 'Adagio {Composite Tables 9.0A}' (@Z90A), which are no longer maintained.
When GridView is opened after installing an upgrade, a dialog is displayed with a link to a short video highlighting the new features. The dialog is displayed for each user until they tick 'Don't show this message again'. The video also be viewed anytime by visiting the Softrak website. Note: the dialog also appears when Adagio is installed at a new site.
The Help | About screen has been redesigned and includes a link to a documentation page for the module that shows New Features, What's New video and manuals.
Problems Fixed
A View that contains a QUERYxxx function does not hold data files open while waiting for input. This could have caused data integrity errors in a multi-user environment in some cases.
A View with 'Auto refresh' enabled that contains a QUERYxxx function will not prompt again until you complete entry for the first prompt.
For a View with 'Refresh on open' enabled the user is prompted only once for QUERYxxx functions. Previously the prompt was needlessly repeated.
Print Preview no longer re-prompts for QUERYxxx() functions.
Formatting is now correctly applied to the entire column, including the total row, when the column is selected.
Some correctly constructed formulas would be incorrectly flagged as “Invalid”.
The field properties where shown for the wrong field when they were opened from Selected Fields within a Filter.