Course Details
Course Outline
1 - Exploring the Crystal Reports Interface
Topic A: Explore Crystal ReportsTopic B: Use Crystal Reports HelpTopic C: Customize Report Settings
2 - Working with Reports
Topic A: Create a ReportTopic B: Modify a ReportTopic C: Display Specific Report DataTopic D: Work with Report Sections
3 - Using Formulas in Reports
Topic A: Create a FormulaTopic B: Edit a FormulaTopic C: Filter Data by Using a FormulaTopic D: Work with Advanced Formulas and FunctionsTopic E: Handle Null Values
4 - Building Parameterized Reports
Topic A: Create a Parameter FieldTopic B: Use a Range Parameter in a ReportTopic C: Create a Prompt
5 - Grouping Report Data
Topic A: Group Report DataTopic B: Modify a Group ReportTopic C: Group by Using ParametersTopic D: Create a Parameterized Top N Report
6 - Enhancing a Report
Topic A: Format a ReportTopic B: Insert Objects in a ReportTopic C: Suppress Report SectionsTopic D: Use Report Templates
7 - Creating a Report from Excel Data
Topic A: Create a Report Based on Excel DataTopic B: Modify a Report Generated from Excel DataTopic C: Update Data in a Report Based on Excel Data
8 - Distributing Data
Topic A: Export DataTopic B: Create Mailing Labels
9 - Appendix
Appendix A: Setting Up and Configuring Data SourcesAppendix B: Using Report Processing TechniquesAppendix C: Using Functions in Formulas
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
Target Audience
This course is designed for people who need output from a database. In some cases, database programs have limited reporting tools, or tools that are not accessible. Learners may or may not have programming or SQL experience.
Prerequisites
Other Prerequisites
Before taking this course, learners should be familiar with basic computer functions, such as creating and navigating folders, opening programs, manipulating windows, copying and pasting objects, formatting text, and saving files in Microsoft® Windows®. In addition, learners should have taken the Microsoft® Office Access® 2016: Level 1 course or have equivalent experience with basic database concepts.