Call Me Back

Page 1

Looking for more information?

Complete your details below and we'll call you back


Category

ICT

Course type

Business Objects

Cost per individual

£395 +VAT
Public course

Cost per course

£1,100 +VAT
Client site, max 10 individuals

Duration

2 Days

Full/Part time

Part Time

Provider

ITS SmartStyle Training

Dates and Locations

Contact us for the latest course dates.

Book course

This course is intended for users who need to design, create and analyse reports by connecting to external data sources.

Objectives:

By the end of the course users will be familiar with the Crystal Reports interface and be able to produce reports based on both ‘flat’ and ‘relational’ data sources. Users will be able to extract accurate data and summarise data using formulae and functions.

Prerequisites:

Users must be proficient with a mouse and keyboard and be able to confidently work within a Windows environment - minimise, maximise, open, close. Familiarity of either Microsoft Excel or Microsoft Access is useful, but not essential.

Download Outline (PDF)

Introducing Crystal Reports
  • What is Crystal Reports?
  • The Crystal Reports Interface
  • Working with the Field Explorer
Getting Assistance
  • Getting Help in Crystal Reports
  • Getting Started
  • Planning & Creating Reports
  • Exploring the Report Design Environment
  • Previewing & Navigating Report Pages
Modifying Reports & The Reporting Environment
  • File & Report Options
  • Page & Printer Setup
  • Placing & Positioning Controls
  • Moving, Sizing & Deleting Controls
  • Aligning Controls
  • Working with Text Objects
  • Combining Text Objects & Fields
  • Inserting Special Fields, Headers & Footers
Absolute Formatting
  • Formatting Text Objects
  • Working with Lines, Boxes & Pictures
  • Formatting Report Sections
  • Applying Themes with the Template Expert
Organising Records
  • Sorting by One/Multiple Fields
  • Finding Records
  • Filtering Records & Selection Criteria
  • Filtering Data with Parameters
  • Grouping & Summarising Data
  • Creating Running Totals
Formulae & Functions
  • Working with the Formula Workshop
  • Creating Calculations using Fields & Mathematical Operators
  • Using Crystal Functions
  • Writing an If...Then…Else… Statement
  • Combining Functions & Formulae
Conditional Formatting
  • Using the Highlighting Expert
  • Formatting Text with Conditional Statements
More on Experts
  • Adding & Deleting Report Tables
  • Multi-Table Reports & Relationships
  • Creating Cross Tab Reports
  • Mailing Labels
Distributing Data
  • Printing & Emailing Reports
  • Exporting Report Data to Other Applications

Enquire about a course

Fill in your information to apply for this course. The information you provide on this application form may be passed to funding bodies, in line with the Data Protection Act 1998, and may be shared with other training providers and possible employers for the purpose of administration, statistical and research purposes.