|
|
| Course Name |
| Crystal Reports XI |
Contact Hours: 24 |
|
| Course Description |
Receive a fundamental understanding of the concepts of by learning to build reports, use formulas, build groups, work with records, and create charts. Follow Jason Manibog as he teaches you many advanced features including the use of running totals, working with cross-tab reports, and utilizing subreports. Additionally, you will develop an understanding for Open Database Connectivity (ODBC) drivers, inner and outer joins, Structured Query Language (SQL), and updating and verifying data sources
Your training is presented by Jason Manibog, he has been in the IT business for the past eight years, five of those as a trainer/consultant. He has conducted numerous classes in Crystal Reports, from versions eight through 11 and has done a wide variety of consultations in Crystal Reports and other database tools, including Microsoft Access and SQL.
How long will it take me to complete the course?
The amount of time it takes to complete the course is dependent upon the time you are able to spend in study. The actual length of the online video instruction is close to 12 hours (including the hands-on practice simulations). However to maximize the learning experience, that online video instruction is broken into many smaller topic segments that tend to be 10-15 minutes in length, and many have optional activities as well.
Will I be able to work at my own pace?
Yes. The modular format of the instruction method allows you to proceed according to your own pace. Your personal schedule governs your completion time.
Are there any required books for the course?
No. the printable materials are accessible from within each course segment and can be viewed online as well. These are included at no additional cost to you.
Can I assess what I have learned?
Yes. Each self-paced unit has an associated assessment quiz. From there you will be able to determine if you understood the concepts or if you still need to review the materials further.
What are the advantages of taking this course online?
Always accessible…on demand…single login…easy to manage…work at your own pace…these are just a few of the many advantages. |
|
| Outcome |
After completing all four course levels, you will have gained a well-rounded education allowing you to...
- Build reports
- Use formulas
- Build groups
- Workwith records
- Create charts
Enroll today in this course to start your learning. |
|
| Assessment |
Evaluation of your performance will be based on...
- Individual module quizzes which can be taken before or after the training section
- Post quiz that assesses the combined topics covered within the complete courses level
Completing a self-directed course: It will be your responsibility to access the course through your individual login, learn from the one-on-one instruction segments, and assess your level of retention with the post tests. All course materials will remain accessible online for the period of the subscription access. The printable study guides can be retained indefinitely as a means of refreshing your skills after a period of time. |
|
| Outline |
|
Session 1
1.0 What is Crystal Reports
2.0 Setting up Before You Build Reports
2.1 Reviewing a Sample Report Design
2.2 Previewing Report Data
2.3 Setting Default Options
3.0 Building a Report
3.1 Creating a Report from Scratch
3.2 Adding Fields
3.3 Re-sizing and Moving Fields
3.4 Adding Titles and other Special Fields
3.5 Saving the Report
4.0 Finding, Sorting And Filtering
4.1 Finding Records
4.2 Sorting Records
4.3 Filtering Records
5.0 Grouping
5.1 Building Groups
5.2 Adding Summaries
5.3 Formatting Groups
5.4 Adding Groups and Changing Group Order
5.5 Group Filtering
6.0 Using Basic Formulas
6.1 Using the Formula Workshop
6.2 Building a Basic Math Formula
6.3 Building a Basic Text Formula
6.4 Using Formulas in Grouping
7.0 Using the Help Section
7.1 Using the Help Features
7.2 Using the Workbench
Session 2
1.0 Working with Advanced Formulas
1.1 Using Formulas in Record Selection
1.2 Creating If, Then, Else Statements
1.3 Using Conversion Functions
1.4 Using Select Case Statements
2.0 Creating Parameters
2.1 Building the Parameter
2.2 Using Dynamic Parameters
3.0 Formatting Sections
3.1 Adding a Watermark
3.2 Basic Formatting
3.3 Conditional Formatting
3.4 Changing Conditional Data Display
3.5 Controlling the Display of Drill-Downs
4.0 Working With Charts
4.1 Creating a Chart
4.2 Formatting Charts
4.3 Modifying Charts
4.4 Creating a Chart by Group
5.0 Exporting Data
5.1 Exporting to Adobe PDF
5.2 Exporting to Excel
5.3 Exporting to the Web
5.4 Setting Report Definitions
6.0 Using the Report Wizard
6.1 Building a Standard Report
6.2 Building Mailing Labels
6.3 Formatting Mailing Labels
Session 3
1.0 Working with Running Totals
1.1 Creating Running Totals
1.2 Creating Conditional Running Totals
1.3 Creating Running Totals by Group
2.0 Utilizing Variables and Arrays
2.1 Using Variables
2.2 Using Arrays
3.0 Understanding Report Processing
3.1 Building a Group Summary Report
3.2 Reviewing Report Processing
4.0 Working with Cross-Tab Reports
4.1 Building Cross-Tab Reports
4.2 Formatting Cross-Tab Reports
4.3 Placing Cross-Tabs in Groups
5.0 Utilizing Subreports
5.1 Building an Unlinked Subreport
5.2 Building a Linked Subreport
5.3 Sharing Data between a Main Report and Subreport
5.4 Building On-Demand Subreports
6.0 Creating Custom Groups
6.1 Grouping by Formula
6.2 Combining Groups
|
|
|
|