3305 Main Street Ste 019 Vancouver, WA 98663

KB Liberty Reports

slide

I’ve Licensed My Office Connector or Liberty Reports Designer License, But I’m Still Getting a Prompt About The Evaluation License Expiration

Cause When Office Connector Query & Write or Liberty Reports is first installed, both the Designer and Standard features are activated with a 10 day evaluation period. These features are activated without entering a valid License ID. If you only purchased a Designer license, once you have completed licensing your […]
slide

Microsoft Excel 2016 Build 1708 Bug – Template Files Open Duplicate Workbooks

Scenario Attempting to open Liberty Reports or Office Connector Suite templates results in two duplicate workbooks being created from the template instead of one. Cause An update to Microsoft Office 2016, released on September 12th, 2017, introduces a bug which results in this behavior for all Excel template files, not […]
slide

Liberty Reports Parameters May Be Interpreted As A Date

Scenario Query parameters may be incorrectly interpreted as a date when using Liberty Reports against a Microsoft SQL Server database. This could result in an error message similar to the following: This issue is present in the following versions of Liberty Reports: 1.00.0068 1.00.0070 1.00.0073 Cause Liberty Reports uses the […]
slide

An Unexpected Situation Was Encountered When Using Liberty Reports or Office Connector Suite Products In Microsoft Excel 2016 Version 1707

Scenario Attempting to utilize Liberty Reports or Office Connector Suite products results in an error stating, "An unexpected situation was encountered." Cause An update to Microsoft Office 2016, released on July 27th, 2017, includes a damaged copy of a Windows component required for Liberty Reports and Office Connector Suite products. […]
slide

An Error Occurred While Attempting To Retrieve The List of Sage 100 Contractor Databases From The Server

Scenario When migrating from Sage 100 Contractor 2014 (version 19.x) to 2016 (version 20.x), the underlying database framework changes to Microsoft SQL Server. As there are considerable differences between the previous underlying database framework, Fox Pro, and Microsoft SQL Server, there are certain configurations which can result in the following […]
slide

Microsoft Office 2010 Security Update Impairs Functionality

Problem A recent Security Update to Microsoft Excel 2010 causes loss of functionality in some reports designed for Liberty Reports and Office Connector. While some reports may work, others may present the following symptom. Symptom During refresh, Excel will stop responding while calculating results. Recommendation In order to restore functionality […]
slide

Anti-virus Policy Update Damages Office Connector and Liberty Reports .xla File

Background When using Sage Office Connector or Liberty Reports with certain anti-virus applications, a recent security policy update marks the Office Connector.xla or LR.xla file as dangerous and attempts to quarantine/disinfect/remove the file. Problem Office Connector.xla and LR.xla provide the main functionality for Office Connector and Liberty Reports. Once either […]
slide

Liberty Reports shows ‘invalid data drive’ message when trying to connect

Background Liberty Reports for Sage 100 Contractor uses the Sage 100 Contractor API when working with a Sage 100 Contractor database of version 19 or prior. The API is used to populate the list of known databases for use with Liberty Reports and is also used to validate login credentials. […]
slide

How to access a Sage 100 Contractor SQL database with Liberty Reports

Background Beginning with Sage 100 Contractor version 20, Microsoft SQL Server is now used for the underlying database that stores your Sage 100 Contractor data. Liberty Reports automatically adds databases to the list of known databases with Sage 100 Contractor version 19 and prior. This functionality is not possible with […]
slide

Does Liberty Reports for Sage 100 Contractor support the SQL Server Version?

Background The purpose of this article is to make you aware of the status of Liberty Reports as is relates to compatibility with Sage 100 Contractor v20 (the SQL release). As you may already be aware, the release of Sage 100 Contractor v20 is an extensive upgrade because the underlying […]