SaveToDB Change History

SaveToDB Change History

Version 9.10, August 21, 2020

Improvements:

  • The add-in shows the running status in the action and context menus.
  • The add-in does not restore formulas from a database with references to absent worksheets or other workbooks.

Bug fixes:

  • The row editor crashes Excel.
  • The row editor does not work properly with time values.
  • The context menu shows double Open URL menus when switching across different Excel windows.

Version 9.9, July 20, 2020

New features:

  • SaveToDB supports the DefaultValue handler that allows setting default values of parameters in the HANDLER_CODE field (as strings).
  • SaveToDB hides database objects marked with the JsonForm handler from the connection wizard.

Improvements:

  • SaveToDB keeps ribbon parameter values with the same name but changed ids.
    For example, the Budget item can have different ids for different companies.
    When a user changes the company_id, SaveToDB keeps the Budget item as a parameter.
  • The add-in detects output column datatypes of stored procedures using datatypes of edit procedure parameters.
  • Updated SaveToDB Framework 9.9 includes the DefaultValue and JsonForm handlers.
  • Updated SaveToDB Administrator Framework 9.9
  • Updated SaveToDB Developer Framework 9.9
  • Updated SaveToDB SDK examples
  • New Sample 20 - Cube App for Microsoft SQL Server

Bug fixes:

  • The add-in crashes Excel in the Reload Workbook Validation Lists action.
  • The add-in shows multiple Actions context menu when switching between the Database and Reports tabs.
  • The add-in does not restore column translations with hidden row headers.
  • The add-in breaks the column translation on saving table formats of filtered tables.
  • The add-in shows "Invalid object name 'xls.view_framework_objects'" on installing the SaveToDB Developer Framework.

Version 9.8, June 30, 2020

New features:

  • The Options dialog box contains a new "Create validation lists using object definitions automatically" option.
    It allows disabling automatic creation of validation lists introduced and used by default in SaveToDB 8.
    You can disable this option to have the same behavior as in the previous SaveToDB versions.
    Also, you can disable it temporarily to see and edit identifier values instead of names from the tables of foreign keys.
  • The DoNotTranslate handler allows disabling the translation for the specified column or the entire table.
    Use it, for example, to disable translation of imported data.
  • The DoNotSort handler allows disabling sorting for the specified column or the entire table.
    It is designed for the DBEdit, DBGate, and ODataDB products. The SaveToDB add-in does not support it.
  • The following handlers allow specifying data types of columns and parameters on unknown types:
    DataTypeBit, DataTypeBoolean, DataTypeDate, DataTypeDateTime, DataTypeDateTimeOffset,
    DataTypeDouble, DataTypeInt, DataTypeGuid, DataTypeString, and DataTypeTime.
    Use these handlers, for example, to specify data types of SQL code parameters or stored procedure columns.
  • Handlers support the _AskSave value in the TARGET_WORKSHEET field to ask a user to save data before executing the handler.
  • Handlers support the _AskReload value in the TARGET_WORKSHEET field to ask a user to reload data after executing the handler.
    This value differs from _Reload. The _reload forces reloading data and executes the handler in the synchronous context, i.e., the add-in waits for the results.
    Using the _AskReload allows executing handlers in asynchronous mode and asking users after finishing the query.

New SaveToDB applications:

  • We released Gartle Planning 4.0, former SaveToDB Planning Application for Microsoft Excel and SQL Server.
    It is a ready-to-use planning application that allows implementing the required forms, calculations, and reports by in-house analysts.
    The application allows using SaveToDB, DBEdit, DBGate, and ODataDB as clients and Microsoft SQL Server as a back-end database.
    A new version is available in English, German, French, Italian, Spanish, and Russian.
    It supports planning for multiple companies in the same database.
    It includes new samples. Especially, take a look at the Railway Corp. sample that shows how to build financial reports like Profit and Losses, Cash Flow, and Balance Sheet.
    You can get samples using the Online Samples wizard or download a separate package from the website.
  • We released Gartle Budgeting 2.0, former SaveToDB Budgeting Application for Microsoft Excel and SQL Server.
    It is a ready-to-use budgeting application that allows implementing the required forms, calculations, and reports by users and in-house analysts.
    The application also allows using SaveToDB, DBEdit, DBGate, and ODataDB as clients and Microsoft SQL Server as a back-end database.
    A new version is available in English, German, French, Italian, Spanish, and Russian.
    It also supports budgeting for multiple companies in the same database.
    You can get samples using the Online Samples wizard or download a separate package from the website.

