Crystal Reports XI Level 1

Hilton Computer Strategies
Houston, Texas, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Crystal Reports 11: 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 10 series. In this course, you will build basic list and group reports that work with almost any database.



Audience

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.



At Course Completion

After completing this course, students will be able to:

� Create a report by using data from an existing database.

� Locate and present data in a specified order.

� Create groups to summarize report data.

� Build formulas to add non-database data to a report and display data differently.

� Format reports.

� Enhance reports by adding and modifying elements in a report.

� Create single data series charts.

� Distribute report data to other users


Prerequisites

Before taking this course, students should be familiar with the basic functions of their computer’s operating system such as creating folders, opening programs, and working with windows. Students should have basic Windows application skills, such as copying and pasting objects, formatting text, saving files, etc. Students should have a basic understanding of database concepts.



Course Materials

The student kit includes a comprehensive workbook and other necessary materials for this class



Course Outline

Lesson 1: Creating a Report

� Set Default Report Settings

� Specify Fields for a New Report

� Preview the Report

� Modify Field Display

� Add a Report Title

� Position Fields

� Add Fields from Additional Tables



Lesson 2: Displaying Specific Report Data

� Find Data

� Sort Data

� Filter Data by Single Criteria



Lesson 3: Grouping Report Data

� Insert a Group

� Add Summaries

� Format Summary Information

� Change Group Options

� Add an Additional Group

� Filter by Group

� Create a Top N Sort Group



Lesson 4: Building Formulas

� Write a Formula

� Edit a Formula

� Group by Formula

� Delete a Formula

� Build a Filter by Multiple Criteria

� Modify a Filter with Multiple Criteria to Create an OR Condition

� Create a Parameter Field

� Write a Formula that Incorporates Null Fields



Lesson 5: Formatting Reports

� Remove White Space

� Insert Page Header/Footer Data

� Add Borders and Lines

� Change the Background Color

� Change the Margins



Lesson 6: Enhancing Reports

� Create a Section to Contain a Watermark

� Insert Objects Using Object Linking and Embedding

� Modify Format Based on Data Value

� Conditionally Suppress Data

� Insert Hyperlinks

� Hide Blank Report Sections



Lesson 7: Creating and Modifying Pie Charts

� Create a Pie Chart with a Drill-down

� Modify Chart Text

� Format a Chart

� Present a Chart by Group



Lesson 8: Distributing Data

� Export to PDF

� Export to Excel

� Export to an Access Database

� Create a Report Definition

� Create Mailing Labels



Appendix A: Setting File Locations

...''

Phone:1-800-324-7415

School Address:

Hilton Computer Strategies, 6001 Savoy, Suite 207, Houston, TX 77036 USA

Jobs & Resumes: Houston
Houses & Roommates: Houston

ASP .NET AJAX Using C#
Asynchronous JavaScript and XML
Visual Studio 2008: ASP.NET 3.5
Visual Studio 2008: ADO.NET 3.5
Windows Workflow Foundation Using Visual C# 2005
Windows Workflow Foundation Using Visual Basic 2005
A+ Essentials
A+ Remote Support Technician
Developing Business Process and Integration Solutions using Microsoft Biztalk Server 2006
Business Analysis For the IT Professional
Crystal Reports XI Level 2
Implementing and Managing Microsoft Exchange Server 2003
Installing and Maintaining Exchange Server 2007
Managing Messaging Security with Microsoft Exchange Server 2007
Recovering Messaging Services and database with Microsoft Exchange Server 2007
Monitoring and Troubleshooting Exchange Server 2007
High Availability Messaging Solution using Microsoft Exchange Server 2007
IIS 6.0
ITSM Practitioner Certification: Agree and Define

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Schools can use this unlimited free web marketing service by submitting their course descriptions and school introductions. Two outbound links will be granted to each posting.