Version 6.9.0 (Build 1583, Released on 11/13/07)

Spread Reports

• Added ability to move multiple variables up and down at a time in the Locate Multiple Variables window in Spread Design (1251)
• Added Fit-to-Page check box into Report Pac / Spread Reports. When checked smart printing will attempt to fit the selected report on one printed page (1324)
• GPERC function now supports a new optional parameter called type, and MVSTAT now supports PERAxx. See help for more info. (1033)
• Export to Excel now uses more intelligent color replacement algorithm to match colors of cells in spread report to ones supported by Microsoft Excel (703)
• Users are no longer limited to 300 character size limit for a cell (1297)
• Fixed a bug in Report Pac / Spread Report / Preview / Print that caused run time error 380 (invalid property value) in the rare case when database report definition held unsupported value for report orientation setting (1331)
• Changed the caption of the Cancel button to Done on the variable browser in Locate Multiple Variables / Add variables (1009)
• Fixed a bug that caused the variable browser window to cover up the Locate Multiple Variables window in Spread Design. (861)
• Fixed a bug that caused the variable browser window selection to jump to the last chosen variable when moving selection down the list in the Locate Multiple Variables window in Spread Design. (1257)
• Fixed a bug in Locate Weekly Summary on variables with Not Fixed decimal places (310)
• Fixed a bug in the Wizard that cause error 380 when using variables with Not Fixed decimal places (1250)
• Fixed a bug that caused to Cancel button to not work when inside Import Excel Sheet in Spread Design (1034)
• Fixed a bug that caused inability to change variable numbers once a report was exported to excel (1212)
  Fixed a bug in Spread Report Design / Locate NPDES row that would in certain situations return blank values in cells with limits (1082)
• Fixed a bug that caused the program to freeze up in Format / Conditional Formatting inside Spread Report Design when running on database with very large number of variables (1132)
• VAL function now properly handles ND symbols (1070)
• Fixed a bug in DDVWO, HWO, and DDVTWO functions that caused group offset with optional grouping parameters to return wrong results (1159)
• Fixed a bug that caused the Wizard to crash in Violation Summary Report when no limits were setup for a variable (1166)
• Fixed a bug in the Wizard for the Violation Summary Report which inserted a statistic into the VIOL function without regards to the actual statistic of the limit (1171)
• Spread Reports now account for situations when import from OPS32 incorrectly converted the GRAPHTS formulas using 3 parameters instead of the required 4 parameters. The formula is corrected when report is loaded (1202)
• Fixed a bug in the GRAPHTS formula that returned wrong result if test cells were referenced (1237)
• Fixed a bug in the GRAPHTS formula that caused a graph to be generated even when no values were on the spreadsheet when data was linked to text cells (1302)
• Fixed a bug that caused crash of the Wizard in the Variable Summary Report when the browse button was clicked (1214)
• Fixed a bug in DSORT function that caused omission of date stamp when locating data for partial days (1215)
• Fixed a bug in dashboard which caused SQLFIRST and SQLRESULT functions to return no results (1247)
• Fixed a bug in the Wizard’s Variable Summary report that surfaced as error 381 when users forgot to pick a variable to do a summary of (1254)
• Fixed a bug that caused the GAVG function to return average for the report date range when second parameter of GAVG evaluated to blank. Now returns blank (1274)

Custom Data Entry

• A new user specific setting (Custom Data Entry Auto Save Frequency) was added to System Setup / User Setup. This setting tells the program how often to perform auto saving of data on a Custom Data Entry Form. It is by default disabled. (1120)
• Not Fixed decimal places are now supported in the Wizard (1275)
• Added TOE (time of entry) function. See help for documentation (958)
• Wizard no longer allows users to create forms with no variables (1286)
• Fixed a bug that caused error 424 after using the Browse / Find function in the Wizard (1008)
• COM function now works as documented in help (1062)
• The Calc button now submits calculation for correct data range when data points located on the form span more than 1 day (1067)
• Designer now allows deletion of form that is currently open in the Designer (1068)
• Fixed a bug that caused bold and italicized data (due to limit/entry violations) to not stick when a form was opened back up (1183)
• Fixed a problem where print was done using gray background even when the user answered No to the gray background prompt (1232)
• Fixed a bug that caused comments for 4-hourly variables be duplicated from one time slot to others (1284)

Daily Detail Entry Forms

• Data Approval is now available in Daily Detail Entry Forms (118)
• Text variables now properly show a dropdown list (759) (821)
• Fixed a bug that caused hourly data entry form to attempt to read a non-existing database table column (1096)
• Fixed a security hole that allowed Entry level users to modify data even after it was entered (1097)
• Fixed a bug that caused a text variable with a long list of allowed values to display truncated list (1326)

Variable Setup

• Added a feature into Copy Variable that gives users a dropdown list of choices for variable number such as next available variable number, and last variable number (1312)
• Added support for new Math Toolbox functions GAVG, GGM, GMED, GCC, GCNT, GLST, GMAX, GMIN, GSUM. Click here for documentation (1224)
• Added new limit groupings called MA12  and RMA12 (1123)
• Fixed a bug that caused Limits to not be saved right after creating a new variable in System Setup / Edit/View Variables (1050)
• Fixed a bug that caused deleted Limits to not be saved (1083)
• Fixed a bug in that caused the Test button to return an error on Variable Edit / External Source tab when running against an MS Access data source (658)
• Fixed a bug that caused error -2147217900 (Ambiguous column name ‘DESCRIPTION’) when trying to filter by the description field in the Variable Browser (1197)
• Fixed a bug that caused the WMIN and WMAX to not auto fill description  and grouping in the same fashion as in the other types of limits (1203)