If you are interested in implementing in-house planning or budgeting applications, please contact us.
We can create a demo for you and host it on our servers for you for testing purposes.

Improvements:

  • German translation added.
  • The add-in keeps ribbon parameter values with changed identifiers for the same names.
  • The table format wizard does not show tables of validation lists.
  • Improved performance of loading metadata.
  • SaveToDB Framework 9.8 includes new hander types.
  • Updated SaveToDB Administrator Framework 9.8
  • Updated SaveToDB Developer Framework 9.8
  • Updated Change Tracking Framework 3.2
  • Updated Database Help Framework 2.2
  • Updated SaveToDB SDK examples.

Bug fixes:

  • The add-in uses empty values for saving changes if such columns have the same translated names.
  • The Save, Load, and Apply custom items, at the Reports tab, can show an error message.
  • The Save actions at the Reports tab save rows with percent values as changed each time.
  • The add-in cannot connect to SQLite using the ODBC driver.
  • The registration wizard rarely causes an exception.
  • The SaveToDB uninstall wizard launches the DB.RTD uninstall page also.
  • The add-in does not reload the configuration of SelectionList handlers until reopening a workbook.
  • The Table Views dialog box does not update button states after deleting all the views.

Version 9.7, May 5, 2020

New features:

  • The add-in opens a welcome page on the first run.
  • The add-in starts with a reduced ribbon. Users can turn on the full ribbon using the Options menu.
  • The add-in allows loading and refreshing online samples using the Wizards menu.

Improvements:

  • The add-in does not change the row number option on existing connections.
  • The add-in does not turn on the row number option for Excel, Text, CSV, and DBF connections.

Bug fixes:

  • The add-in ignores the _reload word in the handler configuration.
  • SQL commands can not contain spaces before the LIMIT word.
  • .NET providers have slow performance since version 9.6.
  • Selection list handlers do not convert values after opening a workbook.

Version 9.6, February 28, 2020

New features:

  • A user can set a maximum number of loaded rows for tables and views using SaveToDB Options
    to prevent crashing Excel when loading more than one million rows.
    In this case, the add-in modifies SELECT commands like SELECT TOP 500000 * FROM for SQL Server.
    Also, the add-in shows a message when it loads the maximum number of rows.
  • The xls.handlers table contains a new Format EVENT_NAME value used in ODataDB and DBEdit to format tables.
    The Developer Tools contain a new Show Table Format item to create format definitions.

Improvements:

  • Improved Registration Wizard
  • Improved activation in a virtual environment
  • Updated Snowflake .NET Provider
  • Updated SaveToDB Framework 9.6
  • Updated SaveToDB SDK 9.6
  • SaveToDB Options include a new option, Keep Wrap Text in Cell Editor.
    Use it to prevent changing the wrap mode by Excel.
    However, note that this feature breaks Undo.
  • The add-in creates validation rules with a warning type instead of the stop type.
    This feature allows, for example, saving formulas that have temporary errors.
    Use Table Format Wizard, Apply Default Format to apply new rules to existing tables.
    Note that users can use Data, Data Validation, Cycle Invalid Data to highlight cells with invalid data.
  • The add-in suppresses the TextAsNumber Excel warning in data loaded using .NET providers.
  • Improved detection of JOIN relations in views and stored procedures

