{\rtf1\ansi\ansicpg1252\uc1 \deff0\deflang1033\deflangfe1033{\fonttbl{\f0\froman\fcharset0\fprq2{\*\panose 02020603050405020304}Times New Roman;}{\f1\fswiss\fcharset0\fprq2{\*\panose 020b0604020202020204}Arial;}
{\f3\froman\fcharset2\fprq2{\*\panose 05050102010706020507}Symbol;}{\f28\froman\fcharset238\fprq2 Times New Roman CE;}{\f29\froman\fcharset204\fprq2 Times New Roman Cyr;}{\f31\froman\fcharset161\fprq2 Times New Roman Greek;}
{\f32\froman\fcharset162\fprq2 Times New Roman Tur;}{\f33\froman\fcharset177\fprq2 Times New Roman (Hebrew);}{\f34\froman\fcharset178\fprq2 Times New Roman (Arabic);}{\f35\froman\fcharset186\fprq2 Times New Roman Baltic;}
{\f36\fswiss\fcharset238\fprq2 Arial CE;}{\f37\fswiss\fcharset204\fprq2 Arial Cyr;}{\f39\fswiss\fcharset161\fprq2 Arial Greek;}{\f40\fswiss\fcharset162\fprq2 Arial Tur;}{\f41\fswiss\fcharset177\fprq2 Arial (Hebrew);}
{\f42\fswiss\fcharset178\fprq2 Arial (Arabic);}{\f43\fswiss\fcharset186\fprq2 Arial Baltic;}}{\colortbl;\red0\green0\blue0;\red0\green0\blue255;\red0\green255\blue255;\red0\green255\blue0;\red255\green0\blue255;\red255\green0\blue0;\red255\green255\blue0;
\red255\green255\blue255;\red0\green0\blue128;\red0\green128\blue128;\red0\green128\blue0;\red128\green0\blue128;\red128\green0\blue0;\red128\green128\blue0;\red128\green128\blue128;\red192\green192\blue192;}{\stylesheet{
\ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 \snext0 Normal;}{\*\cs10 \additive Default Paragraph Font;}}{\info{\title * Element K * 500 Canal View Blvd}
{\author Software Manager}{\operator Software Manager}{\creatim\yr2008\mo1\dy31\hr8\min3}{\revtim\yr2008\mo1\dy31\hr8\min3}{\version2}{\edmins1}{\nofpages4}{\nofwords642}{\nofchars3660}{\*\company ElementK}{\nofcharsws4494}{\vern8243}}
\margl1440\margr1440 \widowctrl\ftnbj\aenddoc\noxlattoyen\expshrtn\noultrlspc\dntblnsbdb\nospaceforul\hyphcaps0\horzdoc\dghspace120\dgvspace120\dghorigin1701\dgvorigin1984\dghshow0\dgvshow3\jcompress\viewkind1\viewscale100\nolnhtadjtbl \fet0\sectd 
\linex0\sectdefaultcl {\*\pnseclvl1\pnucrm\pnstart1\pnindent720\pnhang{\pntxta .}}{\*\pnseclvl2\pnucltr\pnstart1\pnindent720\pnhang{\pntxta .}}{\*\pnseclvl3\pndec\pnstart1\pnindent720\pnhang{\pntxta .}}{\*\pnseclvl4\pnlcltr\pnstart1\pnindent720\pnhang
{\pntxta )}}{\*\pnseclvl5\pndec\pnstart1\pnindent720\pnhang{\pntxtb (}{\pntxta )}}{\*\pnseclvl6\pnlcltr\pnstart1\pnindent720\pnhang{\pntxtb (}{\pntxta )}}{\*\pnseclvl7\pnlcrm\pnstart1\pnindent720\pnhang{\pntxtb (}{\pntxta )}}{\*\pnseclvl8
\pnlcltr\pnstart1\pnindent720\pnhang{\pntxtb (}{\pntxta )}}{\*\pnseclvl9\pnlcrm\pnstart1\pnindent720\pnhang{\pntxtb (}{\pntxta )}}\pard\plain \qc \li0\ri0\sl240\slmult0\nowidctlpar\faauto\rin0\lin0\itap0 
\fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\b\f1\fs20\cf1 * Element K * 500 Canal View Blvd. * Rochester NY 14623 *
\par * (800) 456-4677 * Fax: (585) 240-7760 *
\par }\pard \qc \li0\ri0\sl240\slmult0\nowidctlpar\tx5760\faauto\rin0\lin0\itap0 {\b\f1\fs20\cf1 
\par }\pard \ql \li0\ri0\sb120\sa120\sl240\slmult0\nowidctlpar\faauto\rin0\lin0\itap0 {\b\fs36\cf1 Crystal Reports\'ae 2008: Level 2
\par }{\b\f1\fs26\cf1 Course Specifications
\par }\pard \ql \li0\ri0\sl240\slmult0\nowidctlpar\faauto\rin0\lin0\itap0 {\f1\fs20\cf1 Course number: 085168
\par Software: Crystal Reports\'ae 2008
\par Course length: 2.0 day(s)
\par }\pard \ql \li0\ri0\sb120\sa120\sl240\slmult0\nowidctlpar\faauto\rin0\lin0\itap0 {\b\f1\fs26\cf1 Course Description
\par }{\f1\fs20\cf1 Until now, you have used Crystal Reports to build and modify reports. You want to use the advanced functionality of Crystal Reports to generate reports in the format you desire. I
n this course, you will create complex reports and data sources using Crystal Reports' tools. You will not only create more sophisticated reports including subreports and cross-tabs, but you will also increase the speed and efficiency of your reports by u
sing SQL queries. 
\par }\pard \ql \li0\ri0\sa240\sl240\slmult0\nowidctlpar\faauto\rin0\lin0\itap0 {\b\f1\fs20\cf1 Course Objective: }{\f1\fs20\cf1 You will create complex reports using Crystal Reports' tools.
\par 
\par }{\b\f1\fs20\cf1 Target Student: }{\f1\fs20\cf1 This course is designed for people who know how to create basic list and group reports and need to create reports that include subreports, cr
oss-tabs, advanced formulas, and charts based on more than one data series. They may also need to build tools that make it easier for other people to create reports. They may or may not have programming and/or SQL experience.
\par 
\par }{\b\f1\fs20\cf1 Prerequisites: }{\f1\fs20\cf1 Crystal Reports\'ae 2008: Level 1. A knowledge of programming and/or SQL would also be helpful.
\par 
\par }{\b\f1\fs20\cf1 Delivery Method: }{\f1\fs20\cf1 Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.
\par }\pard \ql \li0\ri0\sb120\sa120\sl240\slmult0\nowidctlpar\faauto\rin0\lin0\itap0 {\b\f1\fs26\cf1 Hardware Requirements
\par }{\f1\fs20\cf1 For this course, you will need one computer for each student and one for the instructor. Each computer will need the following hardware components at a minimum: 
\par }\pard \ql \li0\ri0\sl240\slmult0\nowidctlpar\faauto\rin0\lin0\itap0 {\f3\fs20\cf1 \'b7\tab }{\f1\fs20\cf1 An Intel\'ae Pentium\'ae III or higher (Pentium IV-class recommended) 
\par }{\f3\fs20\cf1 \'b7\tab }{\f1\fs20\cf1 256 MB RAM (512 MB RAM recommended)
\par }{\f3\fs20\cf1 \'b7\tab }{\f1\fs20\cf1 A 5 GB hard disk or larger if you use Windows XP Professional as your operating system. You should have at least 600 MB free hard-disk space available for Microsoft Office installation. 
\par }{\f3\fs20\cf1 \'b7\tab }{\f1\fs20\cf1 Access to one of the following: a local CD-ROM drive, a local DVD drive, or access to a networked CD-ROM drive. 
\par }{\f3\fs20\cf1 \'b7\tab }{\f1\fs20\cf1 A mouse or other pointing device.
\par }{\f3\fs20\cf1 \'b7\tab }{\f1\fs20\cf1 Network cards and cabling for local network access.
\par }{\f3\fs20\cf1 \'b7\tab }{\f1\fs20\cf1 Internet access (see your local network administrator).
\par }{\f3\fs20\cf1 \'b7\tab }{\f1\fs20\cf1 A projection system to display the instructor's computer screen.
\par }\pard \ql \li0\ri0\sb120\sa120\sl240\slmult0\nowidctlpar\faauto\rin0\lin0\itap0 {\b\f1\fs26\cf1 Platform Requirements
\par }\pard \ql \li0\ri0\sl240\slmult0\nowidctlpar\faauto\rin0\lin0\itap0 {\f3\fs20\cf1 \'b7\tab }{\f1\fs20\cf1 Microsoft\'ae Windows\'ae XP
\par }\pard \ql \li0\ri0\sb120\sa120\sl240\slmult0\nowidctlpar\faauto\rin0\lin0\itap0 {\b\f1\fs26\cf1 Software Requirements
\par }\pard \ql \li0\ri0\sl240\slmult0\nowidctlpar\faauto\rin0\lin0\itap0 {\f3\fs20\cf1 \'b7\tab }{\f1\fs20\cf1 Microsoft\'ae Windows\'ae XP Professional\'ae or Vista\'ae.
\par }{\f3\fs20\cf1 \'b7\tab }{\f1\fs20\cf1 A custom installation of Crystal Reports\'ae 2008.
\par }{\f3\fs20\cf1 \'b7\tab }{\f1\fs20\cf1 A default installation of Microsoft\'ae Office\'ae 2007.
\par }{\f3\fs20\cf1 \'b7\tab }{\f1\fs20\cf1 An installed print driver. (Printers are not required; however, each PC must have an installed printer driver to use Print Preview.) 
\par }{\f3\fs20\cf1 \'b7\tab }{\f1\fs20\cf1 A default installation of the free Adobe\'ae Acrobat Reader\'ae 8.0 application. 
\par }\pard \ql \li0\ri0\sb120\sa120\sl240\slmult0\nowidctlpar\faauto\rin0\lin0\itap0 {\b\f1\fs26\cf1 Performance-Based Objectives
\par }\pard \ql \li0\ri0\sl240\slmult0\nowidctlpar\faauto\rin0\lin0\itap0 {\f1\fs20\cf1 Upon successful completion of this course, students will be able to: 
\par }{\f3\fs20\cf1 \'b7\tab }{\f1\fs20\cf1 create automatic and manual running totals.
\par }{\f3\fs20\cf1 \'b7\tab }{\f1\fs20\cf1 work with cross-tab reports.
\par }{\f3\fs20\cf1 \'b7\tab }{\f1\fs20\cf1 add subreports.
\par }{\f3\fs20\cf1 \'b7\tab }{\f1\fs20\cf1 create drill-downs in a report.
\par }{\f3\fs20\cf1 \'b7\tab }{\f1\fs20\cf1 use SQL statements in report processing.
\par }{\f3\fs20\cf1 \'b7\tab }{\f1\fs20\cf1 create complex formulas.
\par }{\f3\fs20\cf1 \'b7\tab }{\f1\fs20\cf1 add charts to reports.
\par }{\f3\fs20\cf1 \'b7\tab }{\f1\fs20\cf1 enhance report functionality.
\par }\pard \ql \li0\ri0\sb120\sa120\sl240\slmult0\nowidctlpar\faauto\rin0\lin0\itap0 {\b\f1\fs26\cf1 Course Content
\par }\pard \ql \li0\ri0\sl240\slmult0\nowidctlpar\faauto\rin0\lin0\itap0 {\b\f1\fs20\cf1 Lesson 1: Creating Running Totals
\par }\pard \ql \li720\ri0\sl240\slmult0\nowidctlpar\faauto\rin0\lin720\itap0 {\f1\fs20\cf1 Topic 1A: Create a Running Total Field
\par Topic 1B: Modify a Running Total Field
\par Topic 1C: Create a Manual Running Total
\par }\pard \ql \li0\ri0\sa240\sl240\slmult0\nowidctlpar\faauto\rin0\lin0\itap0 {\f1\fs20\cf1 
\par }\pard \ql \li0\ri0\sl240\slmult0\nowidctlpar\faauto\rin0\lin0\itap0 {\b\f1\fs20\cf1 Lesson 2: Working with Cross-Tabs
\par }\pard \ql \li720\ri0\sl240\slmult0\nowidctlpar\faauto\rin0\lin720\itap0 {\f1\fs20\cf1 Topic 2A: Create a Cross-Tab Report
\par Topic 2B: Format a Cross-Tab Report
\par Topic 2C: Create Groups in Cross-Tab Reports
\par }\pard \ql \li0\ri0\sa240\sl240\slmult0\nowidctlpar\faauto\rin0\lin0\itap0 {\f1\fs20\cf1 
\par }\pard \ql \li0\ri0\sl240\slmult0\nowidctlpar\faauto\rin0\lin0\itap0 {\b\f1\fs20\cf1 Lesson 3: Adding Subreports
\par }\pard \ql \li720\ri0\sl240\slmult0\nowidctlpar\faauto\rin0\lin720\itap0 {\f1\fs20\cf1 Topic 3A: Insert a Subreport
\par Topic 3B: Edit a Subreport
\par Topic 3C: Share Variables
\par }\pard \ql \li0\ri0\sa240\sl240\slmult0\nowidctlpar\faauto\rin0\lin0\itap0 {\f1\fs20\cf1 
\par }\pard \ql \li0\ri0\sl240\slmult0\nowidctlpar\faauto\rin0\lin0\itap0 {\b\f1\fs20\cf1 Lesson 4: Creating Drill-Downs in a Report
\par }\pard \ql \li720\ri0\sl240\slmult0\nowidctlpar\faauto\rin0\lin720\itap0 {\f1\fs20\cf1 Topic 4A: Create a Drill-Down
\par Topic 4B: Create Headings for Drill-Down Data
\par }\pard \ql \li0\ri0\sa240\sl240\slmult0\nowidctlpar\faauto\rin0\lin0\itap0 {\f1\fs20\cf1 
\par }\pard \ql \li0\ri0\sl240\slmult0\nowidctlpar\faauto\rin0\lin0\itap0 {\b\f1\fs20\cf1 Lesson 5: Using SQL Statements in Report Processing
\par }\pard \ql \li720\ri0\sl240\slmult0\nowidctlpar\faauto\rin0\lin720\itap0 {\f1\fs20\cf1 Topic 5A: Create a Report Using SQL Queries
\par Topic 5B: Summarize Report Data
\par Topic 5C: Create Joins Using SQL
\par Topic 5D: Create Subqueries
\par Topic 5E: Create a SQL Expression Field
\par }\pard \ql \li0\ri0\sa240\sl240\slmult0\nowidctlpar\faauto\rin0\lin0\itap0 {\f1\fs20\cf1 
\par }\pard \ql \li0\ri0\sl240\slmult0\nowidctlpar\faauto\rin0\lin0\itap0 {\b\f1\fs20\cf1 Lesson 6: Creating Complex Formulas
\par }\pard \ql \li720\ri0\sl240\slmult0\nowidctlpar\faauto\rin0\lin720\itap0 {\f1\fs20\cf1 Topic 6A: Work with Loops
\par Topic 6B: Work with Arrays
\par }\pard \ql \li0\ri0\sa240\sl240\slmult0\nowidctlpar\faauto\rin0\lin0\itap0 {\f1\fs20\cf1 
\par }\pard \ql \li0\ri0\sl240\slmult0\nowidctlpar\faauto\rin0\lin0\itap0 {\b\f1\fs20\cf1 Lesson 7: Adding Charts to Reports
\par }\pard \ql \li720\ri0\sl240\slmult0\nowidctlpar\faauto\rin0\lin720\itap0 {\f1\fs20\cf1 Topic 7A: Create Charts
\par Topic 7B: Create a Chart with a Drill-Down
\par Topic 7C: Create a Top N Chart
\par Topic 7D: Create a Cross-Tab Chart
\par Topic 7E: Create Charts for Grouped Data
\par Topic 7F: Format a Chart
\par Topic 7G: Create a Chart Template
\par }\pard \ql \li0\ri0\sa240\sl240\slmult0\nowidctlpar\faauto\rin0\lin0\itap0 {\f1\fs20\cf1 
\par }\pard \ql \li0\ri0\sl240\slmult0\nowidctlpar\faauto\rin0\lin0\itap0 {\b\f1\fs20\cf1 Lesson 8: Enhancing Report Functionality
\par }\pard \ql \li720\ri0\sl240\slmult0\nowidctlpar\faauto\rin0\lin720\itap0 {\f1\fs20\cf1 Topic 8A: Organize Data Based on a Hierarchy
\par Topic 8B: Create a Dynamic Image
\par Topic 8C: Create a Report Alert
\par Topic 8D: Create a Geographic Map
\par }\pard \ql \li0\ri0\sa240\sl240\slmult0\nowidctlpar\faauto\rin0\lin0\itap0 {\f1\fs20\cf1 
\par }\pard \ql \li0\ri0\sl240\slmult0\nowidctlpar\faauto\rin0\lin0\itap0 {\b\f1\fs20\cf1 Appendix A: Managing Reports
\par }\pard \ql \li0\ri0\sa240\sl240\slmult0\nowidctlpar\faauto\rin0\lin0\itap0 {\b\f1\fs20\cf1 
\par }\pard \ql \li0\ri0\sl240\slmult0\nowidctlpar\faauto\rin0\lin0\itap0 {\b\f1\fs20\cf1 Appendix B: Processing Data on the Server
\par }\pard \ql \li0\ri0\sa240\sl240\slmult0\nowidctlpar\faauto\rin0\lin0\itap0 {\b\f1\fs20\cf1 
\par }\pard \ql \li0\ri0\sl240\slmult0\nowidctlpar\faauto\rin0\lin0\itap0 {\b\f1\fs20\cf1 Appendix C: Detecting and Fixing Problems
\par }\pard \ql \li0\ri0\sl240\slmult0\nowidctlpar\tx2160\faauto\rin0\lin0\itap0 {\b\f1\fs20\cf1 
\par }\pard \ql \li0\ri0\sl240\slmult0\nowidctlpar\tx5760\faauto\rin0\lin0\itap0 {\b\f1\fs20\cf1 \page }{
\par }}