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
- Meridian Prolog Manager
- Sage Master Builder
Example Uses
| Work In Progress | Financial Statements | Cash Flow Statements |
| Cost To Complete | Reconciliation | Forms |
| Graphs | Exception Reports | Field Reporting |
| Union Reporting | Forecasting | Audits |
| Schedule Reporting | Data Mining | |
Features
| Feature | Description |
| Easy Connection | To 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. |
| Refresh | Whether 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 Values | When 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 Reports | Data 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 Wizard | With 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 Wizards | Also 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 |
| Function | Definition |
| DBLookup | This 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. |
| DBFind | This function is similar to DBLookup, but allows you to search for the desired data using any combination of criteria. |
| DBAvg | This 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. |
| DBMax | This function provides the maximum value found in a given field. A filter can be applied to limit the records that are evaluated. |
| DBMin | This function provides the minimum value found in a given field. A filter can be applied to limit the records that are evaluated. |
| DBSum | If 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. |
| DBCount | Use 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.
| Feature | Standard License | Designer License |
| Connect to your database |  | |
| Run & Refresh Reports | | |
| Save As Values | | |
| Query Wizard | | |
| Function Wizards | | |
System Requirements
| Required Software | Supported Versions |
| Microsoft Windows |
- Windows 2008 Server, 32-bit or 64-bit
- Windows 7, 32-bit or 64-bit
- Windows Vista, 32-bit or 64-bit
- Windows 2003 Server, 32-bit or 64-bit
- Windows XP
- Windows 2000 Service Pack 4
|
| Microsoft Office |
|
| 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 15 of Master Builder are supported.
|
More Information