Bug fixes:

  • Excel does not release workbooks after closing.
  • Ribbon parameters can show id values instead of names.
  • Default SELECT commands include fields marked with the DoNotSelect handler.
  • The add-in does not show timeout errors when loading a database model.
  • Pivot Connection Wizard launches DB.RTD Connection Wizard instead.
  • The add-in ignores DoNotAddValidationList handlers.
  • The Save Table Format menu item raises an exception on saving pivot table formats.
  • The cell editor pastes value twice.

Version 9.5, January 17, 2020

Gartle Technology Corporation changed its name to Gartle LLC.

New features:

  • The add-in supports SaveToDB Framework through OData.
    You can try our product ODataDB that creates OData services from-the-box.
    With ODataDB, you have the same application features via HTTP as for direct database connections.

Improvements:

  • The add-in skips refreshing validation lists with unchanged command text on .NET provider connections.

Changes:

  • Updated EULA
  • Updated samples
  • Updated SaveToDB Framework 9.5
  • Updated SaveToDB SDK 9.5
  • Updated registration wizard

Bug fixes:

  • Fixed exceptions on refreshing tables using VBA
  • Fixed issues with byte/boolean conversions
  • Fixed issues with advanced filters
  • Fixed issues with the CopyAndInsert action in the active Copy mode

Version 9.4, October 21, 2019

New features:

  • A free version of SaveToDB has no limits with the following frameworks:
    - SaveToDB Administrator Framework 9.4 for SQL Server
    - SaveToDB Developer Framework 9.4 for SQL Server
    - Database Help Framework 2.0 for SQL Server
    - Change Tracking Framework 3.0 for SQL Server
    You can install these frameworks using Wizards, Application Installer, or using source codes from the SaveToDB SDK.
    Each of these frameworks can save a lot of time for administrators, developers, and business users. Now you may use them for free.
  • A new column-level BitColumn handler allows formatting integer type columns as check-boxes.
    Such columns can have values: 0, 1, and NULL.
  • A new RegEx handler allows processing an output using regular expressions placed in the HANDER_CODE field.
    The Database Help Framework, for example, uses this feature to create hyperlinks in output documentation.
    You can use an embedded grx.exe tool to test expressions.
  • A new Information event name allows adding records for information purposes.
    For example, SaveToDB Frameworks use it to store versions (in the HANDLER_CODE field).
    SaveToDB does not process such handlers.
  • A new ATTRIBUTE handler type allows using it instead of the NULL value if other types are not appropriate.
  • SaveToDB includes a free DBSetup.exe tool that allows installing, uninstalling, and updating database samples and frameworks.
  • SaveToDB includes a free grx.exe tool that allows replacing text using regular expressions.
    You can use it to test expressions for the RegEx handler.

Improvements:

  • The application installer contains a single option to update SaveToDB Frameworks 9.0+ instead of sets of files.
  • The application installer skips executing the current script if it raises an exception or returns a single cell with a message that starts with 'skip' or ends with 'skipped' words.
  • The application installer stops executing current scripts if the script raises an exception or returns a single cell with a message that starts with 'fail' or ends with 'failed' words.
    It executes rollback if the query has a transaction.
  • The add-in does not use transactions for single SELECT commands.
  • The _notransaction value in the TARGET_WORKSHEET field disables transactions of the handler command.
  • The add-in detects boolean columns in all server platforms (except Oracle).
  • The add-in loads a single validation list for all handlers with the same parameters.
  • The cell editor allows editing merged cells.
  • The cell editor keeps initial line breaks (\r, \n, or \r\n).
  • The add-in removes the [Microsoft][ODBC Driver 17 for SQL Server][SQL Server] substring from error messages.
  • The add-in shows significantly improved performance with Snowflake.
  • The HTML form shows active hyperlinks in a status bar.
  • The HTML form uses the latest available IE web browser control.
  • The dynamic column configuration supports 'Y' and 'N' in the visibility column.
  • An improved developer wizard menu

