Adagio GridView 9.0D 2011-08-28 (Aug. 28, 11)

9.0D release notes
Video demonstration of 9.0D

• The new Filter Toolbox 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.
  
  
• Explicit control of workspace load and evaluation order has been added. Automatic exports can now suppress totals and entire Views from the created Excel workbook.
  
  
• Many small user interface improvements, such as use of a mono-spaced font in the Filter and Calculated Column formula box improve the ease of View design. Quickly show or hide a field or calculated column from a View.
  
  
• Export an entire Workspace with a single Shift-click.
  
  
• “Top/Bottom n” View selection is available, with automatic calculation of “other” for the other summarized entries.
  
  
• Automatically hide a column containing only blanks or 0.00.
  
  
• Automatically sort and summarize a View when a specific Filter is selected by the user.

Version 9.0C | 2010-10-01 (Oct. 1, 10)

9.0C release notes

• User security has been added. The SYS user can now restrict other users from using GridView to see confidential data. If security is turned on, users must be given explicit permission to create Views against a module’s data.
  
  
• Data elements from tables external to the main View, can now be included in the View, without using a “Composite Table”. Composite tables are no longer required since you can select any data element from a related external table. Use this to include the Inventory Item description when creating a View from the OrderEntry Order Detail. Or include the General Ledger account description when creating a View from the posted transaction file.
  
  
• Column Totals (or Min/Max/Averages) from another table can be included as a calculated value in the main View. Use this to calculate “Percent of Total” figures.
  
  
• Retrieve any field or calculated result from another table by matching a data value. This is similar to invoking the VLOOKUP() function in Excel across Views.
  
  
• Edit a column calculation directly on the View, without having to invoke the Edit | Calculated Columns function. This greatly speeds up the creation and correction of calculated columns.
  
  
• Named Row Formats allow you to quickly display all rows that conform to a specific presentation style. When used in conjunction with Filters, Named Row Formats easily highlight records that meet certain rules.

Version 9.0B | 2010-02-22 (Feb. 22, 10)

9.0B release notes

• New functions =RecordContains(value[,range/case]) and =ViewContains(value[,range/case]) have been added to easily locate records in the database containing particular data. RecordContains() searches all fields of the same data type for a match, while ViewContains() searches only those data elements referenced in the particular View for a match. For string values, the search can be either case sensitive or insensitive. For other data types (numbers or dates) an ending range can be supplied and all records falling within the range will be selected.
  
  
• Security has been significantly improved. Users without permission to create or change Views will only be able to open Views contained in a specific directory specified on the command line. If the Workspace is launched from within an Adagio module, the user is not able to open any other Views or Workspaces. If the user can create or change Views, then the "/f:folder" command line parameter provides a default location to load and save Views from/to.
  
  
• Table element names can now be sorted into alphabetical order to assist in locating specific fields.
  
  
• GridView-RW now allows records to be added (inserted) and multiply deleted from a database.
  
  
• Performance has been significantly improved.
  
  
• The list of recently reported on databases is now stored by user.

Version 9.0A | 2008-11-06 (Nov. 6, 08)

9.0A release notes

• Supports Adagio GridView-RW (a separate add-on product for GridView that allows you to write to Adagio data from GridView).
  
  
• Excel Direct Views allow you to automate sending GridView views to Excel. For example, a batch file could be run after normal office hours to generate a view result and send it to a spreadsheet for use the next business day.
  
  
• Select Table now shows only the dictionaries and versions matching your data, simplifying selection of the required table.
  
  
• Existing views can be updated to use the new tables when you upgrade to new versions of Adagio modules.

Version 8.1A | 2007-10-08 (Oct. 8, 07)

8.1A release notes

• Compatible with Windows Vista and Adagio Lanpaks V8.1A. All Adagio modules are now signed with a Verisign digital certificate, and Help files are now "CHM" format and installed on the local workstation. Alt-tab displays the Adagio screen, rather than the Adagio module Icon when switching between tasks under Vista.
  
  
• New functions, header/footer codes, and regional formatting options have been added.
  
  
• Named sequences can be defined and attached to specific filters, allowing the selection of a filter to automatically present the rows in a different sequence.
  
  
• Links can be "joined" to another View, to permit selecting records within a previously selected View. For example, link a customer list to sales records from SalesAnalysis. Click on a customer to see all purchases by that customer. Link an item list to the same SalesAnalysis View, and "Join" the link. Clicking on an item will now show only the purchases of that item by the previously selected customer.
  
  
• Links can be "outer joined" (or negated) to another View, allowing the display of all records that "do not match" the linked fields. Use this feature to show all customers that have not bought a specific item.
  
  
• File | Open now remembers that most recently opened modules and tables. If you frequently create Views into a few specific files, this will make locating the correct module and table simpler and quicker.
  
  
• Adagio GridView Server is now supported. To speed up your data inquiries, GridView Server software processes the GridView Filters right on the server where your data resides, so that only the resulting record set, not the full database, is transmitted over the local area network.
  
  
• Hints have been added to make your work easier. They pop up when the mouse cursor hovers over column titles. The field name and link are shown for data fields; formula text appears for calculated columns.
  
  
• Multiple, named filters allow a single View into a file to easily present different information to a user. Select customers over their credit limit, or who haven't paid an invoice for over 30 days. Just click on a dropdown listing all your filters to select different records for a View.
  
  
• Scan all open batches in a single View. Use the DATAFILENAME() function to determine which batch contains the information you are looking for.
  
  
• Import or Export named filters or formulas. Easily create and maintain library of useful formulas and selection rules.
  
  
• Automatically translate coded fields. Turn on this feature to automatically translate internal codes to readable text values.
  
  
• Incorporate fields from related tables using GridView's new "composite table". Composite tables are available for Version 8.0 releases of Adagio.