Logo Agriculture XPRT
Companies
Products
Services
Software
Training
Applications
Sign in
List your business
Aeros - a Cultura company
About
  2. Companies
  3. Aeros - a Cultura company
  4. Software
  5. Aeros Vision - Write Database Queries ...

Aeros Vision - Write Database Queries Software

SHARE

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.

  • Queries
  • Reports
  • Dashboards
  • Financial Report Designer
  • Data Model Designer
  • Custom Integrations
Easy To Write Database Queries
  • 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.