Bug fixes:

  • The merge wizard fails.
  • The application workbook wizard fails when a workbook template is not available.
  • The list editor does not show values for dynamic columns.
  • The HTML form shows Navigation canceled.
  • The HTML form does not navigate on local anchors.
  • The cell editor does not save the first ' character.
  • The add-in renames columns incorrectly if dynamic columns contain multiple fields with the same alias.
  • The dynamic validation lists do not work in non-US versions.

SaveToDB Samples and Frameworks:

  • SaveToDB SDK uses a new free DBSetup.exe installer instead of the gsqlcmd tool.
    It allows installing examples without additional installations and has improved interactive experience.
    DBSetup.exe is shipped with SaveToDB, DBEdit, and gsqlcmd also.
  • Updated SaveToDB Framework 9.4.
    The EVENT_NAME column of the xls.handlers table includes new values: BitColumn, Information, and RegEx.
    Use BitColumn to format integer type columns as check-boxes.
    Use Information for information records. For example, SaveToDB Framework contains a record with its version.
    Use RegEx to process the output using regular expressions placed in the HANDLER_CODE field.
    The EVENT_NAME column contains values in ascending order.
    The HANDLER_TYPE column of the xls.handlers table contains a new value, ATTRIBUTE.
    You can use this value for declarative handlers like AddHyperlinks, BitColumn, DoNotConvertFormulas, Information, and others that do not have a regular type.
  • SaveToDB Framework 9.4 contains a single file, savetodb-framework-update.sql, used to update SaveToDB Frameworks 9.0 or higher.
    It checks the current features and updates the required.
  • Updated SaveToDB samples.
    The samples use a new DBSetup.exe installer.
  • Online samples for SQL Server moved to a new faster server, mssql.savetodb.com.
    We will remove all samples at savetodb.database.windows.net soon.
  • A new sample, Sample 16 - Symbol Lists, shows benefits of application development using Microsoft Excel with the SaveToDB add-in.
  • A new sample, Sample 17 - Budget Request, shows how to create forms like budget requests.
    The database contains several tables of measures like accounts, entities, categories, and times, and a fact table.
    This sample is a redesigned Sample 03 - Budgeting to show core features.
  • Updated SaveToDB Administrator Framework 9.4 for SQL Server
    You may use a free version of SaveToDB (9.4+) or DBEdit (1.2+) to manage permissions.
  • Updated SaveToDB Developer Framework 9.4 for SQL Server
    You may use a free version of SaveToDB (9.4+) or DBEdit (1.2+) to generate views and stored procedures to select and edit data.
    The framework has fixed issues with generated SQL code output with the MSOLEDBSQL provider.

SaveToDB Planning Application 3.0

  • SaveToDB Planning Application 3.0 has two packages: public and paid.
    The public package contains basic functionality, which is the best to learn features.
    It has several encrypted stored procedures.
    The paid package contains all features, including complete source codes.
    If you are interested in a planning application, please, contact us.
    We can host an application for you for a trial period.
  • The application allows using Microsoft Excel with SaveToDB or DBEdit to customize the app and input data.
  • The application does not require the following frameworks that become optional:
    - SaveToDB Administrator Framework
    - SaveToDB Developer Framework
    - Database Help Framework
    - Change Tracking Framework
  • The application uses a new DBSetup.exe installer.

Database Help Framework 2.0

  • You may use a free version of SaveToDB (9.4+) or DBEdit (1.2+) to edit the documentation.
  • The framework allows disabling schemas to document in schema properties.
    For example, it comes with disabled SaveToDB Framework schemas like xls, doc, and logs.
  • The framework does not include help for SaveToDB Frameworks but uses online hyperlinks.
    So, you have a clear database for your projects.
  • The framework uses regular expressions to process the output documentation.
    You can customize it in the HANDLER_CODE fields of the RegEx hander.
  • The framework includes sample Microsoft Excel and DBEdit workbooks.
  • The framework uses a new DBSetup.exe installer.
  • The framework includes batch samples to generate single-page and multiple-page documentations.
    The batch files used embedded DBSetup.exe and grx.exe tools instead of sqlcmd.exe and powershell.exe.
    So, you can generate the documentation from-the-box.

