Crystal Reports 2008: Level 2

Name: Crystal Reports 2008: Level 2
Availability: InStock
Rating: 1 (1 reviews)

Professional Training Solutions Ltd

Add to wishlist

Price: TBA

Location: Westland Square Pearse St Dublin 2 Ireland
Duration: 2 Days
Call: +971 4 5490356

Course details

Until now, you have used Crystal Reports to build and modify reports. You want to use the advanced functionality of Crystal Reports to generate reports in the format you desire. In this course, you will create complex reports and data sources using Crystal Reports` tools. You will not only create more sophisticated reports including subreports and cross-tabs, but you will also increase the speed and efficiency of your reports by using SQL queries.

Prerequisites:

Crystal Reports 2008: Level 1. A knowledge of programming and/or SQL would also be helpful.

Creating Running Totals:

Create a Running Total Field
Modify a Running Total Field
Create a Manual Running Total

Working with Cross-Tabs :

Create a Cross-Tab Report
Format a Cross-Tab Report
Create Groups in Cross-Tab Reports

Adding Subreports :

Insert a Subreport
Edit a Subreport
Share Variables
Creating Drill-Downs in a Report:
Create a Drill-Down
Create Headings for Drill-Down Data

Using SQL Statements in Report Processing :

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

Creating Complex Formulas :

Work with Loops
Work with Arrays

Adding Charts to Reports :

Create Charts
Create a Chart with a Drill-Down
Create a Top N Chart
Create a Cross-Tab Chart
Create Charts for Grouped Data
Format a Chart
Create a Chart Template

Enhancing Report Functionality :

Organize Data Based on a Hierarchy
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 SQL Server online courses See all SQL Server Courses

See all current SQL Server jobs in UAE