|
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.
It is a complete FoxPro application that includes all the necessary
FoxPro project components.
Reporting
with Foxfire!
Course Description
This one day hands-on course teaches end-users to create meaningful
queries and reports from their data using Foxfire!. Using Foxfire!
will greatly simplify information retrieval and report writing.
Foxfire! takes maximum advantage of FoxPro's optimization features,
and allows for complex uses of your data with fewer, easier commands.
Intended
Audience
End-users of Foxfire! who want to improve their ability to create
ad hoc queries and reports from applications written in FoxPro.
Prerequisites
Students should be familiar with basic computer concepts.
Course Outline
- FoxPro and
Foxfire!
- Request and
Output Types
- Customizing
Foxfire! Reports
- Basic Concepts
of Foxfire!
- Request Building
Skills
Advanced
Foxfire! Reporting
Course
Objective
This two-day class is for developers and power users that are already
familiar with the basics of Foxfire! and now want to learn about
advanced product features and how to tackle more complex queries
and reports.
Prerequisites
Solid understanding of SQL and FoxPro programming.
Course
Outline
- Foxfire!
Architecture Overview
- Foxfire!’s
System Tables (Metadata)
- Foxfire!’s
Programming Hooks
- The
Data Item Editor
- Changing
the Appearance of a Data Item
- Adding
a New Data Item
- Advanced
Data Item Features
- Advanced
Data Items using UDF’s
- Using
Foxfire!’s Programming Hooks
- Creating
Custom Ask-at-Runtime Filter Value User Interface Controls
- Pick lists
- Custom
date entry controls
- Strategies for Relational Reporting from Complex or Ambiguous
Data Models
- Foxfire! Views
- SubQueries
- Self-Joins
- Outer-Joins
- Data Security Considerations and Capabilities
- Printing Management on Networks
|
