Crystal Reports
Days 2 Code CR
Crystal Reports is the primary recommended course you should take if your job responsibilities require you to obtain output from databases.
Course Details
Crystal Reports is the primary recommended course you should take if your job responsibilities require you to obtain output from databases.
Crystal Reports is the primary recommended course you should take if your job responsibilities require you to obtain output from databases. In this course, you will start off building basic list and group reports that work with almost any database. 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.
You will also learn how to create more sophisticated reports like subreports, cross-tabs, drill-downs and parameter reports .You’ll also learn how to increase the speed and efficiency of your reports by using server side SQL queries.
Prerequisites
Before attending this course, students must have:
-
Knowledge of programming and/or SQL.
Examination
There are no examinations associated with this course
Course Outline
-
Creating a Report
Crystal Reports Window
Field Types
Specify Fields For a New Report
Previewing the Report
Modifying Field Display
Positioning Fields
Adding Fields From Additional Tables -
Grouping Report Data
Inserting a Group by
Adding Group Summaries
Formatting Summary Data
Changing an Existing Group
Adding a Second Group
Filtering Groups
Creating a Top N Sort -
Formatting Reports
Removing White Spaces
Page Headers and Footers
Adding Borders, Boxes and Lines
Changing the Field Background Colour
Altering the Margins -
Creating Pie Charts
Create a Pie Chart Drill-down
Modifying Chart text
Formatting a Chart
Charting by Group -
Creating a Running Total
Creating a Running Total Field
Modifying a Running Total
Suppressing the Running Total
Resetting the Running Total -
Adding Subreports
Inserting a Subreport
Linking a Subreport to a Primary Report
Editing a Subreport
Formatting a Subreport Object
Creating an On-demand Subreport -
Creating Prompts
Creating a Static Prompt with Dates
Creating a Dynamic Prompt -
Advanced Charting
Creating a Bar Chart
Modifying a Chart
Formatting a Chart
Creating a Chart Template
Creating a Top N Chart
-
Finding, Sorting and Filtering Data
Finding Data in an Existing Report
Sorting Data
Filtering Data -
Using Formulas
Creating Formulas
Editing an Existing Formula
Combining Fields by Formula
Filtering Data Using Multiple Criteria
Modifying a Filter To Include an OR Operator
Creating a Parameter Field
Using a Formula To Account for Null Values -
Enhancing Reports
Adding Watermarks
Object Linking and Embedding
Using the Highlight Expert
Suppressing Report Sections
Inserting Hyperlinks
Hiding Blank Sections -
Exporting Data
Exporting To PDF
Exporting To Excel
Exporting To Access
Exporting a Report Definition
Creating Labels -
Creating Cross-Tab Reports
Planning a Cross-tab Report
Creating a Cross-tab Report
Creating a Specified Group Order
Filtering a Cross-tab by Group
Changing The Cross-tab Format
Conditionally Formatting Rows and Columns
Keeping Groups Together -
Creating Drill-downs
Creating Drill-downs
Creating Separate Headings for Drill-down Data -
Writing Basic SQL Statements
Creating a Report Using SQL Queries
Summarising Reports Using SQL Aggregate Functions
Creating Joins Using SQL
Specifying the Join Type