Purpose/Benefits

Offers a managed query environment and quick report generator that simplifies all aspects of report creation for end users. Can be pre-defined and customized by a developer to control access to views, tables, features, and procedures. Frees the user from repeatedly specifying:

• File path, and field names
• Join expressions, index keys, or foreign key fields which link tables
• LAN print queue and local printer information
• Formulae, expressions, group summary calculations, and other derived data
• Technical requirements for accessing Rushmore® query optimization

Report Types

• Detail: one output per selected record
• Summary: one output per selected record group
• Cross-Tab (1x1): one calculation per pair of row and column values
• Labels: Most Avery® styles and custom layouts

Output Options

• Printer (reports/labels only)
• WWWeb browse-able files
• Spreadsheets
• Graphs (MS Graph or Excel required)
• DBF or ASCII files
• Word Processor mail-merge files
• Browse Windows

Query Features

• Outer-Join support
• Top N values
• Unions
• Pre-defined criteria (change at runtime or locked)
• Prompt for values or full criteria at runtime
• Validation from table or “values-on-file” lookups
• HAVING clause
• Sub-queries
• Generated SQL can be edited, or write your own

Goof Proof Printer Control

• Assign English printer names
• Default printer setups for each user
• Auto Fit-to-Page

Customizable

• Data dictionary ties a descriptive name to complete input editing, processing, and formatting specs for each field or expression
• Data views can be pre-defined and modified during execution (with included utility or programmatically)
• Feature and option privileges for each user
• Logic hooks for custom and pre- and post-processing

Security

• Tables, fields, features, reports (all or parts) can be restricted by user

Advanced Features

• Multi-user design
• Cross-platform enabled
• DDE Server API

Compatibility with FoxPro

• Generates native FoxPro SQL SELECTs and FRX files
• Versions available for Visual FoxPro and FoxPro 2.x (all platforms)

Developer's Edition

• Full source code
• Royalty-free distribution with custom apps (must be compiled)
• Batch Request Support
• Simple, powerful query facility accessible from any place in your application (to create updateable browse, etc.)
• VAR and OEM Agreements available
• Localization rights available (free if for your use only)

Minimum Technical Requirements

• DOS: Extended version of FoxPro v2.5b or 2.6x
• Windows: 8MB RAM, FoxPro v2.5b, 2.6 or 2.6a, or Visual FoxPro (3.0 or 5.0)
• Macintosh: System 7, 8MB RAM, FoxPro v2.5b, 2.5c, 2.6, or 2.6a

Return to Foxfire! Main Page
Simple Queries
Quick Reports
Foxfire! fits your needs
Foxfire! Features
What people are saying about Foxfire!
A review of Foxfire! from FoxTalk

Enterprise Developer's Edition comes with source code, FoxPro project components, and a single user license for the Report Designer (this license cannot be distributed to end users however). With it, you can create a customized report writer that you can distribute with your application.

Foxfire! Enterprise Edition Report Designer licenses are required so that users may create reports. You don't need to have a license to run the reports or customize the FRX-generated layout. These licenses are limited to the same network and may not be distributed.