Crystal Reports 2008 level 1

Overview

This course is designed for people who need output from a database. In some cases, database programs have limited reporting tools, and/or such tools may not be accessible. Students may or may not have programming and/or SQL experience.

Organisations use reporting tools to access data sources and generate customised reports. Crystal Reports 2008 enhances report building and report processing techniques with a slew of features that add value to your presentation. In this course, you will create a basic report by connecting to a database and modifying its presentation.

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

• Explore the Crystal Reports interface.
• Create a basic report and modify it.
• Use formulas for filtering data.
• Build a parameterised report.
• Group report data.
• Enhance a report.
• Create a report using data sourced from an Excel database.
• Distribute data.

Course Outline.

Lesson 1: Exploring the Crystal Reports 2008 Interface

Lesson 2: Working with Reports

Lesson 3: Using Formulas in Reports

Lesson 4: Building Parameterised Reports

Lesson 5: Grouping Report Data

Lesson 6: Enhancing a Report

Lesson 7: Creating a Report from Excel Data

Lesson 8: Distributing Data

• Appendix A: Setting Up and Configuring Data Sources
• Appendix B: Using Report Processing Techniques
• Appendix C: Using Functions in Formulas

Related training courses

• Database Analysis and Design
• Effective Data Warehouse Construction
• SQL Language
• Crystal Reports 2008 Level 2
• Microsoft Excel 2007 Level 1
• Microsoft Excel 2007 Level 2
• Microsoft Excel 2007 Level 3
• Microsoft Excel 2010 Level 1
• Microsoft Excel 2010 Level 2
• Microsoft Excel 2010 Level 3
• Querying Microsoft SQLServer 2012
• Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
• Oracle Database: Introduction to SQL
• Microsoft Business Intelligence End to End with SQL Server 2008 R2 and SharePoint 2010
• Data Analysis with Microsoft SQL Report Builder (v2.0 and v3.0)
• Querying SQL Databases using T-SQL