Crystal Reports XI - Level 2 Professional Training Solutions Ltd

Crystal Reports XI - Level 2

Professional Training Solutions Ltd

Price: TBA

Location: Westland Square Pearse St Dublin 2 Ireland
Duration: 2 Days

Course details

Now that you have completed the first course, or are familiar with the basics of building and modifying reports, you`re ready to move ahead to create complex reports and data sources using Crystal Reports` tools. In this course, you`ll not only learn how to create more sophisticated reports including subreports and cross-tabs, but you`ll also learn how to increase the speed and efficiency of your reports by using SQL queries

Prerequisites:

Crystal Reports XI: Level 1, and knowledge of programming and/or SQL would be helpful

Creating Running Totals :

Create a Running Total Field
Modify a Running Total Field
Create a Manual Running Total on Detail Data
Create a Manual Running Total on Summary Data

Building Cross-tabs in Your Report :

Create a Cross-tab
Create a Specified Group Order
Filter a Cross-tab by Group
Change the Cross-tab Format
Conditionally Format Rows and Columns
Keep Groups Together

Adding Subreports :

Insert a Subreport
Link a Subreport to a Primary Report
Edit a Subreport`s Structure
Format a Subreport Using the Format Editor
Share Variables Between Subreports and Primary Reports
Create an On-demand Subreport

Creating Drill-downs :

Create a Drill-down
Create Separate Headings for Drill-down Data

Enhancing Report Processing by Writing SQL Statements :

Create a Report Using SQL Queries
Summarize Report Data Using SQL Aggregate Functions
Create Joins Using SQL
Create Subqueries
Create a SQL Expression Field

Charting Data :

Create a Bar Chart
Modify a Chart
Format a Chart
Create a Chart Template
Create a Top N Chart
Create a Cross-tab Chart

Reporting on Excel Data with Crystal Reports :

Create a Report Based on Excel Data
Modify a Report Generated from Excel Data
Update Data in a Report Based on Excel Data

Working with Prompts :

Create a Static Prompt
Create a Dynamic Prompt

Enhancing Report Functionality :

Group Data Hierarchically
Create a Dynamic Image
Create a Report Alert
Create a Geographic Map

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 IT and Computing 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.