Crystal Reports

Days 2    Code CR   Fee £980

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

Request a Call Back

WebCrystal Reports