Change Tracking Framework 3.0

  • You may use a free version of SaveToDB (9.4+) or DBEdit (1.2+) to customize and use the framework.
  • The framework has fixed issues with generated SQL code output with the MSOLEDBSQL provider.
  • The framework uses a new DBSetup.exe installer.

Version 9.3, September 17, 2019

New features:

  • A new column-level AddHyperlinks handler used to add hyperlinks to data table column values.
    You can use this handler for regular HTTP/HTTPs links, worksheets, and connected database objects.
    For example, you can create a view with a list of database objects and add the handler to a column with object names.
    In this case, the add-in adds hyperlinks for objects that exist in the workbook, and you can use the view as an index.
    Note, that you can add the Back action to Excel Quick Access Toolbar and navigate back to the index.
  • A new object-level License handler used to allow saving changes in a free version.
    We use this handler in our products like Business Time Tracker or Market.db to allow using the SaveToDB add-in or DBEdit as a database editor.

Improvements:

  • SaveToDB tab controls have shortcuts.
    For example, you can use Alt-SD, S to open the Save menu.
  • Dynamic validation lists can use the "name" column as a filter column in the third position and the "id" column in the second or third position.
    This allows creating dynamic lists for master tables using the id column as a filter for dependent values.
    Previous versions exclude the use of these names as filters.
  • SaveToDB removes unused dynamic validation lists automatically.
  • SaveToDB creates new validation lists on changes in the HANDLER_CODE field for handlers of the CODE type.
    The previous versions require to change the name to create a new list in such cases.
  • The default query list excludes procedures with usp_insert_, usp_update_, and usp_delete_ prefixes.

Bug fixes:

  • Fixed issues with dynamic validation lists that can have no values.
    Previous versions can fail on adding validation formulas in such cases and create multiple validation list tables.
    SaveToDB 9.3 uses a new dynamic formula. However, it is not incompatible with previous versions.
  • Fixed issues with Cell Editor
  • Fixed issues with DynamicColumns in Snowflake
  • Fixed issues with datetimeoffset, time, timestamp, and datetime2 datatypes in the MSOLEDBSQL provider
  • Fixed issues with an XML datatype in the SQLNCLI11 provider

SaveToDB Samples and Frameworks:

  • Updated SaveToDB Framework 9.3.
    The xls.handlers table includes new AddHyperlinks and License EVENT_NAME values.
    The SaveToDB Framework for SQL Server includes the updated xls.queries view that excludes procedures with usp_insert_, usp_update_, and usp_delete_ prefixes.
  • Updated Sample 13 - Tests for SQL Server
  • Updated Sample 14 - Dynamic Columns for SQL Server
  • Added Sample 14 - Dynamic Columns for Snowflake

Version 9.2, August 13, 2019

Improvements:

  • Configuration objects of dynamic columns can include the third column with the following values:
    - 1 or true to show the column,
    - 0 or false to hide the column,
    - other values or nothing to leave the column visibility as is.
    See example in Sample 14 - Dynamic Columns.
  • The DB2 connection wizard shows only objects granted with the SELECT and EXECUTE permissions.

Bug fixes:

  • Fixed bug related to FormulaR1C1 values
  • Fixed bug related to unavailable default printers

SaveToDB Samples and Frameworks:

  • Updated Sample 14 - Dynamic Columns

Changes in supported platforms and providers:

  • Removed support for IBM DB2 9.5

Version 9.1, July 19, 2019

Licensing changes:

  • You can use the SaveToDB add-in free of charge.
    The free version does not require the registration.
    The free version supports all features except saving changes to server databases.
    In facts, the free version of the add-in is a completely customizable product for creating reporting applications.
    To learn such features, try Sample 03 - Budgeting from the Wizards, Online Examples menu.
    The free version also supports saving changes when working with SQLite and SQL Server Compact databases.
  • You can activate the trial version once when you are ready to try the full features, and not within 30 days after installation.
    Trial activations are controlled on the server-side. You can apply by email to extend the trial period.