Labcal

• Added ability to set column width and row height in Admin Console / General Settings. These settings will only show up if you are licensed to use Labcal (1200)
• Added ability to see unsigned Samples on the calendar using Filter (1228)
• Changed default mode of data edits from Add-On to Overwrite in Sample Edit / Edit Results (1235)
• Entry into Calculated variables is now disallowed (557)
• Ditto key (F3) now works correctly when entering results with Data Approval status (1266)
• Fixed a bug that caused a Null-pointer error when assigned a sample to a person before the sample date was checked (1157)
• Fixed a bug that reported an Ambiguous column error when a filter by name or sample type was applied in the Overdue Samples Browser (1196)
• Fixed a bug in Receive Samples that caused multi-select to not work (1210)
• Fixed a bug that caused crash when in Sample Setup / Browse /Filter by Description (1226)
• Fixed a bug that caused change to not be saved when users changed Sample Type of a sample (1234)
• Fixed a bug that caused Sample Editor to clear the location field when the combo box was clicked (1313)

Logbooks

• Added the ability to search for all comments within a specified date range. Use * for search key word (1111)
• Delete comment now supports selecting comments to be deleted by clicking on any field of the comment (1117)

Misc

• Added a way to quickly switch facilities by using File / Open Facility. This menu item now displays all facility databases that the currently logged in user has access to. The login screen no longer requires users to re-type their username and password (1128)
• Added Open Facility Via Logon menu item under menu which performs the same function as did the old style of switching facilities (1323)
• Load-balancing Admin Console has been improved to use API calls instead of shell calls to SC.Exe (1047)
• Added START ALL NODES and STOP ALL NODES buttons to Load-balancing Admin Console (1280)
• Load-balancing Admin Console no longer allows users to check / uncheck the Enabled box for worker nodes. The enabled field is monitored (and essentially modified) only by the dispatcher and it represents the real-time status of the load-balancing system. (1147)
• System Setup / System Tables / Lookup table setup now allows users to size the column width by right-clicking on a cell (937)
• Utilities / Export to Excel now properly remembers the export folder and asks whether to overwrite a file if it already exists (982)
• PocketOPS synchronization now omits all calculated variables that exist in routes (1016)
• System Setup / Scheduled Tasks now does not allow to save an email task without providing an email address (1018)
• Login screen sports an improved look when using wrong display drivers on 16:9 displays (1065)
• Entry Group Manager now omits listing of Entry-Only types of users from the list since these users cannot use entry groups anyway (1115)
• Report Pac / Variable List report now uses memory efficient variable picker instead of pull down box (1116)
• Admin Console / Action Scripts / Backup databases now properly warns users that scripts are not supported in Professional and Enterprise editions of OPS SQL. (1133)
• Admin Console / Action Scripts / View Audit of Deleted Variables was added and can be used to keep track of when and who deleted variables (1190)
• Added support for setting AUDITUSER_USE_NODEID in Admin Console / Calculation settings that tells load balanced calc engine worker nodes to uniquely identify themselves in all audit trail transactions they generate (1271)
• Added ability to check status of support subscription against OPS Systems online database. Go to Help/Support/ License Support Status, or to Utilities/System Information/License (1346)
• Added an OPSSQL.ini switch called KILL_SESSION_ON_UPGRADE which allows users to override default behavior during database upgrade. This is to work around an Oracle bug that was encountered when Oracle RDB was used as backend. See Q10578 for more info. (1255)
• Added ability to custom label windows spawned by OPS SQL. See new setting in Admin Console / General setting called Application Title Bar Display Setting (1129)
  Added a warning into Express and Lite editions that warns users when their facility database size reached 90 % of the allowed limit. This warning occurs at around 1.8 GB  (1207)
