·       In GridView 9.3B, Linked Views did not return the correct results on second and subsequent queries.

·       In GridView 9.3B, filters with a Sort Sequence but no selection conditions returned an empty result.

·       Saving a view for a very large dataset was very slow in some cases if 'Save without data' was off for the view. Loading the view was also slow. It is now much faster.

·       On very large data sets, GridView failed to complete a summary view if it ran out of memory. This was less likely with the 64-bit version. It now empties the view and displays an out of memory error.

·       Initial loads of linked Views in a Workspace were slower in GridView 9.3B than in GridView 9.3A. This is no longer the case.

·       Added Copy File(s) to the right-click popup menu when Doc Link cell(s) are selected. Select Paste to copy the DocStore PDF documents selected into an email or Folder.

·       Drag-and-drop a View (.gv file) into an existing Workspace you are building, and GridView will automatically add it to the Views that make up the Workspace in the Folder. If there are no Views currently open, then the drop of the View onto the GridView desktop will set the “Save to….” Folder to the source Folder of the View to help you build a new Workspace there.

·       Added function UTC2LOCALSTRING to convert UTC to local time and date, with detailed control of the format of the local time and date returned. This function is useful for views reading the Application Log file (SDAPPLOG) where times are in UTC. For example:

For ‘Local Date’ use the formula UTC2LOCALSTRING({Date},{Time},\\\"%Y%m%d\\\")

For ‘Local Time’ use the formula UTC2LOCALSTRING({Date},{Time},\\\"%H:%M:%S:%%Milli\\\")

·       Ctrl+Alt+F to displays the File Properties of the selected View.

·       Added 'Duplicate View' to the right-click popup context menu at the top left of a view. It copies the current view to a newly created view. The keyboard shortcut Ctrl-Alt-V also invokes the copy.

·       On Summary Views, 'Top N', ‘** Other **’ row now correctly displays values based on what the user has selected (eg. Total, Min, Max, Average, Calculation) for each column.

·       Added Text and Date styles buttons to the format button bar. They format a cell, row or column to Text or Date. To have these buttons added to the bar, from the View | Customize menu, on Toolbars tab in the Toolbars list box, select Format in the list box and press the Reset button.

·       The Shift ExcelDirect button now exports the Excel workbook files (.XLSX) to a subfolder \ExcelDirect of the folder containing the workspace.

·       The Create and Edit Shortcut screen now includes the parameter value (/T, /F, /N) on field labels, to further identify the information saved on the Target path.

·       Added ease of use features such as pressing F2 in the 'Sort Sequences' dialog will bring up rename dialog and double-clicking an item in the ‘Format Type’ dialog selects that type and closes dialog (presses OK).

·       Sample Views installed by GridView to \SOFTRAK\GVWIN\Views have been updated for and work with data for current versions of the Adagio modules.

Problems Fixed

·       Exporting to CSV using the /XCSV parameter was placing the CSV file in the data folder instead of the XDViews folder.

·       Some Total cells formatting was lost in export to Excel for views with many columns.

·       On very large files, GridView x64 was not reading all the records and ending prematurely without an error message.

·       Insert Related Data now assigns formatting to allow Doc Link hyperlinks to work.

·       Export Documents now exports all documents linked to field in GridView.

·       When using a calculated column, defining the summary type as Calculation, and applying Summarization, the summary value was not calculated correctly in some cases.

·       Added USERID() and USERNAME() functions to return the User information for someone running a View. Added $U (UserId) and $M (User name) parameters to Header/Footer codes for use when a View is printed, or sent to Excel.

·       Most Recently Used lists for Views and Workspaces are now saved with the data, rather than in the registry. Longer filenames are now more likely to display properly for these menu choices.

·       Column Titles can now be formatted independently of the column contents. Add Title Format and Clear Title Format have been added to the context (right mouse button) menu on the column title.

·       You can now specify a Summary Filter when automatically exporting a View using /XDViews command line parameter.

·       Conversion of Views has been improved. Conversion attempts to use partial field matching to identify fields are the same when the field names have changed in tables.

·    Views that are "Tied" to a specific database can now be modified when logged in as SYS so that network Views can be maintained when running on a laptop version of the data.

·    CSV and TXT files can be loaded and parsed in GridView. A structured CSV file with a defined header row can pass data element type information to GridView to correctly format the columns. See the F1-Help text for details.

·    Tool tips have been added to display calculation dependencies, Filter and Row Format definitions. Many dialogs have been made sizeable.

·    Allows NULLs to be sent to external database. Option setting is in View | Customize | General.

·    When exporting a View with ODBC compliant column names (/XDO /XDN on the command line), empty cells will send 0 if the column is numeric unless NULLS are forced in the View | Customize | General tab.

·    When a cell is hyperlinked to a PDF document, the Adagio PDF Viewer is called to display the PDF instead of the workstation default PDF Viewer.

·    Default column widths will be more accurate. Calculated Columns, Row Formats and Sort Sequences are now sorted for selection. Field name matching when replacing one table with another has been improved. Refreshing of multiple Views in an ordered Workspace has been improved. The default Table Style to be used by Excel can be set on the Defaults | General tab.

·    "Enable auto trim" on the Defaults | Views tab automatically wraps a right justified field in the TRIM() function to strip leading blanks. This makes string comparisons more natural when the fields are used in formulas.

·    The sample views installed in \Softrak\GVWIN\Views have been updated to use the currently shipping 9.2A dictionaries.

·    Added System Info tab to Help | About.

·    This release is Adagio Cloud ready.

New FUNCTIONs

GETPDFITEM(CVCode, DocPrefix, DocType, Docnum)

Returns the full path of an ePrint saved document if it exists in the \SoftPDF Folder. The arguments are text fields containing:

-       The Customer or Vendor Code (6 characters)

-       The Application Prefix that generated the PDF (AR, IN, OE or TB).

-       The Document Type (I=Invoice, C=Credit Note)

-       The Document number

DAYOFYEAR([Date])

Returns the Julian day number of the date. Uses TODAY() if no date is provided. The date provided must be later than December 31, 1979.

ISOWEEKNUM(Date)

Returns the ISO week number in the year – the week with the year's first Thursday in it. Monday is the first day of the week.

Julian day number of the date. Uses TODAY() if no date is provided.

WEEKNUM(Date[,return type])

Returns the week number in the year, counted according to the value in [return type]. If [return type] is not specified, 1 is used. January 1 is always week 1, except when [Return type] is 21 (ISO), in which case week 1 may begin on another day of the week. [Return type] controls how weeks are counted:

  1        Week runs from Sunday to Saturday

  2        Week runs from Monday to Sunday

 11        Week runs from Monday to Sunday

 12        Week runs from Tuesday to Monday

 13        Week runs from Wednesday to Tuesday

 14        Week runs from Thursday to Wednesday

 15        Week runs from Friday to Thursday

 16        Week runs from Saturday to Friday

 17        Week runs from Sunday to Saturday

 21        Use ISO week numbering 

All other values return Error! 

Problems Fixed

·    When a View is saved Summarized, the state is now saved for the next time the View is loaded.

·    Syntax checking has been relaxed for Calculated Columns and Filters that return "!Error" during definition.

·    Trailing spaces are trimmed from the Worksheet name when a Workspace is sent to Excel.

·    View and Workspace most recently accessed lists under the File menu are now saved by user, by company.

·    Workspaces and Views are now auto-saved while they are being edited so that they may be recovered in the event of a program crash.

·    File | Shortcut | Create and File | Shortcut | Edit menu choices have been added to facilitate the creation of GridView program shortcuts that open workspaces or send them to Excel using the “/XD” program parameters. These choices are especially useful when creating a series of GridView operations as part of an overnight automated process.

·    Sorting a numeric or date column now displays the results descending first, then ascending. Text columns are sorted ascending first, then descending.

·    Column Titles can now include formulas to allow them to change dynamically. Formulas cannot refer to database fields but may include include dates. (So, for example, this might be used to specify date ranges).

·    Column hints (displayed when the cursor is over the column title), now display which other columns reference a calculation and which other columns a calculation uses.

·    Minimized Views cannot be restored when a workspace is loaded without “/c” on the command line. This lets confidential information be referenced in a Workspace without being viewable.

·    New codes have been added to allow printing View information in the header/footer of a report. These codes are:

§  $T{format string}     Prints the Run Date formatted according to the format string at the time the View was printed.

§  $Q{Column name}   Prints the contents of the first row of the named column. This allows you to include View values in the header/footer.

The following table summarizes the codes that may be used in a View header/footer:

·     

·    Subtotals are now inserted when Views are formatted as reports with a sort sequence. The fields used in the sort sequence will result in subtotals being generated when the contents of the field changes.

·    A new option allows you to have the repeating values in a printed View suppressed on all rows but the first and total row.  The workspace CustomersAndTransactions.gvs in the sample data demonstrates this new feature and the new Header and Footer codes available in this release.

·    Filters can use the ROW() function to test the number of records that have been selected.

·    GridView Views can now be the data source for other Views, in the same way an Excel workbook can act as a data source. This allows multi-pass processing of your data, or regular summarization to speed processing.

·    Constraint violation checking has been enabled. Constraints are specified in calculated columns, after the calculated expression by appending a semicolon and the Constraint expression. “#” refers to the preceding formula. For example, if the calculated column contains:

      {Balance Outstanding};# < {Credit Limit}

and the {Balance Outstanding} is greater than the {Credit Limit}, then the Cell will be formatted according to the “Constraint Violation” Style (under Format | Styles). This allows you to format a single cell in the View (rather than the whole row). However, there are limitations:

§  Only a single Constraint Violation Style is available.

§  The Constraint Violation Style is not stored with the View, but rather on the Workstation, so it must always be the same Style in different Views.

§  “Calculate after refresh” must be selected on the calculated column.

·    Added command line parameter “/O” to allow generation of a sample COM script for external processing. If “/O” is specified on the command line, then right mouse clicking on a Filter name in the Edit Filter dialog results in a context menu that allows generation of a COM scripting example. The file \Softrak\GVWin\GV_ComDoc.zip is installed with GridView with examples of using the COM functionality in GridView.

·    Added command line parameter “/XM [A | M | R]:<DSN Name>” to allow automatic export of a workspace or view to <DSN Name>. Options are A - Add to database, M - Modify existing table, R - Replace existing table.

·    No Page Break” option added to Report Format Filters

·    Custom colors can be selected for Styles and Formats

·    The Filter Toolbox (Alt-F6) buttons have been rearranged for ease of access and are enabled/disabled depending on what Filters have been selected.

·    The Defaults Dialog (F2) has been expanded to allow specification of all default values and to make clear which defaults apply to a Workspace and which to a View.

·    You can now choose a Summary Filter in a Linked View.

·    Compatible with Adagio Console and respects requests to shut down.

·    Includes 64-bit version.

New FUNCTIONs

SYSDATE()

·    returns the system date/time, not influenced by the Run Date.

FYEAR(date)

·    Returns the Fiscal Year for a given date

FPD(date)

·    Returns the period as a string (e.g. “ 2”) in which a date falls

FPERIOD(date)

·    Returns FYEAR & FPD (“2013- 2”) in which a date falls. This is useful when working with transactions in Ledger, or trying to create fiscal calendar summaries.

ISERROR(x)

·    Returns TRUE if the result of "x" is an error, otherwise FALSE.

ISNUMBER(x)

·    Returns TRUE if the result of "x" is an number, otherwise FALSE.

ISSTRING(x)

·    Returns TRUE if the result of "x" is a string, otherwise FALSE.

FOLDER()

·    Returns the path to the data space.

FILEEXTENSION()

·    Returns the extension of the data in the View.

QUERYDATE("Run date?")

·    Sets the run date for the Workspace. (The prompt must be exactly “Run date?”.)

ROW(optional range)

·    Returns the index of the current row or the first row if a range is specified.

COL(optional range)

·    Returns the index (base 0) of the column of the formula.

COLUMN("title")

·    Returns the column number of the column with the specified title. Use this in RANGEREF() calls to keep them running properly when columns get moved around.

CELLREF(Column,Row)

·    Returns the contents of a Cell. Column zero based, Row is 1 base

·    Example: CELLREF(2,ROW()) will return the value from the current Row and the “third” column, more useful when Calculate after refresh is checked.

RANGEREF(c0, r0, c1, r1)

·    Returns a reference to a range of cells from column0, row0 to column1, row1. This would be used as an argument to the SUM() function to total a range of cells to another cell.

APPLYMASK(mask, string)

·    Applies a mask to a string (like Crystal Reports for Adagio). Masks use lowercase “l” as a placeholder with all other characters being insertion characters. “<” and “>” may delimit the string and will not be inserted if they are at the beginning / end of the mask respectively. Mask may be a literal string or the contents of a database field or formula.

·    APPLYMASK() is useful to format phone numbers or item numbers:

TABLEFIND(text, CaseFlag, [ReturnItem,] "View", "Column" [, "Column2…"])

·    This new function allows you to lookup a value from another table with an arbitrary number of rows. The sample workspace TABLEFIND.gvs uses the TABLEFIND() function to locate all transactions in the GL where the staff member’s name is in the description. The parameters are:

·     

·     

·    Returns

·    0 if the string is not found, otherwise an integer value of the row the element was located in. If more than one column is specified, then the value returned is the column index times number of rows + row number

·    For example:

MATCH(value, array, [Type])

·    Used to lookup values in a table where the values being inspected are approximate. For example, you need to find the commission payable on a dollar value of sales, and the commission levels "step" between discrete values.

·    Value - The value that you want to match in Array. For example, when you look up a book in the library, you are using the name of the book or author as the lookup value, but the “location” is the value you want.

·    The Value argument can be a value (number, text, or logical value) or a cell reference to a number, text, or logical value.

·    Array - The range of cells being searched.

·    Type - Optional. Number -1, 0, or 1. The Type argument specifies how the Value is matched with values in Array. The default for this argument is 1.

·    Returns is dependent on the type specified.

·    1 or omitted - Returns the largest value that is less than or equal to Value. The values in the Array argument must be placed in ascending order, for example: ...-2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE

·    0 – Returns the first value that is exactly equal to Value. The values in the Array argument can be in any order.

·    -1 – Returns the smallest value that is greater than or equal to Value. The values in the Array argument must be placed in descending order, for example: TRUE, FALSE, Z-A, ...2, 1, 0, -1, -2, ..., and so on.

FILTERNAME([type])

·    Takes an optional numeric parameter for use with Summary Filters

§  FILTERNAME(1) returns the name of the detail record Filter

§  FILTERNAME(2) returns the name of the Summary Filter

Problems Fixed

·    Row formatting works more reliably in Summary Filters

·    Column formats are more reliably saved.

·    Calculated columns cannot be deleted while they are used in other calculations, Filters, Row Formats or Sort Sequences. Column hints (displayed when the cursor is over the column title), now display which other columns reference a calculation and which other columns a calculation uses to assist in determining where a calculation is used.

·    Excel workbooks referenced in a View were not released until GridView was closed. They are now released when all Views are closed.

·    Tiling Windows now properly positions Views when a toolbar is docked at the side of the desktop

·    ExcelDirect now always names the target sheet.

·    ExcelDirect now correctly formats columns containing percent values.

·    ExcelDirect now formats columns containing character data as text columns to preserve the presentation of gl account and phone numbers (for example).

·    Error messages are clearer when a View into a composite table fails to open due to missing secondary files.

·    The “Display total” option is now suppressed when a column is formatted as a percent

·    You can now press Escape to cancel the initial load of a View when “Refresh on open” is enabled.

·    Summary Filters would revert to the default column for Top/Bottom N selection if the Filter was edited.

·    GridView now remembers the Folder most recently used when a View is saved.

·    Row formatting is now applied even if the View load is cancelled by pressing Escape.

·    If AutoRefresh or Refresh on Open was enabled for a View using one of the QUERYxxx() functions, the user would be prompted for values twice.

·    Workspace window positions are now saved for Filter Toolbox, Row View, and User Notes.

·    Clicking the “Most recently accessed” list on the Login Dialog no longer results in an error when there are no entries in the list.

Enhancements and revisions in Adagio GridView 9.1A (2013.04.02)

New Features

   Added ability to show a subtotal and page break on change of the first level sort sequence for Filters with a Sort Sequence. Click the new 'Format Report' option on the Filters dialog when a Sort Sequence has been applied. The page break is indicated by a red line on the row number. 'Set Page Break' and 'Clear Page Break' have been added to right mouse context menu.

   When on any cell in a row, use CTRL+B to toggle a page break on or off. The page break is indicated by a red line on the row number.

   Added the option 'Suppress Other' to Summary Filters when using Top/Bottom "n" so that the **Other** row is not displayed.

   Columns may now be formatted to contain hyperlinks to any document with an associated program in Windows, such as PDFs, Word documents or JPG image files (9.0F added hyperlinks but only to web URLs or email addresses). Use 'Make Hyperlink / Remove Hyperlink' from the column context menu and format the column as text. The cell must contain a filename with full path. Backslash characters must be replaced with forward slashes. For example, 'C:/SOFTRAK/DATA/ICBKHUNI001.jpg' to display the image associated with the 'Women's Via Montega hybrid' item in the Inventory sample data. Note that the Image File field on the Image tab in the item cannot be used directly as the path has backslashes. Therefore a formula must be used: STRCAT("C:/SOFTRAK/DATA/", "IC", trim({Item #}), ".jpg"). Click in the cell and the PDF is opened with default PDF viewer.

   Added function FULLFILENAME for use with hyperlinks. Use instead of STRCAT to form the path when a “\” is required. For example: FULLFILENAME("x:\Softrak\Data\SoftPDF\", {Cust #}, "_OE_I____", TRIM ({Doc #}",".PDF").

   Excel Direct now transfers hyperlinks to the Excel sheet.

   Added function FILEEXISTS(S). Use to test for the existence of a file. This is useful when used with hyperlinks to document files. Note: backslashes in the path must be replaced with forward slashes.

   Excel Direct now sends Page Scaling and Page Breaks to the sheet and handles $D in Header/Footer.

   Additional Print Setup and Page Setup options (ex. landscape, grid lines, centre on page) in the view are now sent to the Excel sheet by Excel Direct.

   In the File Properties dialog (right-click top left cell), wildcard characters (??? or +++) in the Name are replaced with the actual characters for single files. For example "GLPST" is now shown instead of "GL???" for the G/L Posted Transactions file.

   Added function DATESTART (”Spec Code” [,”C”|”F”]). It returns the start of period date based on the Financial Reporter spec code and the session date used to log into GridView, for either the Calendar or Fiscal year.

   Added function DATEEND (”Spec Code” [,”C”|”F”]). It returns the end of period date based on the Financial Reporter spec code and the session date used to log into GridView.

   Added function DATEIN ({Date},”Ledger Spec Code” [,”C”|”F”]). Used to test for the existence of the date stored in the Date calculated column within the range defined by the STARTDATE and ENDDATE calculated columns. Returns 1 if the date exists within the range. Alternate use of function is DATEIN ({Date}, {Start Date}, {End Date}). Returns 1 if Date falls in the specified date range.

   Added function INCLUDEAMOUNT ({Number}, {Date}, ”Ledger Spec Code” [,”C”|”F”]). Used to test for the existence of the date stored in the Date calculated column within the range defined which is based on the session date. Returns the value of {Number} if the date exists within the range otherwise 0. Alternate use of function is INCLUDEAMOUNT ({Number}, {Date}, {Start Date}, {End Date}). Returns {Number} if the date falls in the specified range, 0 otherwise.

   Added 'Tile In Place' to the Window menu. It proportionally tiles views in a workspace as long as they are close to what you want and are not overlapped. This is useful when opening a workspace originally saved on a machine with a different size monitor. The shortcut for 'Tile In Place' is Ctrl-T (which in previous versions was used for 'Tile Horizontal').

   Added control resizing for the entire workspace. Click the Ctrl button and size the GridView window. The views in the workspace will be sized proportionally. If you press ESCAPE before releasing the mouse button the change will be discarded.

   Added File | Export to | XML Data Only... (i.e. without formatting of any sort).

   Added new command line parameter for use with XDViews:

/XDN - Exports view without formatting and any hyperlinks.
/XDS - Runs XDViews in 'silent' mode (no user interface displayed for GV or Excel).
/XDO:<workspace> - Exports column names using ODBC compliant fieldnames (no spaces or special characters).

   The column title now respects the Horizontal alignment setting (left, center, right) in Add Formatting, Align tab. In previous versions only the data in the column respected the setting.

   Added option 'Lock Toolbars" to View | Customize | Toolbars. Prevents the toolbar from being moved or modified.

   Help | Active Users now shows the date and time users logged into Adagio if you are logged in as SYS (and not running in RW mode, if GridView-RW is installed). You can sort the grid by any column.

   The Gather Files for Support function now includes the ADSPROF.xxx file and external files (xls?, dbf, dsn, udl) if used. It now retains the original date and time of the files.

   Added "Registered to: <Company Name>" to the status line.

   New splash screen with an updated look.

   In earlier releases of Adagio we added the ability for Excel Direct to create a CSV file for use by other spreadsheet applications, such as Apache OpenOffice^TM Calc, at sites that did not have Excel installed. The spreadsheet program was launched and opened the CSV file created. Excel Direct can now use Windows "automation" (inter-process communication) to send data to other spreadsheet applications, the same way it interfaces to Excel, allowing all formatting to be retained in the resulting sheet. OpenOffice 3.3 or later and LibreOffice® 3.3 or later are supported. This interface must be manually enabled. The file SSI2XL.INI must exist in \softrak\system and must contain the section [Initialization] with an entry <computer name>-UseOpenOffice=1, where <computer name> is the name of the machine that this entry references. Refer to the Readme Help for further details.

Problems Fixed

   There was a problem in GridView 9.0F when a view having multiple sort columns was summarized. The column being summarized was not reported properly.

   The BEGINWEEK() function reported the wrong date when the week began in the previous month, depending on the system date and session date used.

   If you clicked the 'x' in the window title bar to exit a view, then responded Cancel to the prompt asking if you want to save the data, then refreshed the view, the error message "The ADS function: <table> returned unexpected error number 2111." was displayed.

   Corrected problem where the wrong result was returned from GETFIELDVALUE when referencing an Excel sheet.

   You are now prevented from deleting a Calculated Column that is used by another Calculated Column, which caused the program to crash in previous versions.

   Field Properties now recognizes fields of Type PERCENT.

   Installs an updated version of the Adagio Data Source (ADS) that corrects the OpLocks Setting shown in station log files <computer name>.log in \Softrak\System\StationLogs. It was reported as Enabled instead of Disabled in some cases.

Enhancements and revisions in Adagio GridView 9.0F (2012.09.25)

New Features

   GridView will now read Excel workbooks that are in the Adagio data folder. The new option 'Include External Tables' on the Defaults dialog must be selected. The Select Module dialog will then include all Excel workbook files (*.xlsx or .xls) found in the data folder. Choose your workbook, then choose the sheet from the Select Table dialog and continue with GridView as usual. Use this powerful feature instead of Named Items. Note: GridView must open each sheet in the workbook to get the Column Names and it may take a significant amount of time before the Select Table dialog is displayed for very large workbooks.

   GridView can now access any database for which a Data Source Name (DSN) or Universal Data Link (UDL) has been defined. This allows you to create Views and Workspaces that include data from other sources. The new option 'Include External Tables' on the Defaults dialog must be selected. The DSN file or UDL has to be in the same folder as the Adagio data, although the database it connects to does not. The DSN must be a "File DSN". Note: Softrak Technical Support cannot help define the DSN / UDL, provide any assistance locating tables / fields, or troubleshoot connections to other databases.

   GridView specifically supports databases from Island Microsystems Ltd. products such as JobTracker™ and CounterSales™ without defining a DSN or UDL. This allows you to create Views and Workspaces including data from these third-party products. The new option 'Include External Tables' on the Defaults dialog must be selected and the Visual FoxPro data files (with .DBF extension) for these products must be in the same folder as the Adagio data. To access the DBF files select 'Island Micro Data' from the Select Module dialogue, then select a table from the list presented.

   You can now edit the “Link Name” on the Field Properties dialog. Edit the Link Name and then use the “Insert Related Column" capability of GridView rather than using GETLINKEDVALUE or building the formula manually. Note: The DataDictExporter will come in handy for determining the correct Link Name. Note2: This works for Island Micro data linked to Adagio data, but for Adagio to Island Micro you will need to define a View and use GETLINKEDVALUE.

   Added a Sample Values list to the Field Properties dialog. The list shows the first 5 unique values found in the first 50 records in the file. This helps you find the field you are looking for. For "typed" fields, this list is shown in addition to the Lookup Table list.

   A View can now be “Locked” by setting the 'Lock View' option on the Edit Definition dialog. A locked View will not try and reload its data contents when the user presses the Refresh button or F5/F9. This allows a View to be loaded with specific data and used in another workspace. Generally, locked Views would be used to hold data from another dataset. A locked View can be explicitly refreshed only by unlocking the View, or by executing GridView with the new “/XLU” command line parameter, which will open the locked View, refresh it and save it. Only a user with /c permission can unlock a locked View. If this option is set, "Locked" is displayed in the Tooltip for when hovering over the top left corner cell.

   A View can now be “Tied” to a specific set of data (folder / extension) by setting the 'Tied to this database' option on the Edit Definition dialog. A tied View will always load its data from that folder. This allows a workspace to reference data stored in different folders, or with different extensions, for example for different companies. Normally all views in a workspace reference the same set of data. If this option is set, "Tied to" and the path is displayed in the Tooltip for when hovering over the top left corner cell. Note: a Lanpak is consumed when a “Tied” View is refreshed and you are not working in the database to which the View is tied.

   When defining Calculated Columns or Filters in a Workspace, a new “External References” list may appear in the left hand pane. Under the External References, you will see all the Views in the Workspace that share an element in common with the View you are working on. If you want an element from one of the other Views in the Workspace, locate it in the External references section. Clicking on the element will insert the necessary GETLINKEDVALUE() formula into the Computed column or Filter you are working with.

   When building a calculated column, the list of other calculated columns available for use has been expanded to include columns that are not themselves using a calculated column. This will remove many of the ordering dependencies in complex Views.

   Added the option 'Calculate after refresh' to the Edit Calculated Column dialog. Use this option to insert the actual formula into the cell, allowing it to calculate and display results after the processing is complete. For example, this can be useful in summarized views wherein you want the displayed result of the calculation to be based on the summarized view.

   Rules regarding the calculation order of Views in a Workspace are better defined. The Workspace order set in File | Set Recalc Order defines the order in which the Views will be loaded. If a View has Refresh on Open enabled, and the Workspace order requires refreshing subsequent Views, then they will be refreshed regardless of their Refresh on Open setting. Views not in the recalculation order will only be refreshed if they have Refresh on Open enabled.

   GridView is now smarter about whether the data file needs to be re-read in order to display the information in a different Filter. Two Filters with different names, that select the same set of records, will not bother re-reading the data file, but will simply re-summarize and sort the data. This will improve performance of Views when changing between equivalent Filters. Selecting a different Filter that uses the same selection formula as the previous Filter will simply re-sort and summarize the loaded records. This will greatly improve the speed in some cases. Make use of this to present the same data sorted and summarized by Salesperson, Customer or Territory. Ctrl-F9 will force a filter to refresh.

   The 'Disable Refresh' button has been added to the Toolbar. It stops GridView from reading the underlying data file automatically. Click the refresh button, or press F5/F9 to force a read of the database. This is useful as you are building a complex View of a large file, and you want to create several calculated columns and/or Filters before reading the entire file again. Note: you need to select View | Customize from the menu, then select each of the Toolbars options and click Reset in order to make the new button visible.

   The 'View Notes' button has been added to the Toolbar. It displays or hides the Notes stored with a View. This button will be disabled if there are no Notes to display. Note: you need to select View | Customize from the menu, then select each of the Toolbars options and click Reset in order to make the new button visible.

   If a View is saved with the Notes visible, the Notes will still be visible when the View is loaded again.

   Added function REMOVEALL(“S1”,”s2”). It removes all occurrences of string S1 from String S2.

   Added function REMOVEDUP(“S1,”S2”). It removes duplicate occurrences of S1 from S2. Useful for removing multiple blanks from a string.

   Added function COUNTSTR(“S1”,”S2”[,N]). It returns the count of the occurrences of string S1 in string S2. Matching is case sensitive if “N” is TRUE. 0 is returned if the string is not found.

   Added function COLUMNCONTAINS("S1", "S2"[, N]). It returns the count of the occurrences of string S1 in string S2. Note: S1 takes "Column Name" not {Column Name}. Matching of S2 is case sensitive if “N” is TRUE. 0 is returned if the string is not found

   New menu choice 'Top/Bottom N' has been added to the context menu for Date columns, allowing you to select the newest or oldest “N” records, depending on whether the column is sorted Ascending or Descending.

   Columns may now be formatted to contain hyperlinks (to web URLs or email addresses). This allows you to click directly to e-mail or the web from a View. Make Hyperlink / Remove Hyperlink have been added to the column context menu. Place the hyperlink in <angle brackets>. Text containing an “@” will hyperlink as an e-mail address. All others will be assumed to be URLs.

   'Size To Fit' has been added to the right-mouse context menu for columns.

   You can use the code $T to place the Run date (session date) in the Header or Footer of a View printout.

   When importing calculations for Filters or Calculated Columns, identical text from other columns will be replaced with a reference to the column. This improves the import functionality significantly.

   Added a Duplicate button to the Row Formats and Calculated Columns dialogs.

   Station Logs now indicate memory information for the station or Remote Desktop Services session in these variables:

Total Memory       - total Mbytes of physical memory
Available Memory- free Mbytes of physical memory
Memory Load       - percent of memory in use.

   Station Logs now show the bitness of the application and the station OS in the variable "Environment".

Problems Fixed

   The table 'Adagio Common Files 8.1A-9.0D' was not available to select unless the option 'Show All Tables' was set.

   Format / Cells changes were lost when the view was refreshed or saved in GridView 9.0E.

   When running Adagio on a network, if you launched GridView from the Adagio menu of an Adagio module, the help files (files with .chm extension) for the module were copied to the local c:\softrak\gvwin folder. Only the help files for GridView should have been copied.

   After a Summary Filter was run and then toggled off, columns that were previously hidden in the original view reappeared in the original view.

   When a Summary Filter was run on a View having ‘Blank when zero’ enabled in its definition, the setting was not maintained in the Summary Filter view (i.e. the zeroes reappeared).

Enhancements and revisions in Adagio GridView 9.0E (2012.07.03)

   The performance of refreshing views with a large number of columns on larger databases across a network in 9.0E (2012.04.26) was slow (during which time the status line showed "Storing cells...").

   In 9.0E (2012.04.26), you received the error "Out of memory" or GridView froze in some cases on very large views.

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.