Basic Level
Lesson 1: Creating A Report
1.1 Intoduction
1.2 New Features
1.3 Crystal Reports Environment
1.4 Setting Options
1.5 Creating a Report
1.6 Selecting the Data Source
1.7 The Main Components of the Design Window
1.8 Exploring Toolbars
1.9 Managing Resources with Explorers
1.10 Placing Fields on the Report
1.11 Selecting and Sizing Objects
1.12 Browsing Field Data
1.13 Moving and Aligning Objects
1.14 Creating Text Objects
1.15 Saving the Report
1.16 Previewing the Report
1.17 Refreshing the Report
1.18 Using the Status Bar
1.19 Getting Help
1.20 Summary
Lesson 2: Formatting Features
2.1 Introduction
2.2 Quick Formatting with the Template Expert
2.3 Using the Format Painter
2.4 Absolute Formatting
2.5 Conditional Formatting
2.6 Inserting Lines and Boxes
2.7 Inserting Graphic Objects
2.8 Change Page Orientation
2.9 Change Margins
2.10 Working with Text Objects
2.11 Adding Fields Into Text Objects
2.12 Formatting Part or All of a Textbox
2.13 Inserting Special Fields
2.14 Summary
Lesson 3: Database Filters
3.1 Introduction
3.2 Filtering Data with the Select Expert
3.3 Removing Filters
3.4 Selecting Records with Multiple Criteria
3.5 Viewing and Editing the Selection Formula
3.6 Summary
Lesson 4: Report Grouping
4.1 Introduction
4.2 When and Why to Create a Group
4.3 Creating a Group
4.4 Customizing the Groupname Field
4.5 Modifying Groups
4.6 Creating Multiple Groups
4.7 Using the GroupTree to Navigate the Report
4.8 Reordering Groups
4.9 Sorting Within Groups
4.10 Summarizing Groups
4.11 Additional Summary Options
4.12 Groupind Data in DateTime Intervals
4.13 Ordering Groups Based on Their Subtotals Using the Group Sort Expert
4.14 Summary
Lesson 5: Multiple Table Joins
5.1 Introduction
5.2 Understanding Tables Records and Fields
5.3 Learning About Linking
5.4 Adding Multiple Tables to a Report
5.5 Summary
Lesson 6: Creating Formulas
6.1 Introduction
6.2 Understanding Crystal Reports Syntax Without Being Programmer
6.3 Using the Formula Workshop
6.4 Using the Formula Editor
6.5 The Formual Editor Toolbar
6.6 Performing Simple Number Calculations
6.7 Manipulating Dates with Formulas
6.8 Creating Boolean Formulas
6.9 Creating String Formulas 1
6.10 Creating String Formulas 2
6.11 Creating String Formulas 3
6.12 Creating String Formulas 4
6.13 Using Bookmarks to Navigate 1
6.14 Using Bookmarks to Navigate 2
6.15 Using Bookmarks to Navigate 3
6.16 Using Bookmarks to Navigate 4
6.17 Using Bookmarks to Navigate 5
6.18 Using Bookmarks to Navigate 6
6.19 Summary
Lesson 7: Conditional Formatting
7.1 Introduction
7.2 Formatting Sections
7.3 Formatting Sections Conditionally
7.4 Conditionally Formatting Fields 1
7.5 Conditionally Formatting Fields 2
7.6 Summary
Lesson 8: Summary Reports and Charts
8.1 Introduction
8.2 Creating a Summary Report 1
8.3 Creating a Summary Report 2
8.4 Creating a Summary Report 3
8.5 Creating a Summary Report 4
8.6 Creating a Summary Report 5
8.7 Applying the Drilldown Feature
8.8 Applying the DrilldownGroupLevel
8.9 Creating Charts 1
8.10 Creating Charts 2
8.11 Creating Charts 3
8.12 Editing Charts
8.13 Formatting Charts 1
8.14 Formatting Charts 2
8.15 Summary
Lesson 9: Enhancing Report Processing by Writing SQL Statements
9.1 Introduction
9.2 Understanding Exporting Formats and Destinations
9.3 Using a PDF Format for Crystal Reports
9.4 Exporting to Microsoft Excel
9.5 Exporting to HTML
9.6 Exporting to a Report Definition Format
9.7 Summary
Lesson 10: Enhancing Report Processing by Writing SQL Statements
10.1 Introduction
10.2 Report Wizards
10.3 Creating a Report Using the Standard Report Wizard
10.4 Creating a Report Using the Mailing Label Report Wizard
10.5 Summary
Advanced Level
Lesson 1: Refresher Exercise
1.1 Introduction
1.2 Review the Planning Process
1.3 Creating a Report Using Business Requirements 1
1.4 Creating a Report Using Business Requirements 2
1.5 Creating a Report Using Business Requirements 3
1.6 Creating a Report Using Business Requirements 4
1.7 Creating a Report Using Business Requirements 5
1.8 Creating a Report Using Business Requirements 6
1.9 Creating a Report Using Business Requirements 7
1.10 Creating a Report Using Business Requirements 8
1.11 Summary
Lesson 2: Improving Report Appearance with Multiple Sections
2.1 Introduction
2.2 The Power of Using Multiple Sections 1
2.3 The Power of Using Multiple Sections 2
2.4 The Power of Using Multiple Sections 3
2.5 The Power of Using Multiple Sections 4
2.6 Using the section Expert to Insert Additional Sections
2.7 Summary
Lesson 3: Running Totals
3.1 Introduction
3.2 Understanding the Difference Between a Summary Field and Running Totals
3.3 Creating Running Totals in Detail Section 1
3.4 Creating Running Totals in Detail Section 2
3.5 Conditionally Format Running Totals
3.6 Summary
Lesson 4: Prompts
4.1 Introduction
4.2 When to Consider Using Parameter Fields 1
4.3 When to Consider Using Parameter Fields 2
4.4 Creating a Parameter Field
4.5 Using a Parameter Field with an Importing List
4.6 Displaying Parameter Values on Your Report 1
4.7 Displaying Parameter Values on Your Report 2
4.8 Allowing Multiple Values on Your Report 1
4.9 Allowing Multiple Values on Your Report 2
4.10 Displaying Multiple Parameters Values on Your Report
4.11 Use a Date Range with Parameters
4.12 Conditional Formatting Using Parameters
4.13 Using an Edit Mask to Limit a Parameter Value
4.14 Sorting with a Parameter
4.15 Using a Parameter as N in a Top N Report.
4.16 Creating a Dynamic Parameter
4.17 Cascading Parameters
4.18 Summary
Lesson 5: Advanced Formulas
5.1 Introduction
5.2 Understanding How Crystal Reports Retrieves Data 1
5.3 Data Retrieval Process
5.4 Data Retrieval Process Outline
5.5 The First Pass
5.6 The Second Pre-Pass
5.7 The Second Pass
5.8 The Third Pass
5.9 The Process Defined
5.10 Evaluation Time Functions 1
5.11 Evaluation Time Functions 2
5.12 Summary
Lesson 6: Enhancing Report Functionality
6.1 Introduction
6.2 Create a Report to Contain an Unlinked Subreport
6.3 Create a Subreport
6.4 Formatting Subreports
6.5 Passing Variables from the Main Report into a Subreport
6.6 On-Demand Subreports
6.7 Create a Subreport
6.8 Summary
Lesson 7: Subreporting
7.1 Introduction
7.2 Customizing Groups
7.3 Customizing Group Sort Order
7.4 Using Group Selection Formula in the Report
7.5 Grouping on a Formula Field
7.6 Grouping Hierarchically
7.7 Summary
Lesson 8: Using Cross-Tab Reports
8.1 Introduction
8.2 Creating a Cross-Tab Report
8.3 Creating a Cross-Tab with Multiple Rows or Columns
8.4 Formatting a Cross-Tab
8.5 Formatting Background Colors
8.6 Formatting Individual Cells
8.7 Changing the Summary Function
8.8 Create an Alias Name to be Used in a Conditional Formula
8.9 Charting Cross-Tabs
8.10 Summary
Crystal Reports 2008 Training Video CBT Features:
| |
| Training Videos: An instructor introduces each learning module and gives you a preview of the topics that are covered. Instead of relying on reading written introductions, simply click on the video presentations for an interesting, informative summary of the concepts that you will be learning next. You will be learning these topics directly from an expert instructor who really knows the material. |
| Player Controls: You can navigate freely with the player controls. You can play, pause, rewind, forward, and stop any video topic. The controls are familiar and easy to use. Simply click the control that matches the functions you want. If you are interrupted during your studies, click the pause button so that you won’t miss a single minute of the video training. |
| Course Map: Choosing which topic you want to learn is easy with the convenient course map. Advanced users may skip ahead or repeat users can pick up where they left off. The course map allows you to pick and choose the topics that interest you and tailor the learning. You can even use it as a quick launch for reviewing specific topics. |
| Search Function: Find the topics you need instantly. Just type in the word that describes your topic and view the search results. Don't waste countless minutes trying to find something you need now. The Search function is fast, accurate, and easy to use. Relevant search results and fast hyperlinks will jump you to your desired topic in a blink of an eye. |
| Note Taking: Put away your notebook and pencil. Instead, jot down notes or questions for later reference by using the useful notepad feature. If an idea comes to mind or if you need to remind yourself of something important while studying, click on the notepad directly from the course interface and type out your thoughts without ever having to lift a pencil. |
| Bookmarking: Self-paced study is designed to take place over several sessions which makes bookmarking extremely useful. You can exit your training and quickly reference areas of study you wish to revisit later by using bookmarks. If you want to pay special attention to a particular topic, simply use the bookmark feature so that you can spend extra time mastering the concept. |
| Print: Do you need a hard copy? Sometimes, it’s just not practical to log on to your computer when you have a quick question or want to review. The print function lets you print out a hard copy for those times when you need to study offline. Anything that you see on the screen can be printed out for future reference. |
| Certificate of Completion: Each interactive course comes with a certificate of completion. After you have finished the course, you just type in your name and print. It's that simple. Get recognized of your accomplishments with our courses. |
| Multi-User Licensing: The best single and multi-user licensing agreement in the industry. Our licensing agreements accommodate individual students as well as companies with large training requirements. Single user licenses, single PCs licenses, multiple-user (non-concurrent) licenses, and unlimited corporate server site licenses are all available. This level of flexible licensing can’t be beat. No matter what you need, we have a license. |
Total training time: ~ 24 hours
Content: DVD-ROM disc System Requirements: Platform: 
Windows 7, Vista / XP / 2000 / 9x / NT
Processor: Pentium 133 Mhz or higher
RAM: 32MB
Hard drive space: 10MB
CD-ROM Drive speed: 24X
Technical Support:support@amazingelearning.com