• Added new menu item that links to Support Area Web Site under Help / Support (1339)
• Added HOLDVALUE data generator plugin (opssql_plugin_7.exe) that generates flag values in real time for use with HOLDVALUE math toolbox function (1350)
• BOD Manager no longer allows you to add the same sample more than once into a BOD worksheet (516)
• Load and Save works properly in Report Pac / QC Analysis Report (1158)
• The facility database size of Express and Lite editions was misreported as a sum of DATA + LOG files. Since the 2 GB size limitation is on the DATA file, this was corrected to only show the size of the DATA file.  (1205)
• Fixed a bug in System Setup / System Tables / Lookup table setup that caused error (row cannot be located for updating) when canceling creation of a record while running on Oracle backend. (1333)
• Fixed a minor bug that caused BOD Manager to store Dilution Blank results incorrectly when storing to an OPS SQL variable (1305)
• Fixed a bug that caused Modeling Pac to initially not load data into reports (1084)
• Fixed a minor bug in the 1.3.1 database upgrade that caused some of the WMAX limits to be populated with incorrect description (1165)
• Fixed a bug Dashboard navigation that cause the navigation buttons to display in two rows. They now only span one row, no matter what size of Windows Fonts is used (1001)
• Fixed a bug that caused Error 3704  in Variable Browser when numbers were used for Areas and there happened to be a location with the same location id as the area number (1004)
• Fixed a bug that occurred in Monthly Data Entry / Custom Data Entry / Daily Detail Data Entry Forms and caused the forced value to remain in the database until the next re-calculation occurred (1258)
• Fixed a bug that occurred in Monthly Data Entry / Custom Data Entry / Daily Detail Data Entry Forms when a text variable had a value that was no longer on the list of allowed values, and the value would not show up in data cells of the entry forms. Value now displays correctly (1124)
• Fixed a bug that caused data from 31st day to not be cleared when clearing a highlighted block of data in Monthly Data Entry (1316)
• Fixed a bug that allowed for restoring of values from audit trail into calculated variables in Monthly Data Entry / Custom Data Entry / Daily Detail Data Entry Forms (1259)
• Fixed a bug that caused the Multi Var selection indicator to not show up in the Variable Browser under certain video resolutions (1143)
• Deprecated no longer supported hot standby settings HOTSTANDBY_PING_INTERVAL and HOTSTANDBY_PING_TIMEOUT in Admin Console / Calculation settings (1269) (1270)
• Help file updated.

Version 6.8.2 (Build 1328, Released on 6/19/07)

Monthly Data Entry

• Fixed a bug in List Inputs First Level or All Levels that caused no results on calculated variables with very large variable ID numbers (872)
• Fixed a bug that caused improper highlighting of locked data cells (873)
• Fixed a bug that caused improper highlighting of a column on 1st day of the month (935)
• Fixed a bug that caused entries on the 31st to pop-up the wrong menu options on right click (911)
• Fixed a bug that caused the cursor to default to the day before today (942)
• Fixed a bug that caused the cursor to not jump to the first day of the month when switch months. Now jumps to the first day after switching months (945)
• Fixed a bug that caused the cursor to be moved to column headed when user pushed the PAGE-UP key, or the CTRL+HOME keys (983)

Custom Data Entry

• Paste from the right click menu now works properly (301)
• AINFO formula now works properly in the designer as well as entry forms (987)

Spread Reports

• Fixed a bug in the wizard that caused a lock-up when generating the Violation Report on databases with more than 500 limits (916)
• Fixed a bug that used to caused to load a selected template when user clicked cancel on the New report dialog in the designer (962)
• TABLE function can now return text of more than 50 characters into a cell (963)

Graph Pac

• Fixed an overflow error/program crash that occured when configuring the Pie chart graph type in the 3D gallery in certain situations (966)
• Added a better error message when clicking View in Time Series Graph Input window when no variables have been selected (969)

Labcal

• Fixed a bug that caused sample type to not display properly on the calendar in certain situations (693)
• Fixed a bug that allowed blank Sample Numbers to be generated in certain situation when using Create One Time Sample (971)
• Fixed a bug that caused a Type Mismatch error when a calculated variable was added into a sample (973)

Misc

• Updated internal database cursor locations to clientSide throughout the program. Previous to this version, the program used about 90 % clientSide cursors along with 10% serverSide, but it is now setup to use 100% clientSide. Microsoft SQL Server 2005 Service Pack 2 (and its later hotfix builds) introduced several huge performance bottlenecks when using serverSide cursors with the OLE DB driver technology, therefore this adjustement had to be made (988)
• Added a new setting for OPSSQL.INI called DBUPGRADETIMEOUT (set to 600 seconds if not specified otherwise). Microsoft SQL Server 2005 Service Pack 2 was observed to time out during upgrade of very large databases. This was due to the fact that SP2 understood our timeout settings differently than previous releases of Microsoft SQL Server. This situation is now accounted for. Should there ever be a need, users can set the timeout even higher than 600 seconds (862)
• Fixed a bug in System Setup/Scheduled Tasks/Edit that used to display 'Task id X could not be loaded' (938)
• Users who are not superusers and do not have any facility access rights are now properly handled on by login screen (485)
• Fixed a bug that caused program crash when creating shortcut to Time Series Graphs with Last X Days/Months/Quarters set for dates (715)
• Fixed a bug in User Setup/Copy that caused user settings to be ommited during copy (879)
• MS Sans Serif font was replaced by Arial as default font throughout the program due to the fact that MS Sans Serif does not implement italics for printer devices (884)
• Fixed a bug that caused the "You are not authorized to view this report! Contact your administrator!" message when loading a dashboard for super users in certain situations (923)
• Fixed a bug that broke emaling of PDF's via GNR server (926)
• System Setup/Shortcuts/Create Shortcut now displays a message and disallows operation when user is using a dashboard to avoid confusion about the function of this menu item (974)
• Fixed a bug in System Setup/Shortcuts/Shortcut Manager that caused super users to be listed twice on the list of available users (975)
• Fixed a bug that caused to display misreported message "Request took more than 10 minutes - Aborting" in Data Manager/Calc Data Block. To avoid confusion, this was changed to "Request is not complete at this time, but it is waiting in the queue. Check 'Utilities','Queue Status','AdoCalc Queue' for the queue status" (979)
• Fixed a bug that caused the program to disappear from the screen when loading a large dashboard upon login. A new status message is now displayed saying "Loading your Home Dashboard ..." (981)

