Crystal Reports Level II

Computer Training Unit, North Carolina State University
Raleigh, North Carolina, United States

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

Course Description:

'' In this course you will build reports with advanced formulas, running totals, subreports, cross-tabs and charts. You will also create specified group orders and build report foundations using Crystal SQL queries, SQL commands and dictionaries, exploring the strengths and weaknesses of those tools.

Suggested Prerequisites: Crystal Reports 9 Level I

Attend and You Will Learn
Lesson 1: CREATING RUNNING TOTALS
Create a running total field

without variables

Modify existing running total fields

Create manual running totals on

detail data

Create manual running totals on

grouped summary data Lesson 2: BUILDING CROSS-TABS IN YOUR REPORT
Create a cross-tab

Create a specified group order

Filter cross-tabs by group

Change cross-tab formatting options

Work with conditional formatting

in rows and columns Lesson 3: ADDING SUBREPORTS
Understand the purpose and

benefit of subreports

Insert an unlinked subreport

Link a subreport to data in

a primary report

Edit subreports

Modify subreport formatting options

Share formulas between main

and subreports

Create on-demand subreports Lesson 4: IMPROVING REPORT PROCESSING SPEED
Create a SQL Expression

Enable Server Processing

Create and edit SQL Queries

Build a report on a SQL Query

Create SQL Commands in the

Crystal Report environment Lesson 5: BUILDING DICTIONARIES & MORE ON SQL COMMANDS
Create a dictionary

Organize the view of data in

a dictionary

Adding graphics to a dictionary

Build a report on a dictionary

(Optional) Create SQL Commands as an

alternative to dictionaries Lesson 6: CHARTING DATA & REPORTING ON EXCEL DATA
Create and modify charts

Create a chart that displays Top N data

Format a chart

Create a chart template

Setup and modify a data source

in Excel through Crystal Reports

View updated Excel data through

Crystal Reports ...''

Phone:919.515.8163

School Address:

Computer Training Unit
NC State University
McKimmon Center
1101 Gorman Street
Raleigh, NC 27606 USA

Jobs & Resumes: Raleigh
Houses & Roommates: Raleigh

Word 2007
Excel Programming
Excel Macros
Excel
Access Application Development
Access Boot Camp
Access Basic Programming
Crystal Reports Level I
Microsoft Project
Relational Database
Visio
Acrobat
AutoCAD
Illustrator
InDesign
PageMaker
Photoshop

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.
 

Facts: We serve the schools and students around the world. Major visitors come from India, United States, United Kingdom, Canada, Australia, Philippines, Malaysia, Singapore and South Africa.