Standard and Ad-hoc Reporting
Query by Example (QBE)
Authored by Expandable Software, Inc., QUERY BY EXAMPLE (QBE) is an unparalleled ad-hoc search and report tool that provides every user the ability to easily find information in Expandable using the same familiar screen used to add or modify data.
All Expandable editor programs (screens used to add and modify data) have the ability to enter QBE mode, empowering users to find, analyze and change data without having to leave the editing screen.
With Expandable’s QBE feature, the average user can easily create targeted searches and analyze information without the need for a report writer, inquiry tool or IT person to write search criteria.
Query From All Editor Screens, Including:
- Sales Order entry
- PO Entry
- BOM Editor
- Accounts Receivable
- Accounts Payable
- Purchasing
- Master Scheduling
- Inventory Control
- Parts Master
- Lot Master
- GL Chart of Accounts
- JV Editor
- Multi-currency Master
- Budget Editor
Over 80 Editors Available for Query
Query on Any Field
Simultaneously Search Using Any Combination of Criteria in from one to all Data Fields
Search Criteria
- Equals
- Not equals
- Greater than
- Less than
- List of values
- Between
- Wildcards
- starts with
- contains
Export Results to:
- Spreadsheet
- Text
- Fax
Crystal Reports
Expandable brings industry-standard reporting and decision support to the manufacturing floor with Crystal Reports from Business Objects™.
To satisfy the wide-ranging needs of most operations, over 250 pre-written reports are included with each Expandable implementation.
For mission-specific reporting, Crystal Reports includes powerful software wizards that help both novice and average users quickly develop highly-interactive custom reports enhanced by logos, pictures and three-dimensional charts.
Microsoft ODBC functionality enables unlimited custom and ad-hoc reports that incorporate information from other databases or applications.
Over 250 standard reports
- Accessible from pull-down menu in any Expandable screen
- Encompassing all facets of enterprise reporting
Automated formatting
- Sub reports
- Conditional
- Summary
- Cross-tab
- Form
- Drill down
- OLAP
- Top N
- Multiple details
- Mailing labels
Interactive design elements
- Charts
- Drill-downs
- Alerting
- Parameter prompts
- Hyperlinks
- Geographic mapping
- Field highlighting
- Running totals
- Top N
- Bottom N
- Sorting
Export reports to:
- Spreadsheet
- Text
- Fax
Standard Inquiries
Equipped with more than 100 Standard Inquiries covering the entire system, Expandable users gain instant access to information through easy-to-use-pre-built views.
Each inquiry provides as many as six alternative search criteria to locate important data. With the powerful drill-down function, users enjoy the option to simply click on data to explore underlying elements.
Gain precise inquiry results by using QBE to select multiple criteria in any or all fields
Gain precise inquiry results by using QBE to select multiple criteria in any or all fields
Hundreds of pre-built queries come with Expandable