Introduction to Crystal Reports Training - 22:37 hoursThis Crystal Reports course is intended for students who have little to no experience with Crystal Reports. The course will provide students with a general overview of the basic functionality and a general understanding of report design, including the need to provide quality reports in various presentation formats. Students will gain practical experience through hands-on exercises.
Class Prerequisites Experience in the following is required for this Crystal Reports class:
Basic computer skills Experience in the following would be useful for this Crystal Reports class:
Familiarity with relational database concepts (tables, fields, and records)
Goals Explore the Crystal Reports interface. Learn to create a basic report and modify it. Learn to format reports.. Learn to filter reports. Learn to group report data. Learn to create reports from data in multiple tables. Learn to use formulas.. Learn to use conditional formatting. Learn to create summary reports and charts. Learn to export reports to Excel and PDF. Learn to use Report Wizards.
Outline Getting Acquainted with Crystal Reports Report Writing Process Opening Crystal Reports The Database Expert Review the Toolbars The Standard Toolbar The Formatting Toolbar The Insert Toolbar The Experts Toolbar The Navigation Toolbar The External Command Toolbar The Report Sections in the Design Tab Report Header Page Header Details Page Footer Report Footer The Field Explorer Preview the Report Adding Multiple Tables to Reports Formatting Reports Formatting Fields The AdventureWorks Database The Format Painter Working with Objects Text Objects Field Titles Using Fields in Text Objects Aligning and Sizing Objects The Section Expert Images Filtering Reports Create a Filter Based on a Single Criterion Create a Filter for Multiple Selection Criteria Sorting and Grouping Reports Using the Sort Expert Using the Group Expert Summarizing Records within Groups Using Basic Formulas String Formulas Numeric Formulas Date/Time Formulas Running Totals Conditional Formulas Advanced Formatting Using Multiple Sections Summary Reports Lines and Boxes The Highlighting Expert Exporting and Distribution Exporting to Excel Exporting to PDF Exporting to Word Crystal Reports Viewer crystalreports.com |
Intermediate Crystal Reports - 21:52 hoursThis intermediate Crystal Reports training class is designed to enhance your basic report writing skills and move you into creating more complex reports. Time will be spent walking you through the tips and tricks of intermediate report writing along with a good amount of hands on practice. In addition, you will cover professional design, techniques, sub-reporting and advanced formulas.
Goals: Review the basics. Learn to use Sections to improve formatting. Learn to keep running totals. Learn to work with parameters. Learn features of advanced formulas. Learn to create Sub reports. Learn to create and work with custom Groups. Learn to work with Cross Tab Reports. Learn to create Report Alerts.
Outline: Crystal Reports Review Creating a Report Using Parameters Creating Parameters Adding a Parameter Field Optional Parameters Making a Parameter Optional Using a List of Parameter Values Creating a Parameter Value List Dynamic List of Values Creating a Dynamic Value List Cascading List of Values Creating a Cascading Value List Multivalue Parameters Creating a Dynamic Value List Range Parameter Creating a Dynamic Value List Using Subreports Unlinked Subreports Creating an Unlinked Subreport Linked Subreports Adding a Linked Subreport Charts Adding a Chart to a Report Adding a Chart Cross-Tabulation Reports Creating a Cross-Tab Report Creating a Cross-Tab Subreport Advanced Techniques Special Fields Adding Special Fields to a Report Using the If Statement Using the If Statement Using the Select Case Statement Using the Select Case Statement Conditional Formatting Using Conditional Formatting Alternating Row Formatting Formatting Rows by Alternating the Colors Report Alerts Using Report Alerts |
Advanced Crystal Reports - 11:22 hoursThis advanced Crystal Reports training class is designed to enhance your basic report writing skills and move you into creating more complex reports. Time will be spent walking you through the tips and tricks of advanced report writing along with a good amount of hands on practice. In addition, you will cover professional design, techniques, sub-reporting and advanced formulas.
Class Prerequisites Experience in the following is required for this Crystal Reports class:
Intermediate Crystal Reports experience.
Prerequisite Courses Courses that can help you meet these prerequisites:
Introduction to Crystal Reports Training Intermediate Crystal Reports
Outline Crystal Reports Review Review of Basic Report Building Working with SQL The SELECT Statement Working with SELECT Statements The WHERE Clause Filtering with a WHERE Clause The ORDER BY Clause Using ORDER BY Clauses Joins Joining Tables Together SQL Commands Using a SQL Command SQL Expressions Using a SQL Expression Advanced Functions Evaluation Time Functions Working with Variables For Loops While Do Loops Working with Variables and Loops Geographic Mapping Geographic Maps Map Basics Adding a Geographic Chart |