Matthew Fifield -

Release Date: 12/4/2017 


Bug Fixes

  • Fixed an issue when connected to a FACS database, the Field descriptions would not display if Favorites were enabled.
  • Fixed an issue where the user was not prompted to save changes made to a view before viewing a table's schema.
  • Fixed an issue with a TMP.TXT file lock when multiple Auto Scheduler jobs ran at the same time.
  • Fixed an issue where changing an Expression's Data Type at the grid level would not update the view if Embedded Expressions was enabled.
  • Fixed an Unhandled Exception that was caused if a table was removed from the linking and the table was the middle of a "daisy chain" link.  This would then not allow any links to be removed/added.
  • Fixed an issue where "Show Query" would clear the grid format and not reapply it.
  • Fixed an issue where if a new view was built without being saved or searched, clicking Finished Reports/Finished Reports Designer would reset the view.
  • Fixed an issue where "View Schema" for an Access table would not display correctly.
  • Fixed an issue where spaces were not correctly being removed from parameters inside of Finished Reports.
  • Fixed an issue where the FSGS filter statement was not color coded on view open.
  • Fixed a UI bug where the VoV column order list was cutoff at the bottom.
  • Fixed an issue where the "RECENT" file could encounter a file lock if the Auto Scheduler was running many jobs via separate session.
  • Fixed an issue where the "OPTIONS" file could lose it's Company ID if the Auto Scheduler was running many jobs via separate session.


  • Parameters
    • Parameters with Dynamic queries now support Parameters.
    • Parameters may be passed from one page to the next to drive additional Dynamic Queries.
    • Parameters are now saved inside of a View that has been "Saved with Data".
  • Cache Functions
    • A Cache specific function can now be applied directly to a select statement.  Currently %INORDER is available.
  • View Only Licenses
    • The UI has been adjusted to no longer show items that are disabled.
    • The Auto Scheduler/Master Job is now available to View Only licenses.
  • View Encryption
    • Views can now be Encrypted to only be opened by a specific Company ID (provided at Encryption).
    • Encrypted views cannot be modified or saved.
  • Grouping Options
    • Quarterly is now an available grouping option.
    • Quarter/Year is now an available grouping option.
  • New Reserved Words
    • @TodayXMonthsAgo
    • @TodayXMonthsOut
    • @TodayXYearsAgo
    • @TodayXYearsOut
  • VoV
    • VoV's are now compiled into one single file.
    • VoV's can be rebuilt from the VoV builder if individual views need to be updated.
Have more questions? Submit a request