SaveToDB Samples and Frameworks:

  • Updated Sample 01 - Basic Features and Sample 02 - Advanced Features.
    The samples are available for all supported platforms.
    The updated examples contain code and configuration samples for all the basic features of the add-in.
    You can try the examples from the menu Wizards, Online Examples.
    You can find the source code of the examples in the SaveToDB SDK.
  • Added Sample 14 - Dynamic Columns.
    The sample demonstrates the dynamic translation of column names depending on query parameter values.
  • Updated SaveToDB Framework 9.1.
    The xls.handlers table includes a new DynamicColumns EVENT_NAME value.
    The SaveToDB Framework for Oracle supports Oracle Database 18c and includes the improved XLS.QUERIES view.
  • Updated SaveToDB Developer Framework 9.1.
    The framework allows generating code in MySQL style like column_name instead of ColumnName.
  • Updated SaveToDB Administrator Framework 9.1.

Changes in supported platforms and providers:

  • SaveToDB 9.1 requires .NET Framework 4.6.2.
  • Removed support for Windows Vista and Windows Server 2008
  • Added support for Microsoft OLE DB Driver 18 for SQL Server (MSOLEDBSQL).
    You can use this provider instead of OLEDBSQL shipped with Microsoft Office if you cannot connect to SQL Server 2017 or higher.
  • Added support for Oracle Database 18c.
  • Added support for IBM DB2 11.1 and IBM Db2 on Cloud.
  • Added support for MySQL 8.0.
    The default connection string character set changed from CharacterSet=utf8 to CharacterSet=utf8mb4.
  • Added support for PostgreSQL 11,
    including support for stored procedures, Npgsql 3 and 4, and Windows authentication.
  • Added support for Progress DataDirect ODBC data connectors, including drivers for SQL Server, Oracle Database, MySQL and PostgreSQL.
  • Updated .NET providers for Oracle Database, MySQL, PostgreSQL, NuoDB, SQLite.

New features:

  • The add-in supports dynamic column translation using stored procedures with parameters.
    For example, a table (view or procedure) contains output columns like Dim1, Dim2, Dim3, String1, String2, Double1, Double2, and so on.
    Depending on the parameter like client_id, columns get names of the dimensions and measures of the specified client.
    To implement this feature, create a procedure with the required parameter (like client_id), which returns two columns with the original and translated column names.
    Then specify the procedure in the HANDLER_SCHEMA and HANDLER_NAME fields of the xls.handlers table with the DynamicColumns EVENT_NAME.
    You can try this feature using Wizards, Online Examples, Sample 14 - Dynamic Columns.
    This feature is available only with the SaveToDB Enterprise edition.
  • The add-in integrates a companion product, DB.RTD, which allows getting data from databases using RTD formulas.
    The product can be useful, at least, in three cases:
    1. Enriching data from one database with data from another (to comply with GDPR, for example)
    For example, our MySQL online database contains product activation codes with no customer data.
    We add customer data in local workbooks only using data from our on-premise SQL Server database.
    2. Eliminating the use of multiple pivot tables when creating refreshable Excel tables in multiple dimensions
    For example, obtaining data by week and month and by customers and products can require four pivot tables.
    Using the product, you can get a single table, which is automatically updated.
    3. Creating tables and panels refreshed at a given interval
    DB.RTD builds and performs such queries very effectively.
    The free edition allows you to use up to 50 formulas. You can acquire the license or subscription separately.
  • The Wizards menu contains a new DB.RTD Connection Wizard.
  • The Reload menu contains a new Refresh RTD Formulas menu button which forces updating DB.RTD and MARKET.RTD data, regardless of the refresh interval.
  • The Reload menu contains a new Reload Worksheet Validation Lists menu button.
  • The add-in allows using named cells with the __name suffix to get and change parameter values using value names rather than their identifiers.
    For example, a parameter like account_id has a list of id and name values (names are displayed).
    You can create the named cell account_id__name to get and update the parameter value using the names.