Version 6.8.1 (Build 1237, Released on 5/21/07)

Spread Reports

• DRC formula added - Data Repeater Counter function repeats results of an SQL query (defined by SQLFIRST) or date.  "See DRC - Spread function" in help for more information.  This function allows you to design reports that grow based on a run time criterior. (678)
• Added "Dashboard Element" to the "Locate" Menu to allow Spread Design for creating Dashboards. Users can add Shortcut buttons and Gauges to reports, plus icon shortcuts can be converted into dashboard shortcuts using the "User's Icons" dashboard element
• OPS SQL Plugins can now be executed using dashboard shortcuts, and custom parameters can be passed to these plugins. (734)
• Spread Report Wizard now supports "Daily Report" generation. Daily Report Generator was popular in OPS32, but reports are now generated as Spread Reports that utilize the new DRC features (38)
• Quarterly Min/Max limits display properly when locating variable information in a report (468)
• Florida MOR is included as a Template in Spread Report Design and is supported in EDMR output(502)
• GAVG() function will now calculate properly for certain weeks that span a month.  See Spread Functions, Weekly Grouping Examples in help for more information (574)
• CA CIWQS has improved setup and control over the PARLABEL, ANMCODE and BASIS data fields and can be defined by the user (580)
• SQLFIRSTX and SQLRESULTX functions work correctly in Report Pac (606)
• Added option for Weekly Summary in the Locate menu to include partial weeks which span two months (672)
• Conditional Formatting has been updated to work with all data types, including calculated variables (697)
• "Replace All" and "Replace all in Selection" functions were updated to work as expected (731)
• Trigger Report capability added. Works in conjuction with GNR Server. Implements highly configurable triggers that can be setup to warn users when certain events occur. See help for more info. (647)
• DFORMAT and NFORMAT Spread Function Added (338)
• Illinois eDMR functionality added (776)
• Exception List Report recognizes and analyzes Daily Limits as expected (646)
• Locate Group Summary now supports locating data in reverse chronological order (745)
• Export to CSV function added in Report Pac, Spread Reports output (843)

Monthly Data Entry

• Fixed minor data approval bug for all data types, including 4hour, hourly, 30m, 15m, 5m (556)
• Users can now print Monthly Data Entry sheets in color and "Forced" values print in red (581)
• Location and Area can now be optionally displayed at the top of the entry form (631)
• You can now set the Column Header colors in Advanced Settings.

Custom Data Entry

• Custom Data Entry has been updated to refresh data for Custom Forms and TSS Bench Sheets; however, recalulation of data must be done using the Calc Button at the top of the window (719)

Lab Cal

• Calendar now goes back 100 days
• Added browse button and name search capability where selecting people/personel is required (385) (741)
• When closing a sample, the user is now asked if they want to reassign variables if they change the Location of a sample (493)
• Changing a Sample Definition applies the change to all related future Samples (509)
• OPS SQL User Setup can be used to apply default filters for Lab Cal on a per-user basis (770)
• The Location field of a Sample is now visible on the Main calendar view of Lab Cal (538)
• Auto Sense Variables has been improved to find a closer match from the OPS SQL variable list and now works when editing a Sample Definition as it does in Edit/Close Sample (540)(541)
• Adding Tests/Schedule to a Sample Definition can now add up to 150 tests at a time, instead of 25 (548)
• Added Find buttons to assist in locating records when Adding Methods and Adding Tests (619)
• The Copy Sample Definition Function now copies Custom Schedules as well (651)
• The select filter screen does not require a filter to be selected, in case there are none (732)
• Entering results in sample edit form now works correctly. Fixed bug that surfaced under very complex circumstances (771)
• You can now cancel out of the create filter form without actually having to create a new filter. (795)
• Added ability to delete or skip samples (from the past) that have fallen off the calendar (811)
• A default Lab Cal filter can be applied to a user.This allows you to auto apply a filter when Lab Cal is started.  Set each users default filter in User Setup, User Settings. (513) (740)

BOD Manager

• Optional YSI Interface now supported.

Misc

