Dreamweaver UltraDev
Drumbeat 2000
Training Overview





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.

Available classes...

Reporting with Foxfire!
Advanced Foxfire! Reporting

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.

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
|Top| |Calendar/Sign-Up|

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.

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 UDFs
  • Using Foxfire!s Programming Hooks
    • Second-Pass Reporting
  • 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
|Top| |Calendar/Sign-Up|