Features:

• Extracts data from report files produced on any mainframe, midrange, client/server or PC system for fast and easy integration of your data management system
• Exports Excel 2007 OpenXML (xlsx) spreadsheets as well as standard (xls) spreadsheets so you can work with your data in the format you want
• Provides a variety of options for working with report-based data: sort, filter, analyze, visualize and export data to spreadsheets, databases and other applications
• Supports SharePoint® repositories, including access and export, so you’ll always be connected.
• Creates new views of data using data extracted from existing reports.
• Windows Vista™ ready

Benefits:

• Easily integrates data from your company’s existing business systems to desktop applications such as Microsoft Office, including Excel 2007, without programming — increasing productivity and accuracy
• Removes the need to re-key data from printed reports. With Monarch, reports become live, actionable data
• Provides powerful auditing, accounting, financial analysis and inventory analysis by utilizing financial statements and other familiar and trusted reports
• Reduces the need for custom reports, allowing users to re-deploy data from existing reports

New to Monarch V9:

Report Window

• Report Window Exports
• Increased Number of Allowed Templates
• Increased Number of Lines in a Template
• Not Traps
• Trap on Lines Other than the First Line with Footer Templates
• Page Break on Hidden Leading Text Option
• Next Report/Previous Report Icons
• Bookmark Improvements
• Increased Number of Items in Recent Reports

Table Window

• User-Defined Functions
• Opening of Models without Data Sources
• Test Function for Calculated Fields and Filters
• Increased Number of Characters in an Expression
• Calendar Control for Inserting Dates
• Increased Number of Arguments for Min and Max Functions
• Improved Duplicate Handling
• New DateAdjust Function
• Maximize the Expression Editor
• Lookup Field Enhancements

Summary Window

• Quick Summary Design
• Summary Start Tab
• Summary Design Preferences
• Excel Subtotals and Grand Totals as formulas
• Enhanced Options for Measure Value Matching
• Hiding Summary Elements
• Excel Conditional Formatting Rules
• Excel Outlining
• Header Lines
• Multiple Blank Lines
• Increased Limits on Labels
• Increased Number of Item Fields
• New Excel Export Engine
• Export to OpenXML Spreadsheet (xlsx)
• Excel Autofilter
• Excel Freeze Panes
• More control over exporting Null values to Excel
• FirstValue of Field Macro

General

• Object Comments
• PDF Security Options
• Tip of the Day
• Customizable Toolbar
• Enhanced Default Folder Options
• Project and Model Portability
• Sharepoint Support
• Publishing Passwords Stored in Encrypted Form
• Saved Dialog Settings

New to Monarch Pro V9:

• Linking Objects
• PDF Improvements
• Import Using OLE DB
• Import OpenXML Spreadsheets
• Enhanced Database Filters
• Import Multiple Delimited Text Files
• Import Excel Files with No Header Row
• Ability to force Data Types to Character
• Replace Nulls on Import
• Multi-Select Project Exports