- Financial Report Designer
- Data Model Designer
- Custom Integrations
Easy To Write Database Queries
- You don’t need to understand SQL or how to program a database, just know where your data is! With our Query writing tool, the system does all the behind-the-scenes work for you.
- Connect to any database systems such as SQL Server, MySQL, Access, Progress, etc.
- Friendly table and column names for the Aeros ERP and Aeros LIVE databases to quickly extract your data.
- Unlike other query builders that require you to have some knowledge about relational database concepts, tables, joins, etc., our Query tool allow you to construct a query visually: simply by assembling a phrase in natural language.
- Easy for non-technical users to understand.
Powerful Grid View to Display Data
- Create a standard Excel-type grid view of the data from your query.
- Customizable Column Widths, Automatic Column Widths, Fixed Column Widths, Column Customization, Visibility and Orders, Best Fit
- Sorting: Sort against Unlimited Number of Fields, Sort by Cell Display Values, Custom Sorting Algorithms
- Grouping: Group against an Unlimited Number of Columns, Joined Group Panel, Multiple Predefined Grouping Intervals
- Summaries: Total Summaries, Group Row Summaries, Group Footer Summaries, Five Built-in Aggregate Functions, Custom Aggregate Functions, Sorting Against Group Summary Values
- Printing and Data Export: Multiple data display and reporting options via a built-in WYSIWYG system. Data export to multiple file formats including XLS, PDF, HTML, etc.
- Cell Value Formatting: Display text formatting using standard and custom format strings. Over 20 integrated cell editors for more effective data presentation.
Beyond Grids to Reports
- Convert your Queries and Grids to powerful, printable Reports.
- Report Wizards to quickly step through creating a report from scratch.
- Create, print and email reports utilizing data from your Queries in one central location.
- Functions for drill-down reporting to go from summary to detailed reporting.
- Summaries, Grouping, Barcodes, Checkboxes, Labels, Pictures, Tables, ZipCodes, Charts, Pivots, Sparklines, Table of Contents, Page Info and more.
- Advanced scripting capabilities for complex logic rules to meet your business needs.
From Zero to Dashboards In Record Time
- Create insightful and information rich decision support systems for executives and business users.
- Chart, Pivot Table, Data Card, Gauge, Map, Grids and more.
- Flexible, interactive and fully customizable experiences that is optimized for real-time data consumption and analysis.
- Connect to any data source, SQL Server, Access, Excel, VISION Queries, MySQL, Progress, and many more.
Advanced Financial Reporting
- Direct integration with our Aeros ERP solutions for powerful financial reporting.
- Create Case Flows, Financial Statements, P&L’s, or any other financial report using G/L Account configurations.
- Create formulas to pull from one, multiple, or a range of Accounts.
- Summaries, Grand Totals and calculations to support your needs.
- Pull from Budgets and create comparison reports.
- Customizable and unlimited number of columns and rows.
- Export to Excel or PDF for easy printing and archiving.