Home About Courses Schedule Services Webinars Contact Search

Using Infomaker Reports

SEE SCHEDULE

Duration: 3 Days

Method: Instructor led, Hands-on workshops

Price: $1625.00

Course Code: SY5000


Audience

This course is designed for information professionals, strategic planners, business analysts, managers or support staff who want to produce quick, ad-hoc reports.

Description

In this hands-on course, students learn to use the InfoMaker to develop queries, reports, and graphs. A series of lab exercises will be used to reinforce the classroom education.

Note: This class can be supported on any version of InfoMaker.

Objectives

Upon successful completion of this course, the student will be able to:

  • Use the InfoMaker Report and Query painters to create both simple and complex reports.
  • Build graph reports, crosstab reports, and composite reports that incorporate other reports.
  • Create an executable report application for distribution to others who may not be running InfoMaker.
  • Configure the InfoMaker environment.

Prerequisites

Experience using Microsoft Windows, a basic understanding of relational databases and basic knowledge of SQL programming is preferable, but not required.

Topics

  • I.Introduction
    • Role of InfoMaker
    • Platforms and Databases Supported by InfoMaker
    • InfoMaker Concepts and Terminology
  • II.The InfoMaker Environment
    • Painter Structure
    • Customizing Toolbars
    • Managing Painter Views and Panes
  • III.Creating Reports
    • Reporting Styles
    • Data Sources
    • Creating Simple Reports
    • Creating a Report with Complex SQL
      • Creating a Report from Multiple Tables
      • SQL Grouping
      • Nested Queries
      • Unions
  • IV.Enhancing Reports
    • Components of a Report
    • Controls
    • Properties
    • Moving, Resizing and Deleting Controls
    • Adding Controls
    • Computed Controls
    • Display Formats
    • Edit Styles
  • V.Using Reports
    • Running Reports
    • Filtering a Report
    • Sorting a Report
    • Printing a Report
    • Importing Data
    • Exporting a Report
    • Creating PDF Files
    • Creating and Using PSR Files
    • Using the Query Governor
  • VI.Advanced Reporting Styles
    • Grouping Data
    • TreeView Reports
    • Crosstab Reports
    • N-Up Reports
    • Newspaper Column Reports
    • Creating Graphs
    • Composite Reports
    • Nesting Reports
    • Label Reports
    • RichText Reports
  • VII.Dynamic Report Behavior
    • Conditional Property Expressions
  • VIII.Using Queries
    • Creating Query Objects
    • Using Query Objects
  • IX.Library Painter
    • Managing Objects
    • Creating an Executable
  • X.Additional Topics (as time permits)
    • Using Data Pipelines
    • Maintaining Profiles and Databases