Improvements:

  • Significantly improved performance of reading Oracle Database and Snowflake metadata
  • Significantly improved SQL code parsers for Oracle Database, MySQL and PostgreSQL that allows detecting underlying tables of views and stored procedures to save changes
  • Significantly improved algorithms used to create validation and parameter value lists automatically
  • Significantly improved features for querying Excel, CSV, and DBF files
    The add-in supports the ribbon query list, SELECT fields, and ribbon WHERE parameters for queries from Excel, CSV and DBF files.
  • The add-in automatically creates a schema.ini file for ODBC and OLEDB queries from CSV files.
  • Improved JSON, XML, CSV, and HTML parsers
  • Data columns without headers in files and web queries get names like F1, F2, and so on.
  • Snowflake queries can return a single cell with a string value starting with the word Fail to rollback changes in Excel.
  • The add-in executes single Snowflake stored procedures without transactions.
  • The add-in supports PostgreSQL COMMIT WORK or COMMIT TRANSACTION (in addition to the common COMMIT).
  • Improved Workbook Application Wizard
  • Improved dialog boxes with a screen font size of 150%
  • Improved SaveToDB add-in stability on errors in another Excel add-ins
  • Improved performance of the first opening of the connection wizard with a large number of providers

Bug fixes:

  • Fixed bug on automatic saving changes (using the Change handler with HANDLER_TYPE TABLE or VIEW) in translated tables
  • Fixed loss of the active data provider when searching for connection data
  • Fixed loss of table changes made with macros (added in version 8.8)
  • Fixed possible AccessViolationException when working with DB2
  • Fixed possible NullReference when opening charts
  • Fixed converting string values like 10E1 to numbers like 100 with .NET providers

Version 9.0, February 7, 2019

SaveToDB 9 includes new features for creating reporting applications with Microsoft Excel and consolidating reports.

The new customizable Reports tab allows managing reports.

Contrary to the previous versions, such reports can use regular Excel ranges, not connected to databases directly, and consume data from databases and other Excel workbooks using formulas.

For example, budget reports built with Microsoft Excel can get data using formulas.
SaveToDB 9 allows saving such reports to a database easily. So, you can use report data for further consolidation.

 

New features:

  • The add-in has the customizable Reports tab.
    The tab allows customizing the following controls:
    - the Save and Reload buttons;
    - the Apply configuration button;
    - parameters to manage calculations and report views.
    The Save buttons allow saving regular Excel ranges to a database.
    The Reload buttons allow reloading data from databases and other Excel workbooks located on separate worksheets.
    The ribbon parameters are similar to VBA controls like DropDown, ComboBox, and CheckBox.
    However, they do not require VBA macros. The add-in applies report row and column filters (report configuration) after each change.
    See Customizing Reports.
  • The add-in supports connections to Microsoft Excel workbooks using the ODBC drivers and OLEDB providers.
    This makes using Microsoft Excel as a database easier.
  • The add-in supports connections to DBF and FoxPro files.
  • The Online Examples menu contains a new set of samples.
    You can install the samples for Microsoft SQL Server using the Application Installer wizard.
  • SaveToDB SDK 9.0 includes a new set of examples with source codes for all supported platforms.

Improvements:

  • The Application Installer and Application Workbooks wizards include updated frameworks and workbooks:
    - SaveToDB Framework 9.0
    - SaveToDB Administrator Framework 9.0
    - SaveToDB Developer Framework 9.0
    - Change Tracking Framework 2.1
    - Database Help Framework 1.1.
  • The Application Workbooks wizard contains URLs of example descriptions.
  • A new Wizards, Developer Tools menu includes all development-related items.
  • The ribbon shows up to 12 parameters.

Removed features:

  • SaveToDB 9 has removed window management features.
    These features were available in Microsoft Office 2007/2010 only as
    Microsoft Office 2013/2016/2019 open workbooks in separate top-level windows.