|
Course ID: 5364
| Course Duration: 2 Days
|
|
Course Dates:
|
| |
|
| |
Crystal Reports XI - Level 1 Training Class
Course ID: 5364
|
|
| |
|
|
| |
|
|
| |
Crystal Reports XI - Level 1 Training Seminar
|
Overview: In this course, students will build basic list and group reports that work with almost any database.
Who Should Attend: 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. Students may or may not have programming and/or SQL experience.
At Course Completion: Upon successful completion of this course, students will be able to: - create a report by using data from an existing database. - use a report to present specific data in the desired order. - create groups to summarize report data. - build formulas to calculate and display data. - format reports. - add and modify elements in a report. - create single data series charts. - distribute report data. |
|
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
Agenda |
|
| |
Lesson 1: Creating a Report
Set Default Report Settings Specify Fields for a New Report Preview a Report Modify Field Display Add a Report Title Position Fields Add Fields from Other Tables
|
|
Lesson 2: Displaying Specific Report Data
Find Data Sort Data Filter Data by a Single Criterion
|
Lesson 3: Grouping Report Data
Insert a Group Add Summaries Format Summary Information Change Group Options Add a Second-Level Grouping Filter Records by Group Create a Top N Sort Group
|
Lesson 4: Building Formulas
Create a Formula Edit a Formula Combine Fields by Formula Delete a Formula Filter Data by Multiple Criteria Modify a Filter Using an OR Operator Create a Parameter Field Account for Null Fields in a Formula
|
Lesson 5: Formatting Reports
Remove White Space Insert Page Header/Footer Data Add Borders, Boxes, and Lines Change Field Background Color Change the Margins
|
|
Lesson 6: Enhancing Reports
Add a Watermark Insert Objects Using Object Linking and Embedding Modify Formatting Based on Data Value Suppress Report Sections Insert Hyperlinks Hide Blank Report Sections
|
Lesson 7: Creating Pie Charts
Create a Pie Chart with a Drill-Down Modify Chart Text Format a Chart Present a Chart by Group
|
Lesson 8: Distributing Data
Export to a PDF File Export to a Microsoft Excel File Export to an Access Database File Export a Report Definition Create Mailing Labels
| |
|
| |
|
|
|
| |
|
|
| |
Pre-requisites |
|
| |
Launch and close programs; navigate to information stored on the computer; and manage files and folders
Use the Windows user interface
Access 2003 - Level 1
|
|
|
|
| |
|
|
|
|
| |
|
|
| |
|
|
|
| |
| |
|
| |
Crystal Reports XI - Level 1 Training Course Dates and Locations
|
|
| |
|
|
| |
Course ID: 5364
| Course Duration: 2 Days
|
|
| |
|
|
| |
Locations: |
|
| |
|
|
| |
Gift card when you register today!
|
|
| |
|
|
| |
| Start Date |
Price |
|
Location/Event Details |
Register Online |
Request More Info |
|
Print/Fax Register |
|
|
| |
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
| |
|
|
| |
Select a market segment to view more courses
|
|
| |
|
|
| |
Or, select a category to view more Information Technology courses
|
|
| |
|
|
| |
Browse By Category
Browse By Location
Browse New Courses
|
|
| |
|
|
|
| |
| |
|
|
|
|
| |
|
|
|
| |

|
|