This class is ideal for those with a basic understanding of Crystal Reports and who need more in-depth knowledge.
Prerequisites:
Working knowledge of Windows 2000/XP/Vista environment is required. Familiarity with relational database concepts (tables, fields and records) is strongly recommended.
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.
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 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
Want to Take 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 constact us. We can often accommodate countless additional courses NOT available on our public schedules, please inquire for personal assistance.