• Database Version 1.3.4 (Min Client Version=6.8.1, Min Calc Version=1.7.0, Min GNR Version =1.3.0, Min DBA_Helper Version=1.2.0, Min LiveUp Version=1.1.0, Min OPS SQL Remote Version=1.1.6)
• Database Version 1.3.3 scripts also included
• Database upgrade includes nt service patch "seeds" that will be required by upcoming versions of Live Update.
• Added the user Dashboard feature - super users can assign dashboards for users within User Setup, allowing for a custom look to each OPS installation and for quick access to OPS functions.  Dashboards are designed in Spread Reports using the new Locate -> Dashboard Element function (740)
• Fixed problem with refreshing the list of Variables in "Variable Browser", you can force a refresh using the <Ctrl>-<R> command.  Also, Location Setup/Browser List automatically refreshes whenever users modify locations. (86) (583)
• Improvements made for "Time" data entry in Spread Reports, Custom Reports, Lab Cal (387)
• Calculation Load Balancing for ADO Calc service is now implemented for OPS SQL Enterprise Edition (ADO Calc Version 1.6.0 and later) (459)
• External Source in Variable Setup now tests date fields properly when connecting to an Access Database (506)
• Fixed problem when switching facilities when the installation has one concurrent user license (521)
• Fixed problem when switching variables while in Add/Edit Variables, it now functions correctly and properly updates each record/variable when on Oracle backend (544)
• Audit Trail in Shortcut Manager is now tracked properly which allows for correct synchronization with OPS SQL Remote databases (561)
• System Setup/Scheduled Tasks now supports "Run Report Trigger" tasks that generate reports based on a user defined report trigger (647)
• User Setup, Browse users now has a search functionality (762)
• The Copy Location feature has been updated to prompt the user if they would like to copy the associated variables. Doing so will create new variables and assign them to the new location (652)
• A "Restart load-balancing" button has been added to the Admin Console for Enterprise Edition to restart their distributed AdoCalc nodes (739)
• HOLDVALUE Math Toolbox was added (814)
• In Variable Setup, changing the variable number now gets properly written to the audit trail (827)
• Fixed a bug in daily detail data entry (hourly, 15min, ... forms) that caused the program to not apply the correct MDL rule to data (840)
• Admin Console/Action Script now contains a script that can be used to export reports from one facility to another (also to another server) (789)
• Added a browse button with sort capabilities and Find function to the User Setup screen (741)
• Lookup table audit info now displayed when editing tables (791)
• Lookup table default export file extension is now ss3 (792)
• Utilities/System Info form now displays OPSSQL license information (793)
• Help file updated

Version 6.7.7 (Released on 1/15/07)

BOD Manager

• Improvements to Sample Setup - Does not allow user to Check Used as Seed and pick a Seed on the same sample.  Other minor improvements.  Support for Oracle improved.
• Fixed problem with data approval
• Fixed problem with calculating the Final BOD as Zero when no Final DO's entered.  Now calculates blank.
• Create new worksheet, Pick Setup from previous sheet now works correctly (515)

Lab Cal

• Filtering improved and several minor bugs fixed (510) (508)

Misc

• External Source Test uses the correct end date in the test (505)
• Shortcut Manager does not show multiple entries for users (372)
• Fixed a "Quoted string not properly terminated" bug that occured in Copy All Shortcuts in Shortcut Manager (171)
• Variable Setup Limits Entry - can now easily create seasonal limits (345) (514)
• Monthly Data Entry Design - when creating the very first form if an Entry Group was not selected caused error to be displayed.  Fixed.  (524)
• When eval version expires the user can not enter a new Serial number from the login screen. (529)
• An extra concurrent seat is not taken up anymore when switching facilities.
• Help file updated.
  

Version 6.7.6 (Released on 1/9/07)

Spread Reports

• California CIWQS electronic reports can now be designed using Locate/eDMR/California CIWQS, and submitted to California Regional Water Boards. See help for instructions. (248)
• Added a way to locate 1 day beyond the end of the report into the DATE formula (340)
• Added function SWTRDR that handles Distribution Disinfectant Residual SWTR (241)
• GAVG function produces correct results when MOV7 statistic is used (328)
• VINFO now produces correct results when asking for Quarterly Max (398)
• Designer Wizard no longer produces Error 6 (Overflow) on databases with very large number of variables (439)
• Footnotes now refresh correctly (456)
• Designer Wizard no longer causes error 3265 (Item not found in collection) when using the Hourly Log report (463)

Custom Data Entry

• Designer no longer crashes when running Wizards (205)
• Designer Wizard overflow bug fixed (257)
• Fixed a bug that allowed users to force data in entry forms omitting the users data approval settings (388)
• Designer saves TSS bench sheet reports correctly (472)

Monthly Data Entry

• Force status in status bar now updates correctly (269)
• Designer now allows users to include daily detail variables (246)

LabCal

• Added a setting that way to set x number of days into future. Used to be fixed at 365 (327)
• Auto-Sensing feature added to populate variables for tests based on test name and/or storet code (258)
  Program now warns when user closes the last sample that came from a definition with a custom schedule (286)
• Improved user interface in Custom Schedule Setup (278)
• One-Time Sample Pick Sample definition does not how when typing characters, nor does it default to location and assigned to fields from the picked sample definition (382)
• Quick-close of sample used to cause error 13 (Type mismatch) when using on whole column of samples. This has been fixed (380)
• Error 3725 no longer occurs when marking sample status as inactive (386)
• Non-critical bug fix in Oracle (ORA-00933) that occurred when double-clicking on a sample (498)(500)
• Click on Cancel in pick a Filter Name in Filter settings does not cause error 3001 (511)

Misc

• Database Version 1.3.2 (Min Client Version=6.7.6, Min Calc Version=1.5.6, Min GNR Version =1.2.4)
• Connections to external SQL-Compliant sources can now be setup and configured to fetch data on per variable basis (357)
• GNR Server now allows for scheduling of tasks that import data from external data sources. (491)
• A new user setting is provided to toggle user’s ability to run import from external data sources. (504)
• BOD Manager added into program
• Modeling Pac added into program (399)
• Added a setting into Admin Console that specified the path where OPSSQL looks when downloading XML data from a Windows Mobile PDA running PocketOPS (359)
• Added ability to easily create summer/winter style limits for variables (345)
• Added a general setting that specifies the Minimum Version for the OPSSQL REMOTE clients. This setting is enforced by all remote clients that synchronize with the master OPSSQL database.
• Lookup table setup no longer sizes rows to 200 when row size is set beyond 1500 (255)
• Weekly Data Entry Form by OPS Systems takes significantly less time to load on large databases (256)
• Fixed up a bug occurred during PocketOPS synchronization process when the POPS/Temp directory was not created (278)
• Fixed a bug that occurred in Oracle when synchronizing PocketOPS routes that consist of variables from different facilities (499)
  Fixed a bug that occurred when user double-clicked on variable to show its quick info and the process return incorrect units (341)
