Crystal Reports 2008(v12) - 2011(v14) Designer 2
Description:
This two-day workshop 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. This course incorporates a number of hands on exercises that reinforce the learning process.Course Outline:
Lesson 1: Refresher Exercise
Topic A: Review of Planning a Report
Topic B: Creating the Report
Topic C: Placing Fields on the Report
Topic D: Creating the Formulas
Topic E: Advanced Grouping
Topic F: Selecting Certain Records
Topic G: Helpful Hints for Formatting the Report
Topic H: Adding and Working with Text Objects
Topic I: Hiding and Suppressing Sections
Topic J: Guidelines
Lesson 2: Power Formatting with Multiple Sections
Topic A: Using Multiple Sections in Reports
Topic B: Using the Section Expert to Work with Sections
Topic C: Conditionally Formatting Multiple Sections
Topic D: Challenge Exercise - Formatting with Multiple Sections
Topic E: Challenge Exercise - Conditionally Formatting Using DrillDownGroupLevel
Lesson 3: Using the Running Totals Feature
Topic A: Understanding Running Totals
Topic B: Creating Running Totals for a List of Numbers
Topic C: Conditional Running Totals
Topic D: Challenge Exercise - Creating a Conditional Running Total
Lesson 4: Prompting with Parameters
Topic A: Parameter Field Considerations
Topic B: Creating a Parameter Field
Topic C: Using a Parameter to Select Records
Topic D: Using a Parameter Field
Topic E: Using the Parameter Panel
Topic F: Creating a Dynamic Value List for Parameter Values
Topic G: Importing a Pick List
Topic H: Adding Parameter Values to Text Objects
Topic I: Allowing Multiple Values in Parameters
Topic J: Using Multiple Parameter Fields in Reports
Topic K: Specifying and Limiting a Range
Topic L: Using Parameters in Conditional Formatting
Topic M: Using an Edit Mask to Limit String Parameters
Topic N: Sorting with a Parameter
Topic O: Using a parameter to set N in a Top N Report
Topic P: Cascading Parameters
Topic Q: Challenge Exercise - Using and Displaying Parameters
Lesson 5: Using Advanced Formula Features
Topic A: Understanding How Crystal Reports Processes the Data
Topic B: What Is a Pass?
Topic C: Using Evaluation Time Functions
Topic D: Working with Variables
Topic E: Declaring a Variable
Topic F: Assigning a Value to a Variable
Topic G: Using a Variable in a Formula
Topic H: Variable Scope
Topic I: Separating Statements in Complex Formulas
Topic J: Working with Arrays
Topic K: Understanding the Evaluation Time Debugger
Topic L: Challenge Exercise - Understand and Set Up the YTD Comparison Report
Lesson 6: Using Sub reporting as a Workaround Solution
Topic A: Understanding Sub reports
Topic B: Unlinked versus Linked Subreports
Topic C: Creating an Unlinked Sub report
Topic D: Linking a Subreport
Topic E: Database Links versus Subreports in One-to-Many Situations
Topic F: Formatting the Subreport
Topic G: Passing Data from the Main Report into a Subreport
Topic H: Creating On-Demand Subreports
Topic I: Creating Hyperlinks
Topic J: Using Subreports to Link "Unlinkable" Data
Topic K: Challenge Exercise - Creating Reports with Linked Subreports
Lesson 7: Creating Powerful Groups
Topic A: Creating Custom Groups
Topic B: Customizing Group Sort Order
Topic C: Using Group Selection to Filter the Records in the Report
Topic D: Grouping on a Formula Field
Topic E: Grouping Hierarchically
Topic F: Challenge Exercise – Create Customized Grouping
Topic G: Challenge Exercise - Using Group Selection
Topic H: Challenge Exercise - Creating a Group
Lesson 8: Working with Cross-Tab Reports
Topic A: Understanding How Cross-Tabs Affect Your Data
Topic B: Creating a Cross-Tab Report
Topic C: Creating a Cross- Tab with Multiple Rows or Columns
Topic D: Applying a Formatting Style to the Cross-Tab
Topic E: Customizing the Cross-Tab Format
Topic F: Changing Background Colors
Topic G: Formatting Individual Cells
Topic H: Changing the Summary Operation
Topic I: Suppressing Rows, Columns or Totals
Topic J: Repeating Row Heading for Multi-Page Cross-Tabs
Topic K: Using Alias Names for Column and Row Headings
Topic L: Charting Cross-Tabs
Topic M: Customizing Cross-Tab Group Names
Topic N: Using the CurrentFieldValue Function
Topic O: Challenge Exercise - Cross-Tab Reports
Lesson 9: Report Alerts
Topic A: What are Report Alerts
Topic B: Creating Report Alerts
Topic C: Basing Report Formulas or Conditional Formatting on Report Alerts
Topic D: Creative Usage for Report Alerts
Topic E: Challenge Exercise - Using Report Alerts with Parameter
Lesson 10: Report Templates
Topic A: A Self-Paced Tutorial Teaching the Methods Used to Create Report Templates to be Applied to Unformatted Reports
Lesson 11: The Northwind 2008 Sample Database
Topic A: A Relational Diagram of Tables Existing in the Northwind 2008 Sample Database Provided in the Crystal Reports 2008 Class Files
Lesson 12: Installation and System Requirements
Topic A: A Complete Listing of Operating System and Hardware Requirements
Lesson 13: Setup Instructions for Crystal Reports 2008 APPENDIX E - Function and Operator Locations
Topic A: A Complete Listing of All the Available Formula Functions and an Explanation of the New Custom Functions
Lesson 14: Glossary
Topic A: A Complete Glossary of terms Used Throughout the Book
Scheduled Courses
This course isn't currently on the calendar. Want to schedule it?
Need to request this course on a Different Day?
LANTEC is very responsive to local client needs and unique or custom class demands. If you require a delivery date option for a class title on our schedule, please submit your specific request for immediate consideration. We can often accommodate countless additional courses NOT available on our public schedules, please inquire for personal assistance.