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.
Class goals :
After completing this course, students should be able to:
Create automatic and manual running totals
Work with cross-tab reports
Add subreports
Create drill-downs in a report
Use SQL statements in report processing
Create complex formulas
Add charts to reports
Enhance report functionality
Content of
Lesson 1: Creating Running Totals
Lesson 2: Working with Cross-Tabs
Lesson 3: Adding Subreports
Lesson 4: Creating Drill-Downs in a Report
Lesson 5: Using SQL Statements in Report Processing
Lesson 6: Creating Complex Formulas
Lesson 7: Adding Charts to Reports
Lesson 8: Enhancing Report Functionality
Appendix A: Managing Reports
Appendix B: Processing Data on the Server
Appendix C: Detecting and Fixing Problems
Training Crystal Reports 2008 Level 2
Onze voordelen :
Type of training: Inter-company, intra-company and individual
100% flexible & personalised training : You choose the place, the dates and the training program
Offer request : Response within 24 hours
50% discount for SME’s from Brussels-Capital Region
Free parking, lunch & drinks
Free use of our Digital Competence Centre: Manuals, courses, exercises, …
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.
Class goals :
After completing this course, students should be able to:
Create running totals in a report
Build cross-tabs in your report
Add subreports to a report
Design a report that uses a drill-down
Improve processing speed in your reports
Chart single and multiple data series
Report from Excel data
Implement report prompts
Enhance report functionality
Content of Crystal Reports Version 11 Advanced
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
Training Crystal Reports Version 11 Advanced
Onze voordelen :
Type of training: Inter-company, intra-company and individual
100% flexible & personalised training : You choose the place, the dates and the training program
Offer request : Response within 24 hours
50% discount for SME’s from Brussels-Capital Region
Free parking, lunch & drinks
Free use of our Digital Competence Centre: Manuals, courses, exercises, …
This 3 day instructor-led course provides students with an understanding of Active Directory technology in Windows Server 2008 (code name ‘Longhorn’). This course is intended to allow individuals who already have experience with Applications Platform technologies to upgrade their skills for Windows Server 2008.
Class goals :
On completion of this training course, delegates should be able to:
Configure and use Windows Server as an application server with new Server Roles
Use new features in IIS 7.0 Application Server, including the new modular configuration system
Manage Web Applications with IIS 7.0
Troubleshoot IIS 7.0-based Web servers with automatic failed request tracing and other included features and tools
Plan for Windows SharePoint Services 3.0 implementation in a variety of network environments
Configure and manage Windows SharePoint Services 3.0 from initial setup through troubleshooting and day-to-day operation
Use new features in Terminal Services and describe Terminal Services Licensing
Use and manage Terminal Services remote programs and gateways, including troubleshooting and performance optimization
Content of Updating your Application Platform Technology Skills to Windows Server 2008
Server Roles and Initial Configuration Tasks
This module introduces Application Server Roles, describing Application Server features in Windows Server and demonstrating initial configuration and Unix interoperability.
Overview of IIS 7.0 Application Server
This module introduces IIS 7.0 modular architecture, in which more than 40 features can be independently installed. It also demonstrates new scripting interface features and distributed configuration files.
Managing Web Applications with IIS 7.0
This module covers several aspects of server management in IIS 7.0. IIS can be configured using the IIS Manager graphical user interface or using several configuration files. It also explores the appcmd.exe command line utility as it is used for server administration.
Troubleshooting Web Servers
This module describes and demonstrates IIS 7.0 features for troubleshooting, including Runtime Control and Status API, Automatic Failed Request Tracing, and Trace Events.
Introduction to the Windows SharePoint Services 3.0 Platform
This module describes and demonstrates Windows SharePoint Service 3.0, including planning for implementation and performing a new installation.
Configuring and Managing Windows SharePoint Services 3.0
This module describes and demonstrates how to configure and manage Windows SharePoint Services 3.0, including creating and configuring sites and managing sites and servers.
Configuring Terminal Services
Terminal Services has been updated with Windows Server 2008, including changes to Terminal Services core. This module covers the new Terminal Services core functionality as well as Terminal Services Web Access and Terminal Services Licensing.
Managing Terminal Services
With Windows Server 2008 Remote Programs are accessed remotely through Terminal Services. Terminal Services Gateway can be used to help secure access to Remote Programs. This module describes and demonstrates using Terminal Services management consoles and Event Viewer as well as using Terminal Services with Windows System Resource Manager to optimize performance.
Training Updating your Application Platform Technology Skills to Windows Server 2008
Onze voordelen :
Type of training: Inter-company, intra-company and individual
100% flexible & personalised training : You choose the place, the dates and the training program
Offer request : Response within 24 hours
50% discount for SME’s from Brussels-Capital Region
Free parking, lunch & drinks
Free use of our Digital Competence Centre: Manuals, courses, exercises, …
This fast-paced, extended-hour, lab-intensive course includes the content of the VMware vSphere: Manage for Performance and VMware vSphere: Troubleshooting courses.
This course provides the knowledge and skills necessary to make fundamental design decisions that enhance performance and meet performance goals in a deployed VMware vSphere installation.
Class goals :
At the end of the course, you will be able to do the following:
Use vSphere tools to monitor the performance of VMware ESX/ESXi hosts
Diagnose performance problems relating to CPU, memory, network, and storage on an ESX/ESXi host
Apply guidelines for monitoring application performance
Use the VMware vSphere Client and command-line utilities to diagnose and rectify ESX/ESXi, VMware vMotion, VMware Storage vMotion, VMware High Availability, VMware Distributed Resource Scheduler, and virtual machine power-on problems
Use ESXi technical support mode to diagnose and rectify problems on ESXi
Create and use a network packet capture utility to capture and display virtual switch network traffic
Content of VMware vSphere 4 : Advanced Fast Track
Course Introduction
Introductions and course logistics
Course objectives
Performance in a Virtualized Environment
Discuss the vSphere performance troubleshooting methodology
Discuss software and hardware virtualization techniques and their impact on performance
Monitor performance using vCenter Server performance charts and the ESX/ESXi resxtop command
CPU Performance
Discuss the CPU scheduler and other features that have an impact on CPU performance
Monitor key CPU performance metrics
Troubleshoot common CPU performance problems
Memory Performance
Discuss memory reclamation techniques and memory overcommitment
Monitor key memory performance metrics
Troubleshoot common memory performance problems
Guidelines for DRS and Resource Controls
Discuss performance guidelines for DRS clusters, resource pools, and resource allocation settings
Network Performance
Discuss the performance features of modern network adapters
Monitor key network performance metrics
Troubleshoot common network performance problems
Storage Performance
Discuss how storage protocols, VMware vStorage VMFS configuration, load balancing, and queuing affect performance
Monitor key storage performance metrics
Troubleshoot common storage performance problems
Virtual Machine Performance
Discuss guidelines for configuring a virtual machine for optimal performance
Application Performance
Discuss tools and guidelines for application performance
Guidelines for DRS and Resource Controls
Discuss performance guidelines for DRS clusters, resource pools, and
Course Introduction
Introductions and course logistics
Course objectives
ESXi Command-Line Troubleshooting Methods
Install and use the VMware vSphere Management Assistant
Learn common vSphere command-line interface commands and syntax
Configure ESXi technical support mode and Secure Shell (SSH) access
ESX, ESXi, and vCenter Server Log Files
View ESX, ESXi, and vCenter Server log files
Configure a centralized ESX/ESXi log host
Network Troubleshooting
Identify and configure vNetwork components
Configure and use a network traffic packet capture utility
Management Troubleshooting
Troubleshoot vSphere management components
Storage Troubleshooting
View, configure, and diagnose storage-access problems
Configure iSCSI authentication and digests
vMotion Troubleshooting
Troubleshoot vMotion and Storage vMotion errors
VMware Infrastructure Troubleshooting
Troubleshoot DRS cluster errors with shares, pools, and limits
Troubleshoot VMware HA cluster errors with slot calculations, admission control, and host monitoring
Review virtual machine power-on requirements
Troubleshoot virtual machine power-on failures
Training VMware VSphere 4
Onze voordelen :
Type of training: Inter-company, intra-company and individual
100% flexible & personalised training : You choose the place, the dates and the training program
Offer request : Response within 24 hours
50% discount for SME’s from Brussels-Capital Region
Free parking, lunch & drinks
Free use of our Digital Competence Centre: Manuals, courses, exercises, …
In this Adobe After Effects training course, students new to After Effects CC will learn to create motion graphics and visual effects. It is packed with hands-on exercises so that students can learn by doing.
Class goals :
Get familiar with the After Effects CC work area.
Learn to create and understand Comps.
Learn to work with Keyframes.
Learn Layers, Effects, and Modes.
Learn to work with Masks and Mattes.
Learn to import and edit text.
Learn about type.
Learn to work with music in your animation.
Content of Training After Effects CC / Introduction
Course Description A good Oracle database administrator must gain and maintain a mastery of his or her environment, its physical structures, and its maintenance routines. An administrator must understand the data being stored well enough to tune and improve performance, to anticipate and prevent data failure, and to recover lost data should a failure occur. In this course, you will develop an advanced understanding of complex Oracle database concepts, maintenance and recovery routines, and database management. You have an Oracle installation and need to broaden your knowledge of advanced Oracle administrative functionality so that you can maintain the healthiest possible database.
Class goals :
learn how to control and manage an Oracle installation.
Content of Oracle DB Administration II
This course is intended for Oracle Database 10g Administrators, Sales Consultants, Support Engineers, Oracle Software Developers and Technical Consultants. Students should have some knowledge of Oracle database utilities, architecture, and terminology, including some experience with SQL*Plus, iSQL*Plus, and PL/SQL.
Training Oracle DB Administration II
Onze voordelen :
Type of training: Inter-company, intra-company and individual
100% flexible & personalised training : You choose the place, the dates and the training program
Offer request : Response within 24 hours
50% discount for SME’s from Brussels-Capital Region
Free parking, lunch & drinks
Free use of our Digital Competence Centre: Manuals, courses, exercises, …
Course Description A good Oracle database administrator must gain and maintain a mastery of his or her environment, its physical structures, and its maintenance routines. An administrator must understand the data being stored well enough to tune and improve performance, to anticipate and prevent data failure, and to recover lost data should a failure occur. In this course, you will develop an advanced understanding of complex Oracle database concepts, maintenance and recovery routines, and database management. You have an Oracle installation and need to broaden your knowledge of advanced Oracle administrative functionality so that you can maintain the healthiest possible database.
Training-brussels - business training center in Brussels 