|
Crystal Reports 10 Level 1 |
 |
 |
 |
2 Day Course
Performance-based objectives
- Create a report by using data from an existing database.
- Locate and present data in a specified order.
- Create groups to summarize report data.
- Build formulas to add non-database data to a report and display data differently.
- Format reports.
- Enhance reports by adding and modifying elements in a report.
- Create single data series charts.
- Distribute report data to other users.
Prerequisites
This course is designed for a person who needs output from a database. In some cases, database programs have limited reporting tools, and/or they may not have access to those tools. They may or may not have programming and/or SQL experience. Before taking this course, students should be familiar with the basic functions of their computer's operating system such as creating folders, opening programs, and working with windows. Students should have basic Windows application skills, such as copying and pasting objects, formatting text, saving files, etc. Students should have a basic understanding of database concepts.
Course Content:
Lesson 1: Creating a Report
- A: Set Default Report Settings
- B: Specify Fields for a New Report
- C: Preview the Report
- D: Modify Field Display
- E: Add a Report Title
- F: Position Fields
- G: Add Fields from Additional Tables
Lesson 2: Displaying Specific Report Data
- A: Find Data
- B: Sort Data
- C: Filter Data by Single Criteria
Lesson 3: Grouping Report Data
- A: Insert a Group
- B: Add Summaries
- C: Format Summary Information
- D: Change Group Options
- E: Add an Additional Group
- F: Filter by Group
- G: Create a Top N Sort Group
Lesson 4: Building Formulas
- A: Write a Formula
- B: Edit a Formula
- C: Group by Formula
- D: Delete a Formula
- E: Build a Filter by Multiple Criteria
- F: Modify a Filter with Multiple Criteria to Create an OR Condition
- G: Create a Parameter Field
- H: Write a Formula that Incorporates Null Fields
Lesson 5: Formatting Reports
- A: Remove White Space
- B: Insert Page Header/Footer Data
- C: Add Borders and Lines
- D: Change the Background Color
- E: Change the Margins
Lesson 6: Enhancing Reports
- A: Create a Section to Contain a Watermark
- B: Insert Objects Using Object Linking and Embedding
- C: Modify Format Based on Data Value
- D: Conditionally Suppress Data
- E: Insert Hyperlinks
- F: Hide Blank Report Sections
Lesson 7: Creating and Modifying Pie Charts
- A: Create a Pie Chart with a Drill-down
- B: Modify Chart Text
- C: Format a Chart
- D: Present a Chart by Group
Lesson 8: Distributing Data
- A: Export to PDF
- B: Export to Excel
- C: Export to an Access Database
- D: Create a Report Definition
- E: Create Mailing Labels
For Information Contact
Rhuann Heimann 618-523-4893
This e-mail address is being protected from spambots. You need JavaScript enabled to view it
www.trainatacumen.com
|
