Duration: 2 Days
Software Assurance Value:
Level 1 is the primary recommended course you should take if your job responsibilities require you to obtain output from databases. It is also the first course in the Crystal Reports XI series. In this course, you will build basic list and group reports that work with almost any database. Course Objective: You will build basic list and group reports that work with almost any database.
Upon successful completion of this course, students will be able to:
Module 1: Creating a ReportTopic 1A: Set Default Report SettingsTopic 1B: Specify Fields for a New ReportTopic 1C: Preview a ReportTopic 1D: Modify Field DisplayTopic 1E: Add a Report TitleTopic 1F: Position FieldsTopic 1G: Add Fields from Other TablesModule 2: Displaying Specific Report DataTopic 2A: Find DataTopic 2B: Sort DataTopic 2C: Filter Data by a Single CriterionModule 3: Grouping Report DataTopic 3A: Insert a GroupTopic 3B: Add SummariesTopic 3C: Format Summary InformationTopic 3D: Change Group OptionsTopic 3E: Add a Second-Level GroupingTopic 3F: Filter Records by GroupTopic 3G: Create a Top N Sort GroupModule 4: Building FormulasTopic 4A: Create a FormulaTopic 4B: Edit a FormulaTopic 4C: Combine Fields by FormulaTopic 4D: Delete a FormulaTopic 4E: Filter Data by Multiple CriteriaTopic 4F: Modify a Filter Using an OR OperatorTopic 4G: Create a Parameter FieldTopic 4H: Account for Null Fields in a FormulaModule 5: Formatting ReportsTopic 5A: Remove White SpaceTopic 5B: Insert Page Header/Footer DataTopic 5C: Add Borders, Boxes, and LinesTopic 5D: Change Field Background ColorTopic 5E: Change the MarginsModule 6: Enhancing ReportsTopic 6A: Add a WatermarkTopic 6B: Insert Objects Using Object Linking and EmbeddingTopic 6C: Modify Formatting Based on Data ValueTopic 6D: Suppress Report SectionsTopic 6E: Insert HyperlinksTopic 6F: Hide Blank Report SectionsModule 7: Creating Pie ChartsTopic 7A: Create a Pie Chart with a Drill-DownTopic 7B: Modify Chart TextTopic 7C: Format a ChartTopic 7D: Present a Chart by GroupModule 8: Distributing DataTopic 8A: Export to a PDF FileTopic 8B: Export to a Microsoft Excel FileTopic 8C: Export to an Access Database FileTopic 8D: Export a Report DefinitionTopic 8E: Create Mailing Labels
Before taking this course, students should be familiar with the basic functions of Windows, such as creating and navigating folders, opening programs, manipulating windows, copying and pasting objects, formatting text, and saving files. In addition, students should have taken Microsoft® Office Access 2003: Level 1 or have equivalent experience with basic database concepts.