|
|
|
Internet Accounting Software in partnership with Micromega Systems is proud to announce that the award-winning FoxFire!® reporting system is now available as a module for IAS Visual ADVANCE!
FoxFire!® is a query and reporting tool for developers and end users of all skill levels. Users can query, report, graph, drill down and perform other data mining tasks from FoxPro, Visual FoxPro, MS SQL Server, Access, Sybase, and Oracle tables. Its managed query environment and quick-report generator allow users to create the most complex queries and reports without technical skill or programming.
|
 |
| |
|
FEATURES AT A GLANCE |
|
|
Report Types
- Detail one output per selected record
- Summary one output per selected group of records
- Cross-tab: (1 x 1) one calculation per pair of row and column values
- Labels: most Avery styles and custom
Query Features
- Multi-table LEFT, RIGHT, INNER, FULL JOIN support
- Top N values
- User-defined filters at runtime prompt for full criteria or data values only
- Validation from table or "values-on-file" lookups
- Generated SQL can be edited, or write your own
- Sub queries
Output Options
- Web browse-able files
- Spreadsheet
- Pivot Table (MS Excel® required)
- Graphs (MS Graph or Excel required)
- DBF and ASCII files
- Mail-merge file
- Browse Window
|
Advanced Features
- Multi-user architecture
- Importing and Exporting Requests uses XML
- Advanced OO Ask-at-Runtime dialog
- DDE Server API
Customizable
- Data dictionary ties a descriptive name to complete input editing, processing, and formatting specs for each field or expression
- Data views can be predefined and modified during execution (with included utility or programmatically
- Feature and option privileges for each user
Logic hooks for custom pre-and post-processing
“Goof Proof” Printer Control
- Default printer setup for each user
- Automatic Fit-to-Page functions
- Meaningful printer/queue names
Security
-
Tables, fields, features, reports (all or parts) can be restricted for each user
|
|
|
|
|
|
|
|