• Variable Info report now correctly reports variable use in Custom Data Entry forms (353)
  User Setup/User Specific Settings now says “Show Data Approval Setup” instead of “Approve Data”. This gets rid of confusion about the functionality of the setting (383)
• Installer now supports OPS SQL Professional edition (480)
• Help file updated.

Version 6.7.4 (Released on 10/5/06)

Spread Reports

• Report Pac/Spread Reports/Prompts now allows for selection of multiple items (225)
• Added report template called Variable_Historical_Eqs. Use this to create a report that will show historical equations for a variable (227)
• Added Spread Function VSAMP. Experimental use only! (249)
• Added Spread Function STI. Experimental use only! (251)
• Fixed "Runtime Error 91" in Spread Design\Spread Report\Locate\User Formula (202)
• GFIRSTZ and GLASTZ displays the Text Results entered as Dates correctly.  (164)
• Violation Summary Wizard now works correctly (231)
• eDMR Generator now supports California CDF format

Custom Data Entry

• Custom Data Entry now allows for Multiline edit cells (cells with text wrapping turned on) (259)
• Custom Data Entry Design now supports import from Microsoft Excel (275)
• Custom Data Entry Design now supports changing the number of columns (275)
• You can now use numerical constants in white cells and will not be cleared when using the form. It now only clears white cells that are equal to 9999 (ie 9999, 9999.0, etc) (211)
• Custom Data Entry now checks for rollover. Hybrid sheet and database scanning is used to accomodate for data that has not been commited to the database (240)

Monthly Data Entry

• Fixed a bug in Monthly Data Entry that occured when pasting data beyond 29th day (265)
• Fixed a bug in Monthly Data Entry which caused a whole row of data turn yellow when Hide Columns feature was used (268)
• Monthly Data Entry Design now allows Managers to to create a form in the default group, if no forms exist (276)

LabCal

• Added a new button to LABCAL that brings up Analyzed but not Closed Samples (65)
• Added a new button to LABCAL that displays the count of samples that are overdue and have fallen off the calendar (67)
• Fixed a bug in LABCAL that used to cause a crash editing existing results in "Enter Results by Test" (78)
• Fixed error 3705 in LABCAL's receive sample function when changing dates (80)
• Added a way of creating a prefix to sample numbers (up to 5 characters). See help topic "Sample Number" for more information on setting up this feature (81)
• Added a way to copy sample definitions from one to another in LABCAL (85)
• Read Only LABCAL users can no longer edit the "Sampled By,Assigned to, Location" fields in the sample edit form (216)
• Read Only LABCAL users can no longer drag and drop samples on the calendar (217)
• LABCAL's Create One Time Sample no longer allows for duplicate sample numbers to be created (219)
• LABCAL/Enter Results by Test now sabes the Time Complete field (234)

Misc

• Installer now lists report templates and let's users pick which ones they want to install (11)
• Fixed "error 3265 : Item not found" in Report Pac/Print Variable List/Detailed Variable Report (190)
• OPSSQL Console is now available to Manager user type if their "ALLOW_CONSOLE_ACCESS" user setting is checked (220)
• Windows/Active Directory pass-through login now fills in the password for a user when switching facility (264)
• Bug fixed in equation parser that caused an the '{<--Number must be 32767 or below}' error in databased with more than 32767 variables (261)
• The login screen and Utilities\System Information menu item will now bring up a summary of information about your system and your OPS environment. This can be written to a log file. (270)
• PocketOPS Synchronization changed to support PocketOPS Windows Mobile v1.2.0
• Fixed multiple minor bugs. Help topics updated.
  

Version 6.6.9 (Released on 8/11/06)

• New Licensing model was implemented. The new Concurrent Session licensing model allows you to install OPS SQL Client on an unlimited number of computers. However, only a limited number of clients can connect to the database at a time. OPS Systems will be happy to issue a new serial number to all our existing customers who are on support. Just call us at 800-677-0067, or email at sales@opssys.com
• OPS SQL v 6.5.9 was the last version of the program to carry the product name OPS SQL. Customers with version 6.5.9 or lower will get a new product name assigned after applying this patch  -  OPS SQL Enterprise Edition. Based on the serial number, OPS SQL Express Edition and OPS SQL Lite Edition are available for medium and small facilities.
• LabCal (Laboratory Calendar) module was added and can be purchased for an additional cost from OPS Systems. It is a simple LIMS system that can be used by small and medium sized laboratories to track and report on samples.
• Extreme speed improvements were achieved by using Variable Browse Buttons all through-out the program. They replace the old pull-down combo-boxes.
• Loading time of the Variable View/Edit form and the Variable Browser were drastically decrased by using database trigger based hash tables (Clients only reload data when the database signals them that something changed)
• Limits can now be created for arbitrary date ranges as well as operators (<,<=,=,>, etc...) The old limits (that were based on months of the year) will be converted to the new Limits and will be interpolated for you automatically until 2011
• ActiveDirectory/Windows pass-through login was implemented.
• Login History is now being tracked for all logins.
• PocketOPS module was modified to support XML mobile databases.
• Plug-in architecture was implemented. Spread Report and Custom Data Entry wizards were converted from DLL's to plug-ins.
• Database Version 1.3.1 (Min Client Version=6.6.0, Min Calc Version=1.5.5, Min GNR Version =1.2.2)
• Fixed multiple minor bugs. Help topics updated.

