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.

Enhancements and revisions in Adagio GridView 9.0D (2011.08.28)

• Filter Toolbox now allows the creation of complex compound Filters from simple ones known to be working correctly. A context menu allows you to select “AND”, “OR” or “NOT” conditions to combine two or more Filters. “AND” conditions must be met before any OR conditions are evaluated. Access the Filter Toolbox by pressing Alt-F6 in a view to toggle it on and off.
  
  
• The /XD parameter now respects the “Allow export” option to permit explicit control of the worksheets created in a GridView exported workbook. You have explicit control whether the export file contains the Total row. This is useful if GridView is preparing a file for eventual re-import.
  
  
• File | Set Workspace Recalc Order now allows explicit control of the order that Views in a Workspace are loaded and recalculated.
  
  
• Tooltips have been enhanced to display calculation and field information, as well as the File driving the View when the cursor points at various elements in the View. Hovering over the Row number shows the Row Format formula. Hovering over the column name show the Column Formula.
  
  
• =GETLINKEDRESULT() has new parameters that allow totaling of arbitrary values in a linked View, whether or not the View is sorted or summarized.
  
  
• Shift-click on the ExcelDirect button now exports the entire Workspace in a single click. Alt-F-E-W accomplishes the same task from the keyboard.
  
  
• A new column operator, “Display Calculation” has been added to force GridView to re-process a calculation on the displayed totals. This is useful for margin and other % calculations that are not  “associative”.
  
  
• You now are prevented from Deleting a column used in another calculation.
  
  
• You can now display the Top/Bottom N records in a View. A row is always displayed summing the remainder of the entries. Top N is displayed if the column is sorted in Descending order. Bottom N for Ascending sequence. “N” is user selectable.
  
  
• When a View has been named and Summarized, you can Create a Summary View by selecting Create Summary View from the context menu available on the View Selector (top left hand intersection of Title Row and Row counter). The Summary View is one record per item from the summarized row. This allows Top/Bottom N displays of amounts calculated by summarizing detail records (for example, Top 10 invoices this month from SalesAnalysis). Filters and many other View options are not available on this special View which will be saved with the Workspace.
  
  
• Auto Hide, a new column option is available that automatically hides a column if all rows in the View are blank for that column. This is useful in the creation of Summary Views that display only columns useful in the summary.
  
  
• The Formula and Filter definition dialogs now use a monospace font to improve readability of the formulas.
  
  
• GETEXTERNALDATA() now takes an optional record number to retrieve data from files that are not indexed (like the Company Profile). GETEXTERNALDATA("@L90DGLO","Current Fiscal Year",0)will return the currently defined fiscal year from the Ledger company profile.
  
  
• GETLINKEDVALUE() returns a matching value from another View in the workspace. Its operation is similar to VLOOKUP() in Excel. Parameters control whether and exact match is required, or you wish to return the next highest or lowest value from that passed.
  
  
• FILTERMOD() returns the text after the “+” in the View title when a Child View is linked to from another View (for example, Customer transactions from the customer master). This allows passing of some text from the Parent to the Child Filter in a Workspace.
  
  
• GETCODEDTEXT() translates a coded database value to its full text equivalent in Formulas. Normally Coded Fields are not translated in a Formula for evaluation consistency.
  
  
• ROW() places the value of the row for the record when it is being read from the database. Sorting the View will not change the value.
  
  
• A new Summarize option has been added to the Filter definition which will automatically summarize the View according to the selected sequence when that Filter is processed.
  
  
• The Filter name box has been made wider. To take advantage of the increased width, Click View \ Customize | Settings and reset the File toolbar.
  
  
• All QUERYxxx() functions now take a third parameter that, if non-zero, causes the QUERYxxx() function to be executed once, and only once for a View. Any edit of a Calculated column or Filter will result in the QUERYxxx() function being re-invoked.
  
  
• If a user is not able to Edit Views in the Workspace, then collapsed Views cannot be expanded. This allows confidential data required for calculations to be hidden from View.
  
  
• New, Rename and Delete buttons have been added to the Define Sort Sequence Dialog.
  
  
• A Named Item file can now be associated with a specific View. The file will have the name of the View with a .GVNames extension. An error will be displayed if the associated file cannot be found when the View is loaded.
  
  
• When using GridView to automatically created Excel workbooks using the /XDW or /XDP command line parameters, you can now test for success or failure of the operation using the ERRORLEVEL value in the batch file. Successful operation sets this value to 0. Any logged error results in 1 as a return code. Improper format of the /XDW or /XDP parameters return 2 or 3 respectively.
  
  
• File | Open Dataset allows you to quickly change the data being loaded in a View from the File menu. This was possible before using the F2 – Defaults dialog, but was not apparent to many users.
  
  
• The Formula Verify function has had several inconsistencies corrected and now better handles calculations involving previously defined calculated columns.
  
  
• When linking from one View to another in a Workspace, you can now select a Filter in the target View to be selected when the View is refreshed as a result of a double click on the link column. Leaving the Filter choice blank results in the currently selected Filter being used.
  
  
• Field Lists and Calculated columns now have a check box to Enable/Disable hiding of the Column. This allows you to quickly hide/unhide an individual field or calculation.
  
  
• The AdagioPDF printer driver is available to print views to PDF files.
  
  
• This version moves toward our goal of a more Windows 7 friendly environment for installation. If you are installing to a mapped network drive that is normally accessible, but you cannot see it during the install when attempting to select a drive or folder, you can now install by browsing to the correct folder using the Universal Naming Convention (UNC), for example \\myserver\accounting\. This avoids having to adjust the User Account Control settings, which requires you to restart your computer and temporarily grant Administrative privileges to the user if they are not an administrator.
  
  
• The install writes to the master install log file "AdagioMasterInstall.log" in the \softrak\system folder. This log shows the version installed and the version being replaced, the name of the Windows user who did the install and the rights for that user. An entry is also written to the log when an updated version of the Adagio Data Source (ADS) is installed, showing the version installed and the version being replaced. This log can be used to quickly determine the install history for all Adagio programs.