Tel: UK 0845 757 3888 | Ireland: 01 284 6796
Crystal Reports V11 Introduction
Course type Specialist (What does this mean?)
| Course title | Crystal Reports V11 Intro |
|---|---|
| Delivery method |  Classroom |
| RRP | £750 exc. VAT |
| Days/Duration | 2 |
| Code | DCRV11B |
Secure online payment
- view dates / book course
- course description
- blogs
Course dates
| Location | May | Jun | Jul | Aug | view later dates |
|---|---|---|---|---|---|
| Location | Sep | Oct | Nov | Dec | view earlier dates |
London
King William Street, EC4 |- |- |4 |20 
Location Sep Oct Nov Dec view earlier dates King William Street, EC4 |6 |9 |8 |13 King William Street, EC4location information and directions
04 Jul 5 or more places available £750 exc VAT 20 Aug 5 or more places available £750 exc VAT 06 Sep 5 or more places available £750 exc VAT 09 Oct 5 or more places available £750 exc VAT 08 Nov 5 or more places available £750 exc VAT 13 Dec 5 or more places available £750 exc VAT Crystal Reports V11 Introduction training in King William Street, EC4
Midlands
Birmingham |- |- |- |30 Location Sep Oct Nov Dec view earlier dates Birmingham |- |- |1 |- Birminghamlocation information and directions
30 Aug 5 or more places available £750 exc VAT 01 Nov 5 or more places available £750 exc VAT Crystal Reports V11 Introduction training in Birmingham
North
Manchester |- |- |23 |- Location Sep Oct Nov Dec view earlier dates Manchester |- |- |5 |- Manchesterlocation information and directions
23 Jul 5 or more places available £750 exc VAT 05 Nov 5 or more places available £750 exc VAT Crystal Reports V11 Introduction training in Manchester
Leeds, City Centre |- |20 |- |- Location Sep Oct Nov Dec view earlier dates Leeds, City Centre |- |9 |- |- Leeds, City Centrelocation information and directions
20 Jun fewer than 5 places available £750 exc VAT 09 Oct 5 or more places available £750 exc VAT Crystal Reports V11 Introduction training in Leeds, City Centre
Scotland
Edinburgh |- |13 |- |- Location Sep Oct Nov Dec view earlier dates Edinburgh |- |- |27 |- Edinburghlocation information and directions
13 Jun fewer than 5 places available £750 exc VAT 27 Nov 5 or more places available £750 exc VAT Crystal Reports V11 Introduction training in Edinburgh
Glasgow |- |- |17 |- Location Sep Oct Nov Dec view earlier dates Glasgow |27 |- |15 |- Glasgowlocation information and directions
17 Jul 5 or more places available £750 exc VAT 27 Sep 5 or more places available £750 exc VAT 15 Nov 5 or more places available £750 exc VAT Crystal Reports V11 Introduction training in Glasgow
Overview
Crystal Reports XI: 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.
Prerequisites
- Use a mouse
- Type and use a keyboard
- Navigate through Windows, organise folders and files
- Work with Windows – Minimise, Maximise, Open, Close
- A basic understanding of database principles, including: Relationships between tables; Joins and Primary Keys; Experience of using data manipulation software, such as Microsoft Access or Microsoft Excel
- Prior knowledge of SQL is desirable, but not essential
Delegates will learn how to
- Create a report by using data from an existing database
- Use a report to present specific data in the desired order
- Create groups to summarise report data
- Build formulas to calculate and display data
- Format reports
- Add and modify elements in a report
- Create single data series charts
- Distribute report data
Course Outline
Lesson 1: Creating a Report
- Topic 1A: Set Default Report Settings
- Topic 1B: Specify Fields for a New Report
- Topic 1C: Preview a Report
- Topic 1D: Modify Field Display
- Topic 1E: Add a Report Title
- Topic 1F: Position Fields
- Topic 1G: Add Fields from Other Tables
Lesson 2: Displaying Specific Report Data
- Topic 2A: Find Data
- Topic 2B: Sort Data
- Topic 2C: Filter Data by a Single Criterion
Lesson 3: Grouping Report Data
- Topic 3A: Insert a Group
- Topic 3B: Add Summaries
- Topic 3C: Format Summary Information
- Topic 3D: Change Group Options
- Topic 3E: Add a Second-Level Grouping
- Topic 3F: Filter Records by Group
- Topic 3G: Create a Top N Sort Group
Lesson 4: Building Formulas
- Topic 4A: Create a Formula
- Topic 4B: Edit a Formula
- Topic 4C: Combine Fields by Formula
- Topic 4D: Delete a Formula
- Topic 4E: Filter Data by Multiple Criteria
- Topic 4F: Modify a Filter Using an OR Operator
- Topic 4G: Create a Parameter Field
- Topic 4H: Account for Null Fields in a Formula
Lesson 5: Formatting Reports
- Topic 5A: Remove White Space
- Topic 5B: Insert Page Header/Footer Data
- Topic 5C: Add Borders, Boxes, and Lines
- Topic 5D: Change Field Background Color
- Topic 5E: Change the Margins
Lesson 6: Enhancing Reports
- Topic 6A: Add a Watermark
- Topic 6B: Insert Objects Using Object Linking and Embedding
- Topic 6C: Modify Formatting Based on Data Value
- Topic 6D: Suppress Report Sections
- Topic 6E: Insert Hyperlinks
- Topic 6F: Hide Blank Report Sections
Lesson 7: Creating Pie Charts
- Topic 7A: Create a Pie Chart with a Drill-Down
- Topic 7B: Modify Chart Text
- Topic 7C: Format a Chart
- Topic 7D: Present a Chart by Group
Lesson 8: Distributing Data
- Topic 8A: Export to a PDF File
- Topic 8B: Export to a Microsoft Excel File
- Topic 8C: Export to an Access Database File
- Topic 8D: Export a Report Definition
- Topic 8E: Create Mailing Labels
Related blogs
Do a better Disk Cleanup as Administrator
Posted by Andrew Mallett on 14 May 2012
Many of us will know the Windows 7 Disk Cleanup feature but how many of us miss some features by not running as an administrator?
I know the name but what is the printer driver
Posted by Andrew Mallett on 09 May 2012
SUPPORT: “Which printer is it?” USER: “Darth Vader” Of course naming your printers other than by the print driver is useful and more fun for you users but does not really help you identify the printer. See how PowerShell can help you out....
what are you wearing
Posted by Bob Simms on 03 May 2012
Data mining and its use in business, or how to stop those annoying phone calls
What are your time stealers?
Posted by Jennie Marshall on 02 May 2012
I frequently facilitate learning sessions on time management, and one common theme for many, in this age of higher expectations on staff, is increased work load. But is it really more work that’s affecting our ability to be productive, or are we experiencing more ‘time stealers’ than we used to.
Windows : Open a command window to a directory
Posted by Andrew Mallett on 01 May 2012
Some things in both life and IT are simple and this is one of those items. Have you ever wanted to open the command window to a folder that you have navigated to with Windows Explorer? Read on help is at hand.
