Student Profile: This course is designed for report designers, new to Crystal Reports, who are responsible for creating and distributing reports.
Duration: 2 Days
Description: This two-day instructor-led course is designed to give learners comprehensive skills and in-depth knowledge to plan and create reports that will help them analyze and interpret important information.
Prerequisites: To successfully understand and complete the activities, you must already be able to:
- Understand and use Windows conventions
- Understand basic database concepts
Objectives: You will learn to plan a report, create a report, organize data on a report, format a report and create basic formulas. As well as, apply section formatting, apply conditional reporting, present data visually and distribute a report.
Topics Covered:
Planning a Report
- Define database concepts
- Plan and develop a report prototype
Creating a Report
- Create a report
- Add Tables
- Describe the design environment
- Insert objects on a report
- Previewa report
- Save a report
- Position and size objects
- Format objects
Selecting Records
- Define the Select Expert
- Determine the criteria for record selection
- Understanding saved and refreshed data
- Apply record selection
- Apply additional record selection criteria
- Modify record selection
- Apply time-based record selection
Organizing Data on a Report
- Sort records
- Group records
- Summarize data
Formatting a Report
- Add graphical elements
- Combine text objects with database fields
- Apply specialized formatting
- Insert fields with pre-built functions
Applying Section Formatting
- Format sections
- Create a summary report
Creating Basic Formulas
- Define a formula and its purpose
- Create formulas
- Apply Boolean formulas
- Apply If-Then-Else formulas
- Apply date calculations
- Apply number calculations
- Apply string manipulations
Applying Conditional Reporting
- Determine trends in data
- Format data conditionally
Representing Data Visually
Distributing Reports
- Export a report
- Saving a report to BusinessObjects Enterprise
Certification Applicability: This is a recommended course for the Business Objects Certified Professional - Crystal Reports certification.
Cost: $1,150 |