• Connecticut EDI can now be produced using Report Pac/Spread Reports/Output to EDMR.
  Added Locate/EDMR Link/Connecticut EDI menu item into Spread Report Design.
• Added a feature that enumerates all windows opened by OPS SQL. Go to Utilities/Windows. Click on a window name and the program will give it focus.
• Misc minor bug fixes.
• Help updated.

Version 6.5.5 (Released on 10/6/05)

• Additional Info entry capability added to "Weekly Entry form by OPS Systems".  In entry form, right-click and go to Additional Info on the menu.
• Data Approval added to daily detail entry forms (i.e. hourly, 15 minute entry forms...)
• MID Spread function did not work in some reports that were imported from OPS 32.  Added Check Report button the Report Options form to check for and correct this situation.  If the MID function is not working in a report, go to File, Report Options in Spread Design and click the Check Report button.
• VAL Spread function would sometimes convert a number as a date in Spread Print.  Fixed.
• Multiple Custom Data Entry Sheets Open causes Error when changing dates. Fixed. (Q10182)
• Fixed a bug in Logbook Entry that occured when using logbooks from Custom Data Entry Sheets and caused certain notes to be added into the database with an invalid time stamp.

Version 6.5.3 (Released on 9/12/2005)

• Monthly Data Entry now allows editing of detail data (i.e. hourly, 15 minute data).  Right-click on a day and go to edit detail data.
• Logbook search/select no longer causes an error.
• GCC function updated.  New setting allows for counting of time consecutive samples.  See GCC in updated help file.
• GLAST formula in Spread reports did not work in some imported reports.  Fixed
• Spread Function PERC added. Calculates the nth Percentile and returns the value at that position of a cell range
• COMWO would return ##:##:## when no time entered for comment.  Fixed.

Version 6.5.1 (Released on 8/22/2005)
NOTE: Version 6.5.1 MUST be installed from a CD.  It cannot be installed as a self-update.

Spread Reports

• Added UNDO functionality. Users can specify the number of UNDO levels in Spread Report Designer
• Added REDO functionality
• Added Locate Values from Other Facilities
• Enhanced Prompts - Select Multiple Locations or Varnums
• Added Conditional Formatting based on Data Approval Level (Q10163)
• Users can specify default dates for report when opened in Spread Report Designer. Go to File/Report Options to set this setting (Q10157)
• Added Close All button to Report Pac/Spread Reports/Print. Button is only shown if more than one report is selected or more than one prompt answer is given (Q10167)
• Added an ability to set Max Columns in Spread Design/Report Options (Q10161)
• Group summary statistics is now able to work with 3 digit settings (Q10159)
• Added STATZ formula to calculate statistics of Text Cells. Use when cells contain MDL symbols
• Added Cascade Rule 0 to STATZ function (Q10158)
• Fixed a bug in ISBLANK formula. Unpredictable behavior in certain cases has been corrected (Q10141)
• Fixed a bug that caused Report Date Type not work in Spread Designer (Q10146)
• Fixed a bug in Spread Report Wizard that caused the program to crash when Find was used in Variable Browser (Q10169)
• Fixed a bug that caused invalid results on certain text cells when using Scientific Rounding. Added SROUNDZ formula to handle these situations correctly (Q10131)

Data Entry

• POCKET OPS (for Windows Mobile) is now fully integrated within OPSSQL client. All you need is the device client application and you can start offline data acquisition via your Pocket PC. Please contact sales@opssys.com for more info
• Added a new type of entry form - Weekly. It is especially useful for data troubleshooting purposes. Form can be accessed via Data Manager/Entry Forms Open. It will be residing in the Default group, but can be moved to another group via System Setup/Entry Form Group Manager. The form is called Weekly Entry form by OPS Systems
• Additional Info can now be tracked for every data point. This new functionality enables tracking of virtually unlimited number of fields for each data point. To Access, Right click on data point in Monthly data entry and select Additional Info 
• Not Fixed Decimal Place setting was added for variables that allow data qualifiers. OPSSQL will store such data to however many decimal places are entered by user.
• Fixed a bug in Monthly Data Entry that caused MIN and MAX statistics to malfunction on data with MDL symbols (Q10117)

Misc

