Crystal Reports 8.5 - Advanced Professional Training Solutions Ltd

Crystal Reports 8.5 - Advanced

Professional Training Solutions Ltd

Price: TBA

Location: Westland Square Pearse St Dublin 2 Ireland
Duration: 1 Day

Course details

Crystal Reports 8.5 Advanced is a hands-on instruction book that will introduce you to the some of the advanced features within Crystal Reports. You will use variables and multiple statements in formulas, create and use parameter fields, develop conditional format statements and work with multiple sections.

Prerequisites:

This course is designed for users with a basic knowledge of Crystal Reports but who require the use of advanced formulas and formatting, need to access information that is not PC-based, or need to set up reports that other users will access and run. Although no database experience is necessary, some of the concepts may be more meaningful if the user has worked with database applications before. A basic knowledge of relational data concepts is also recommended.

Review Exercises:

Creating a Basic Report
Adding and Linking Databases to a Report
Selecting, Grouping, and Summarizing
Creating Formulas
Formatting Sections for Summary/Drill-Down

Conditional Formatting:

Absolute versus Conditional Formatting
On/Off Formatting
Conditional Attribute Formatting
The Highlighting Expert
Restoring Conditional Formats

Advanced Formulas:

Using Variables in Formulas
Creating a Running Total
Understanding Multiple-pass Reporting
Using Evaluation Time Functions
Creating Formulas Using Multiple Variables

Multiple Sections:

Inserting Sections
Moving Sections
Splitting Sections
Multiple Sections and Conditional Formats

Parameter Fields:

Creating Parameter Fields
Using Pick Lists
Using Parameter Fields in Record Selection
Using Edit Masks
Using Parameter Fields to Set Sort Criteria
Using the Like Statement
Setting Conditional Formats Using ParameterFields

Using Report Alerts:

What are Report Alerts
Creating Report Alerts
Modifying Report Alerts
Deleting Report Alerts

Advanced Cross-tabs:

Inserting Multiple Rows, Columns, and SummarizedFields
Editing a Cross-tab
Using Formula Fields in a Cross-tab
Using Parameters in Cross-tabs
Creating a Cross-tab Object for Each Group Value

Subreports:

Identifying Subreport Features
Inserting Unlinked Subreports
Formatting Subreports
Inserting Linked Subreport
Using On-demand Subreports

SQL/ODBC and Crystal SQL Designer:

Introducing Structured Query Language (SQL)
Introducing ODBC Data Sources
Introducing the Crystal SQL Designer
Using a Query to Create a Report

Crystal Dictionaries:

Defining Dictionaries
Using Existing Dictionaries
Creating Dictionaries
Enhancing Your Dictionary
Modifying a Dictionary

Graphing:

Using Chart Types and Layouts
Using the Chart Expert to CreateGraphs
Modifying Existing Charts with the Chart Editor
Formatting Charts

Updated on 08 November, 2015

Course Location

Show map Location Westland Square Pearse St Dublin 2 Ireland

About Professional Training Solutions Ltd

Professional Training is a group of experienced specialists providing specific training and consultancy solutions, within Management Skills, I.T. systems, Human Restheirce Development, Credit Management, Sales, Finance and Engineering.

they believe in using a combination of tailored, flexible approaches and real-life business knowledge to develop and provide techniques and solutions for immediate implementation.

their recent projects include supporting major initiatives for clients in utilities, telecoms, manufacturing and software, covering:

restructuring for competitiveness

productivity improvements through updating work processes to match new technology

managing outstheircing

strategic financial planning and engineering

their methodology is to:

Work closely with clients to understand and help them prioritise their needs

Design and deliver the best mix of training activities and consultancy to establish the competencies required

Provide ongoing coaching to sustain the improved practices and processes

they create relevant, targeted, enjoyable, and interactive, training sessions which are designed to improve the retention of information by participants and create a clear link from the training to the workplace. This creates a planned, visible improvement in key business indicators such as productivity, motivation, loyalty, employee retention, and ultimately, profit.

their collaborative approach builds long-term relationships with clients. Together, they can deal effectively with the inevitable challenges all businesses face.

See all Professional Training Solutions Ltd courses

View more Virtual classroom training for IT, Computing and Technology online courses View more similar courses

See all current Media and Creative jobs in Ireland

Are you from Professional Training Solutions Ltd ? Claim your course!

Courses you can instantly connect with... Do an online course on IT, Computing and Technology starting now.