Active Reports Beginning


This course is used to introduce students to the Active Reports environment, architecture and specifications.  This session will introduce the student to the database objects stored in the database and the SQL language that is used to access the data in the database.  The student will learn how to collect information that is needed for the report and then how to present it on the report to allow the users to understand the meaning behind the data information.


Session(s):
Session
Title
1Introduction
2
Report Types
3Technical Architecture
4Development Tools 
5Database Objects
6Database Modeling
7Database Query Fundamentals
8Programming
9Testing Methods
10Documentation
11Report Launcher

Please look below at the "Sessions" area of the file attachments at the bottom of this page.

Course Activitie(s):
Activity
Description
1Configure Database on Workstation
2SQL Query Fundamentals
3Create Baseline Report
4Create Database Objects and Stored Procedure
5Client Listing Report
6Enhance Client Listing Report
7Client Family Report
8Client Detail Report
9Deploy Client Summary Listing Report
10Deploy Client Family Report
11Create Provider/Services Listing Report 
12Create Client/Services Listing Report
13Deploy Provider/Services Listing Report


Each participant should have the following items installed on the individual workstation.
  • Active Reports Designer (Click Here)
  • SQL Server 2008 Express (Click Here)
  • Download the latest version of your ClientTrack database.
Each participant should have experience in the following area(s):
  • Basic relational database concepts
  • Basic SQL experience
SelectionFile type iconFile nameDescriptionSizeRevisionTimeUser
SelectionFile type iconFile nameDescriptionSizeRevisionTimeUser
Ċ
View Download
Configure Database on Workstation  699k v. 2 May 28, 2010, 5:20 AM Scott Heffron
Ċ
View Download
SQL Query Fundamentals  1564k v. 2 May 28, 2010, 5:25 AM Scott Heffron
SelectionFile type iconFile nameDescriptionSizeRevisionTimeUser
Ċ
View Download
This is the introduction overview for the beginning course.  352k v. 2 Jun 1, 2010, 6:28 PM Scott Heffron
Ċ
View Download
Explains the different types of reports that will be used during this course.  562k v. 2 Jun 1, 2010, 6:29 PM Scott Heffron
Ċ
View Download
This will describe the technical components for ClientTrack and how it relates to the Report Designer.  1439k v. 2 Jun 1, 2010, 6:44 PM Scott Heffron
Ċ
View Download
Explains the different development tools.  2868k v. 2 Jun 1, 2010, 6:58 PM Scott Heffron
Ċ
View Download
This session explains the different objects available in the database that are used for reporting.  769k v. 2 Jun 1, 2010, 7:10 PM Scott Heffron
Ċ
View Download
Describes the different normalization levels of database modeling.  2416k v. 2 Jun 1, 2010, 7:33 PM Scott Heffron
Ċ
View Download
Work through database query operations  8968k v. 2 Jun 1, 2010, 8:38 PM Scott Heffron