• Database Version 1.3.0 (Min Client Version=6.5.0, Min Calc Version=1.5.3, Min GNR Version =1.2.0)
• Fixed a bug that caused OPSSQL to crash (Illegal Operation performed) when waking up from "screen lock" under Windows 2003 Server. If you still experience this behavior after the upgrade, it will be caused by one of the interfaces. Contact support@opssys.com and we will update the interface to use the new .OCX file that is distributed with OPSSQL
• Fixed a bug that caused DDAVG and QCLIMITS settings be ommited when saving a Time Series Graph (Q10145)
• Fixed a bug that caused OPSSQL.INI setting SHOWGAPS to malfunction. This setting is now ommited.Please use a newly created user setting (Q10146)
• Fixed a typo in QUARTER in the Task Scheduler (Q10147)
• Fixed a bug in Variable Browser Filter. Filter now works properly on areas and locations (Q10168)
• Fixed a bug that caused "Invalid Use of Null" error when printing Sample Comments in Report Pac/Logbooks (Q10123)
• Added a new OPSSQL.INI setting ALLOWMULTIRUN. Using ALLOWMULTIRUN=yes allows you to have multiple instances of OPSSQL open concurently.

Version 6.3.4 (Released on 5/3/05)

Spread Reports

• Fixed a bug in the VT function which caused to apply the wrong number of decimal places to data with MDL rules

Misc

• Scheduling of hourly tasks now works on a Oracle 9i database backend using Oracle 9i OLEDB driver.

Version 6.3.3 (Released on 4/13/05)

Spread Reports

• LV, LVT, and DLV functions now support searching forward when search days is set to a negative number.  See Help for more info.
• SQLFIRST and SQLRESULT functions added.  Should be used instead of the SQL function.  In certain cases the SQL function would cause out of stack space errors.   Additionally, SQLFIRST and SQLRESULT can retrieve data from other OPS SQL facilities. 
• Design/Locate/SQL Result has been updated to use SQLFIRST and SQLRESULT
• Design/Locate/SQL Result now allows users to save their favorite formulas
• Fixed a bug that occured in specific situations when saving a report in Oracle

Misc

• Fixed a bug that caused an error when multiple CDE forms were open at one time and date setting was changed
• Help updated

Version 6.3.1 (Released on 3/14/05)

• Edit Data Utility no longer allows locked data to be edited.
• Time Series Graphs where data is grouped Monthly/Weekly no longer locks up PC.  (Bug introduced in V6.3.0).

Version 6.3.0 (Released on 3/2/05)

Spread Reports

• Design/Spread Reports/Report Options allows to specify the type of daterange the report was designed for.
• Design/Spread Reports/Report Options allows to specify a textual report description.
• Report Pac/Spread Reports allows to sort and find on report name, description and date type.
• The < and > date scroll buttons in Report Pac/Spread Reports now automatically adjust date range based on their Report Options setting.
• The first prompt in a report can now accept multiple VarNums by clicking the Variable Browser button.  When multiple variables are selected the same report will be run once for each variable selected.
• New Prompt Type added : Location
• The first prompt in a report can now accept multiple Locations by clicking the Browser button.  When multiple locations are selected the same report will be run once for each location selected.
• AINFO Function Added, used to locate data from the Additional Info tables
• Ihistorian Tag Picker now allows an alternate way to diplay tags in RAW mode. Users can use ctrl+c to copy tags from this output.
• DSORT function now supports sort by date desc ("DD") and date ascending ("DA")

Events

• StartDate replaces DateStamp Field.  EndDate, Duration, Flow, UD1 and UD2 fields added to events.
• Event Type Setup now allows you to show/hide fields and set properties for User Defined Fields for each Event Type.

Time Series Graphs

• 1 Minute and 5 minute data can now be displayed on graphs that are grouped by 15 Minute or Hourly

Custom Data Entry

• Improved error handling for the Save button

Misc

• Database Version 1.2.7 (Min Client Version=6.3.0, Min Calc Version=1.4.1, Min GNR Version =1.1.0)
• LogBook Report Print was fixed to support landscape
• System Setup/System Tables/Lookup Table Setup now allows column and row resize.
• "Not Fixed" option added for Decimal Place setting for a variable that allows symbols.  Spread Functions GAVGZ, GMINZ,GMAXZ, GSUMZ, VT, DDVT updated to support "Not Fixed". See http://www.opssys.com/instantkb/article.aspx?id=10086 for examples.
• Added Additional Info Table Setup under System Setup, System Tables.
• Variable Edit/View, Audit Trail now outputs equation infix in the Varnum form. It used to do it in Varid form which confused users.
• Fixed an update bug in Scheduled Task Editor. Day setting is now properly updated when using weekly or monthly schedule type.
• More than one SQL CONSOLE window can be opened within OPS SQL
• Help updated
  

Version 6.2.6 (Released on 2/1/05)

Fixed a bug that caused to display an annoying message about VsView licencing. This bug was introduced in version 6.2.5.

Version 6.2.5 (Released on 1/24/05)

Spread Reports

• Functions DDVWO, DDVTWO, HWO, GDP, GPREC, DATEDIFF have been added
• Added support for exporting Reports to OPR files (Ops Reports)

Custom Data Entry

• Fixed clear cell of text variables
• Handles Daily Detail Text Parameter Variable correctly
• You can now highlight the entire spreadsheet and Approve Data

Misc

• Schedule Tasks Hourly in Oracle for GNR Server now works correctly
• Message Inbox now sorted by date descending (this fixes bug introduced in version 6.1.2)
• Added right-click options for Variable browser. These will run simple queries against the datatables
• Last 365 days added to date pulldown
• SQL Console now allows you to specify command timeout in seconds
• Fixed minor bugs
• Help updated