DB441 - Introduction to Crystal Reports
Course Description
Learn to use Crystal Reports to create meaningful, dynamic reports from your raw data. Practice connecting to a variety of data sources to retrieve data for your reports. Learn to use Crystal Reports' filtering capabilities to select specific records, based on criteria you provide. Organize and summarize your data by sorting and grouping records. Set up simple formula fields to manipulate text and string data. Additional topics include inserting text objects and special fields, and applying basic formatting to customize the appearance of your reports.
In this course, you will learn to:
-
Use the data drivers available with Crystal Reports to create reports from one or more tables in an Access database.
-
Navigate through the Crystal Reports workspace to locate the tools you need from toolbars, menus, and explorers.
-
Insert fields from underlying data objects into your reports.
-
Use the Record Sort Expert to sort data within your reports.
-
Specify criteria to select records to include in your reports.
-
Use the Insert Group command and the Group Expert to insert and customize groups.
-
Insert grand totals and group summaries, and use these summaries to sort and filter records.
-
Create basic formula fields that use string and arithmetic operators to manipulate text and numeric data.
-
Customize the appearance of your reports by inserting special fields, text, and graphics; formatting report objects and sections; and applying templates.
-
Prepare reports for distribution and export reports to different formats, including HTML.
Prerequisites
Experience with Windows, and an understanding of basic database concepts.Applies Towards the Following Certificates
- Database Technology Certificate : Electives