Liberty Reports

Liberty Reports represents the next generation of integrated Excel-based reporting technology offered by Event 1 Software. Connectivity for each software application supported by Liberty Reports is custom tailored to create a very positive and intuitive experience as you utilize Microsoft Excel as a reporting tool for your business data. Using Liberty Reports, you will transform Microsoft Excel into a powerful and intuitive reporting solution virtually overnight. Use it for business intelligence, management reports, exception reports, auditing, and much more.

Supported Applications

Example Uses

Work In ProgressFinancial StatementsCash Flow Statements
Cost To CompleteReconciliationForms
GraphsException ReportsField Reporting
Union ReportingForecastingAudits
Schedule ReportingData Mining

Features

FeatureDescription
Easy ConnectionTo access your data there is no need for you to create data sources or build SQL queries. Simply select your database, supply login credentials and you’re ready to begin working with your data in Excel.
RefreshWhether you use one of the prebuilt reports, built your own, or have a report built for you, reports can be run and refreshed you can retrieve current data values with just a click of the refresh button.
Save As ValuesWhen you need to share your report with others who don’t use Office Connector, use the Save As Values feature. This turns an Office Connector report into an ordinary Excel workbook containing static data in place of the dynamically linked data.
Save Data with ReportsData in a saved workbook can be refreshed automatically when you open the workbook or the last queried values can be stored in the workbook and redisplayed. This enables you to work with a snapshot of your data and work disconnected from your database.
Query WizardWith a designer license, the query wizard makes it a snap to create Excel queries that give you speedy access to live data. Queries can be used with “parameters” that give you the ability to interact with your data in real time. The dynamic data can be refreshed at any time, and rows are automatically added and removed to reflect changes in your data. Formulas and totals adjacent to the query are automatically filled-down and recalculated when data is refreshed. Create robust queries that can automatically bring together data from multiple tables, sort data, summarize, and filter data.
Function WizardsAlso with a designer license, function wizards guide you step by step making it easy to use Office Connector functions in your Excel formulas.
Powerful Worksheet Functions
FunctionDefinition
DBLookupThis function works like the VLookup function used in Excel and can retrieve data from any field or record in the database using the key values.
DBFindThis function is similar to DBLookup, but allows you to search for the desired data using any combination of criteria.
DBAvgThis function provides the average value found in a given field. A filter can be applied to limit the records that are included in the average.
DBMaxThis function provides the maximum value found in a given field. A filter can be applied to limit the records that are evaluated.
DBMinThis function provides the minimum value found in a given field. A filter can be applied to limit the records that are evaluated.
DBSumIf you need to obtain the sum for a given field in the database this function can be used to compute the sum of a specific field in a table. A filter can be applied to limit the records that are included in the sum.
DBCountUse this function to obtain the total number of records in a table or the number of records from a table that meet a filter condition.

Licensing

Liberty Reports is licensed for each software application individually and by the number of users who will need to use it concurrently. Two types of licenses are offered which determine the features that are available to you. Any number of licenses of each type can be purchased.

FeatureStandard LicenseDesigner License
Connect to your database
Run & Refresh Reports
Save As Values
Query Wizard
Function Wizards

System Requirements

Required SoftwareSupported Versions
Microsoft WindowsWindows Vista
Windows 2003 Server
Windows XP
Windows 2000 Service Pack 4
Microsoft OfficeExcel 2007
Excel 2003
Application Software
  • If using with Meridian Prolog Manager, versions 6.0 through 2008 of Prolog Manager are supported.
  • If using with Sage Master Builder, versions 13 through 14 of Master Builder are supported.

More Information

For Meridian Prolog ManagerProduct BrochureRequest More Information
For Sage Master BuilderProduct BrochureRequest More Information