 |
 |
 |
 KNOWLEDGEBASE |
 |
Liberty ReportsIntelligent Excel-Based Reporting |
 |
 |
Watch this six-minute video to learn what Excel-Based reporting is all about.
Liberty Reports is the latest generation of Event 1 Software’s award winning Excel-based reporting technology. Use it to generate reports with your business data by transforming Excel into a powerful and intuitive reporting engine. Using the Liberty Reports add-in, Excel becomes the environment in which you design reports and run reports. Use your existing Excel skills to produce highly effective and interactive results including:
- Business intelligence reports
- Management reports
- Exception reports
- Auditing tools
- much more!
Supported Applications
- Sage Master Builder
- Meridian Prolog Manager
- SQL Server Databases
Example Uses
|
|
|
Features
| Feature | Description |
| Easy Connection | Accessing your data is made easy. 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, build your own, or have a report built for you, reports can be run and refreshed allowing you to 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 Liberty Reports, use the Save As Values feature. This turns a Liberty Reports report into an ordinary Excel workbook containing static data in place of the 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. This allows you to 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 Liberty Reports functions in your Excel formulas. |
| Powerful Worksheet Functions |
Liberty Reports adds a set of worksheet functions that you can use in Excel much like other Excel functions. A Liberty Reports worksheet function can retrieve distinct or aggregate values from your database for display in a specific cell in your worksheet or for use in an Excel calculation. Database functions similar to Excel‘s SUM, VLOOKUP, COUNT functions, and others extend the power of Excel to include direct references to your company data. |
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 | Support Versions |
| Microsoft Windows |
|
| Microsoft Office |
|
| Application Software |
|