Course Descriptions

Course Description: BusinessObjects 6.0 Reporting (top)

Student Profile: Individuals who need to learn how to create, manage and analyze BusinessObjects reports.

Duration: 2 Days

Description: By using BusinessObjects 6.0 Reporting, we can put powerful reporting capabilities at your command. This course will bring the most powerful aspects into clear focus, so you can effectively use its tools to present and analyze information, distribute documents and reports throughout your business, and use the major reporting features of BusinessObjects with remarkable ease and proficiency. In just two days, you will gain valuable input that you can apply immediately at work. A must-attend course designed for those users who are predominately responsible for editing or creating reports for BusinessObjects end users, and recipients of corporate reports.

Prerequisites: None

Objectives: On completion of the course, participants will be able to use BusinessObjects to create useful BusinessObjects reports and share them with others.

Topics Covered:

• Getting Started with BusinessObjects 6 - This module describes how to log in to BusinessObjects, find, open and view existing documents and refresh reports contained in the documents.
  
• Report Building - This module introduces the terminology used in BusinessObjects and describes how to build and run simple queries to retrieve data through a universe.
  
• Restricting Data - This module describes how to set up query conditions. By using query conditions, you can limit the data returned from the underlying database.
  
• Manipulating Data - This module describes how to resize columns and rows in tables, change the order in which columns are displayed, add headings and logos. These skills allow you to develop the layout and presentation of your reports to make the information more accessible.
  
• Using Presentation Styles - This module describes how to present data in a report, using different presentation styles. By using tables, financial tables, crosstabs, and charts you can display data in the best format for analysis.
  
• Slice and Dice - In this module we apply functions to data projected into a block.
  
• Running Calculations - This module explains how to include running calculations in your reports. Running calculations enables you to add cumulative calculations, such as running totals to a report, alongside calculations based on rows, such as sums or averages.
  
• Variables and Alerters - This module describes how to create variables, set alerters and group values in a report. By creating a Variable, you can make calculations based on data that is in a report block. An Alerter can be used to draw attention to data when it meets certain criteria. Grouping data allows related values to be brought together.
  
• Grouping Data Using Sections - This module describes how to subgroup data projected in a block within a report. It is particularly useful when you wish to subgroup more than one block in the same report so that you can compare data.
  
• Data Synchronization - This module explains document centricity and document synchronization.
  
• Creating Templates and Styles - This module explains how to set up report templates that you can use to apply predefined styles and structure to new reports.
  
• Drilling - This module describes how to use the drill function to analyze your data. When viewing data at a high summary level, you may want to analyze the data at lower levels to identify the trends or reasons behind that data. By drilling through data, you can quickly and precisely move through data hierarchies to view details at lower levels.
  
• Sharing Data with Colleagues - This module describes how to distribute your BusinessObjects reports to colleagues who may or may not be BusinessObjects users.

Cost: $1,000.00

Course Description: Reporting with WebIntelligence 6.0 (top)

Student Profile: People who need to build, present and distribute WebIntelligence reports.

Duration: 2 Days

Description: This course shows how WebIntelligence 6 works to help present and analyze information and distribute documents and reports throughout the business.

Prerequisites: None

Objectives: How to create documents, filter data, display information in different ways, enhance report presentation, create formulas and variables, analyze data at different levels of detail, and share documents using Enterprise 6.0.

Topics Covered:

• Introduction to WebIntelligence - Provides an overview of the BusinessObjects and WebIntelligence environment.
• Viewing a Document in InfoView - Describes how to log in to WebIntelligence, view some existing documents, and logout. It also explains how to get help, search for documents and configure the start page to your exact requirements.
• Creating New Documents with Queries - Describes how to use the WebIntelligence report panels to create, edit, and run queries, as well as save and print documents. It also describes how to create and assign categories to personal documents and how to configure list options and change your password.
• Restricting Data Returned by a Query - Describes how to apply and group filters to restrict the amount of data returned from the database.
• Displaying Information in Different Ways - Describes how to use tables and charts in WebIntelligence to display information.
• Enhancing the Presentation of a Report - Describes how to present data using different presentation styles and formatting options.
• Creating Formulas and Variables - Describes how to apply functions to your report.
• Analyzing Data at a Different Level - Describes how to analyze data in your reports from different levels of detail, and how to zoom in on important trends in your business.
• Sharing Documents - Describes how to distribute your WebIntelligence documents to colleagues.

Cost: $1,000.00

Course Description: WebIntelligence 2.5/2.6 for Users (top)

Student Profile:

• Users who want to access predefined reports and also create, format, and distribute reports using WebIntelligence through an extranet or intranet.
• Thin-client user who will view, create, format, and distribute reports.
• Users who are report creators who will be sharing Business Objects reports with WebIntelligence users.

Duration: 1 Day

Description:

• Learn how WebIntelligence enables you to present information and distribute useful documents throughout your business.
  
• Master the major functionality in WebIntelligence, such as report creation, formatting, sharing, and arithmetic functions.
  
• Gain exposure to conditions, filters, drilling, report scheduling, as well as other advanced topics.
  
• Understand the different "flavors" of WebIntelligence, including full-JAVA, light-JAVA, and ActiveX.

Prerequisites: None

Objectives:

• Create, open, edit, and save WebIntelligence documents.
  
• Use filters, sorts, breaks, and calculations on queries.
  
• Adjust conditions on queries.
  
• Adjust block-formatting settings on queries.
  
• Show data in financial table form and cross-tab format.
  
• Show data in chart format.
  
• Drill up, down, and across data in a report.
  
• Print and send reports to other users.
  
• Practice distributing reports via the Business Objects repository, changing reporting styles, and formatting reports.
  

Topics Covered: How WebIntelligence and Business Objects work together to help analyze information and distribute useful documents as reports throughout the business environment. How to log into the system as a WebIntelligence user, to view existing reports, receive help, and exit. How to create, format, save, and send document to other users. Apply conditions to queries and limit the query scope when it is run against the database. Using formatting features to change the look of your reports. Creating and using table block styles to format data in financial tables, forms, and cross-tabs. How to create and use charts to format data in reports. Use the drill mode to analyze different levels of data within a document.

Cost: $500.00

Course Description: Webcast: BusinessObjects Enterprise 6 - Report Builders (top)

Student Profile: Report builders, power users, ad-hoc report creators, and analysts who are responsible for creating reports for other users throughout their organization or for customers via an extranet.

Duration: 4 Hours

Description: This course is a four hour live, instructor-led, webcast that will help you get up and running with the new product as soon as possible and help other users in your organization upgrade to the new product as quickly and painlessly as possible.

Prerequisites: Core Reporting Concepts, Intermediate Reporting Concepts, Advanced Reporting Concepts, and WebIntelligence for Users or equivalent skills through experience.
Objectives: Upon completion of the series, you will understand the significant new reporting features and enhancements that BusinessObjects Enterprise 6 offers. You will also be able to determine which reporting tools are best suited to the needs of different user groups, and understand the key considerations you should be aware of when migrating to BusinessObjects Enterprise 6.

Topics Covered:

• Understand how BusinessObjects 6.0 fits into the overall Enterprise 6 solution. Get a high level view of the architecture, performance and scalability improvements. Understand the key new features.
• Overview of InfoView, WebIntelligence, and BusinessObjects 6.0 - Learn about the new features and enhancements in InfoView portal and the BusinessObjects and WebIntelligence reporting tools.
• WebIntelligence 6.0 - Get a detailed understanding of WebIntelligence and the new dHTML and Java panels for interactive report creation. The session includes demonstrations of new features and workflows.
• InfoView 6.0 and BusinessObjects 6.0 - Learn about the new InfoView features and how you can use them to customize and structure your BI portal. See the new full-client BusinessObjects features in action and find out how to get more information on BusinessObjects Enterprise 6 products using the online help, Quick Start presentations, and user documentation.

Webcast: Hardware Requirements:

Technical/Software Requirements:
This is a multimedia event presented live.

• Windows 95, 98, Me, NT 4.0, 2000, XP
• Netscape 4.08 or later, Internet Explorer 4.01 or later (SSL events require IE 5.01 or later)
• 28.8 kbps or faster Internet connection
• P133+ MHz, 32+ MB memory
• 800x600 or higher display resolution

Internet Voice (VOIP) Requirements:

• VOIP audio is required for these events. You must have the following:
• sound card, speakers or headset
• microphone preferred

Cost: $500.00

Course Description: BusinessObjects Supervisor 6.0 (top)

Student Profile: IT professionals responsible for security in a BusinessObjects implementation.

Duration: 1 Day

Description: Information is an organization's most valuable asset. And managing that information throughout the entire enterprise is essential for success. Learn how to effectively use BusinessObjects Supervisor, a BI administration tool, to manage users and resources from a central point or within a distributed environment.

Prerequisites: Understanding of BusinessObjects reporting functionality and sufficient familiarity with BusinessObjects reporting tools to create simple reports.

Objectives: On completion of the course, participants will be able to:

• Determine the appropriate repository architecture to optimize performance and security;
• Create and manage repositories;
• Allocate and manage universe and document domains to minimize maintenance tasks and storage space requirements.
• Determine appropriate strategies for organizing users and groups and granting them access to a customized set of commands to balance performance and ease of administration.

Topics Covered:

• Introduction to Supervisor - Understand how the Supervisor module fits into your BusinessObjects system. Become familiar with the main functions of the different types of supervisors and their associated tasks.
• Create the Repository - Learn the differences between monolithic and distributed repositories, and how different repository architectures impact performance. Create a repository and verify the location of the security files and their configurations. Run a safe recovery to recover a .KEY file.
• Groups and Users - Understand the concepts of groups, inheritance, and customization. Create and manage user and group access to modules, commands, universes, and documents. Learn best practices for organizing users and groups to balance performance and ease of administration.
• Importing Groups and Users - Learn how to automate the process for creating groups, users, and user properties by importing the relevant information from a text file.
• Command Restrictions - Learn how to define and override the access various groups and users have to the commands in the User, WebIntelligence, Designer, and Supervisor modules of BusinessObjects. Understand the configuration issues relating to command restrictions.
• Distributed Repository Architecture and Maintenance - Create a distributed repository. Allocate universe and document domains to different groups. Understand the technical specifications for setting up a repository server, and the advantages and disadvantages of multiple domains on multiple database platforms.
• Configuring Universes - Export and allocate a universe from the Designer module to a group and then configure it on a group-by-group basis.
• Maintain Document Domains - Allocate and manage document domains while learning how to minimize maintenance tasks and storage space requirements.

Cost: $625.00

WebIntelligence 2.6 Programmability with BusinessObjects Developer Suite (top)

Student Profile: You are a JSP developer, system administrator, or user developing custom application solutions with WebIntelligence technology. You would like to customize (or even replace) the WebIntelligence user interface, build a custom web-based Report catalog, automate the workflow of WebIntelligence

Duration: 3

Description: Understand the BusinessObjects Developer Suite concepts and terminology. Grasp the structure and contents of the WebIntelligence object model (WIBean) to use it customize WebIntelligence's interface and workflow. Learn how to automate BusinessObjects documents and drillable reports

Prerequisites: Understanding of object-oriented programming (OOP) concepts; experience with JSP, Java, html, and/or VBScript programming; sound knowledge of WebIntelligence user; familiarity with Broadcast Agent and equivalent experience with the following courses on:

• WebIntelligence 2.5/2.6 for Users
• WebIntelligence 2.5/2.6 Administrator
• BusinessObjects 5i Architecture and Deployment

Objectives:

• Changing users' passwords.
• Producing a list of Corporate documents.
• Viewing a document.
• Reading data providers.
• Customize the WebIntelligence interface.
• Managing prompts.
• Working with drillable reports.
• Utilizing BusinessObjects Documents.
• Publishing documents.
• Scheduling a document.

Topics Covered:

• Introduction to the Developer Suite contents, concepts, and terminology. WebIntelligence, JSP/html, and object models overview.
• Review of JSP and html.
• How to program against the WebIntelligence (WIBean) object model.
• Calling a list of documents, data providers, and prompts via WebIntelligence.
• Manipulating the sharing, scheduling, and publishing of documents.
• Managing the utilization of drillable WebIntelligence reports, and BusinessObjects documents.
• A major practical workshop to consolidate the course concepts based on a project from the delegate's company.

Cost: $1875

Note: Courses are taught using Microsoft Windows environment.

Course Description: Universe Design For BusinessObjects 6.0 (top)

Student Profile: Individuals who need to design, build, document, maintain, and distribute BusinessObjects universes.

Duration: 4 Days

Description: Learn how to translate end user reporting requirements into an optimal universe design to ensure that your company's Business Intelligence needs are met. BusinessObjects Universe Design 6.0 provides you with all the skills needed to efficiently create and maintain universes for BusinessObjects and WebIntelligence, allowing users to easily build, access and run reports. A hands-on, real world approach helps you to quickly learn how to create, distribute, maintain, and optimize universes for BusinessObjects and WebIntelligence deployments.

Prerequisites: A solid understanding of relational databases and client-server concepts. Must be SQL-literate.

Objectives: To help developers and other users competently understand BusinessObjects core functionality, terminology, and reporting capabilities.

Topics Covered:

• Introduction to BusinessObjects Deployments - Appreciate the universe designers role, how BusinessObjects infers SQL, and the universe development process.
• Building a Simple Universe - Learn to set universe parameters, populate the universe structure with tables, create joins and test dimension, detail and measure objects, and organize objects into classes.
• Resolving Loops, Chasm and Fan Traps – learn to identify and resolve loops, chasm traps and fan traps in the universe structure.
• Enhancing the User Experience - Enhance the universe design to improve and simplify the user experience with BusinessObjects. Learn how to add, modify, or remove a list of values for an object; create and customize hierarchies to simplify drilling for end users; and how to use @ functions.
• Improving Performance - Improve performance by understanding when and how to use aggregate awareness and pre-calculated aggregates from summary tables to speed up queries.
• Deployment - Learn to distribute, document, and maintain universes.
• Course Challenge - Practice your newly acquired knowledge and skills in universe design in a "safe" environment.

Cost: $2,500.00

Course Description: Universe Design for BusinessObjects (top)

Student Profile: IT professionals responsible for designing and maintaining BusinessObjects universes for Full Client BusinessObjects and/or WebIntelligence.

Duration: 4 Days

Description: Learn how to translate end user reporting requirements into an optimal universe design to ensure that your company's Business Intelligence needs are met. A hands-on, real world approach helps you quickly learn how to create, distribute, maintain and optimize universes for BusinessObjects and WebIntelligence deployments.

Prerequisites: Understanding relational databases, client-server concepts, (SQL) literacy.

Objectives: Understand the full functionality of BusinessObjects Designer Module; learn real world tips/tricks for universe distribution, optimization and maintenance.

Topics Covered:

• Introduction to BusinessObjects
• Introduction to Reporting with BusinessObjects - Familiarize yourself with the BusinessObjects full-client report tool from a Designer and End user perspective allowing you to interpret user's reporting requirements and test universe designs.
• Building a Simple Universe - Build a simple universe by learning how to set universe parameters, populate the structure with tables, create joins, create and test both classes, and measure objects.
• Resolving Loops, Chasms and Fan Traps.
• Enhancing the User Experience - Enhance the universe design to improve and simplify the users experience with Business Objects.
• Improving Performance - Understanding when and how to use aggregate awareness and pre-calculated aggregates from summary tables to optimize query performance.
• Deployment – Best practices.
• Course Challenge - After learning best practices for universe design, test your knowledge and skills by designing a universe on your own.
• Optimizing
• Universes for WebIntelligence

Cost: $2,500.00

Course Description :BusinessObjects Application Foundation Administration (V3.0) (top)

Student Profile: IT professionals who are responsible for the deployment, configuration, and customization of Application Foundation, as well as application developers who are responsible for building customized analytic applications and dashboards with Application Foundation

Duration: 4 days

Description: This course is designed to help you learn how to use the open framework for building and deploying custom or packaged analytic applications that deliver consistent, high-quality insight for making business decisions that organizations need to thrive.

Prerequisites:

• WebIntelligence for Users or sufficient exposure to report building using WebIntelligence
• Universe Design for BusinessObjects or extensive understanding of the functionality found in the Designer module
• BusinessObjects Supervisor or working knowledge of the functionality found in the Supervisor module
• Using Set Analyzer with Application Foundation
• Administering Set Analyzer for Application Foundation
• Working knowledge of web-enabled technologies and application servers
• Knowledge of SQL and relational databases is helpful

Objectives:

• Learn to properly install and configure components of Application Foundation.
• Create, analyze and apply enterprise and set-based metrics.
• Customize security with the range of security features.
• Build customized applications to meet your company's analytic needs.

Topics Covered:

• Introduction to Application Foundation
• Installing Components to Create the Business Objects Repository
  
• Configuring the Set Analyzer.
• Creating Time-based Sets - installing JDK and Tomcat
• Installing and Configuring Application Foundation
• Configuring Universes and Enterprise Metrics
• Creating Power Metrics
• Analyzing Segment Migration
• Lists and Individual Profiler
• Rules and Alerts Customizing Application Foundation
• Security

Cost: $2500

Note: Courses are taught using Microsoft Windows environment.

Course Description: Webcast: Migrating to BusinessObjects Developer Suite 6.0 (top)

Student Profile: IT professionals who are responsible for migrating, existing BusinessObjects custom applications from Developer Suite 5.x to Developer Suite 6.0.

Duration: 4 Hours

Description: Migrating to BusinessObjects Developer Suite 6.0 is a four hour instructor-led live webcast that will help you understand the new features and enhancements in Developer Suite 6.0, how they will impact your existing custom applications, and how to update and migrate those applications to Developer Suite 6.0.

Prerequisites: Experience developing custom applications using BusinessObjects 5.x SDKs.

Objectives: Understand the new architecture of BusinessObjects Enterprise 6, what's new in Developer Suite 6.0 and how existing custom applications may be impacted migrating to version 6.0. You will also be able to modify and deploy an existing custom application for BusinessObjects Developer Suite 6.0.

Topics Covered:

• What's New in Developer Suite 6.0 - Understand how BusinessObjects Developer Suite fits into the overall Enterprise 6 solution. Get a high level view of the improvements and new features in the Developer Suite SDKs. Learn about the new Admin SDK, the functionality it offers and the benefits it brings to your organization.
• Architecture & Communication - Understand how BusinessObjects products communicate with the WebIntelligence server, which processes continue to be handled by WIBEAN/WICOM, new feature enhancements and what has changed.
• What's New in WISDK - Learn about the new features available in WISDK, how WISDK supports WebIntelligence 6.0 documents, and how it coexists with the new report engine package. Learn about various different workflows and extended functionality you can use to enhance or create a customized application.
• Migrating and Deploying a Custom Application - Learn about the new virtual directories, archive files, HSAL and ORB settings for WebIntelligence 6.0 and how these may impact custom applications. Understand the impact on migration of document management changes, changes in security commands, on full-client applications, and server and user dictionaries. Modify the required settings and definitions to migrate the application.

Webcast: Hardware Requirements:

Technical/Software Requirements:
This is a multimedia event presented live.

• Windows 95, 98, Me, NT 4.0, 2000, XP
• Netscape 4.08 or later, Internet Explorer 4.01 or later (SSL events require IE 5.01 or later)
• 28.8 kbps or faster Internet connection
• P133+ MHz, 32+ MB memory
• 800x600 or higher display resolution

Internet Voice (VOIP) Requirements:

• VOIP audio is required for these events. You must have the following:
• sound card, speakers or headset
• microphone preferred

Cost: $500.00

BusinessObjects Enterprise 6 Administration (top)

Learn everything you need to get your BusissObjects TM Enterprise 6 business intelligence (BI) test and development platforms up and running. Gain an overview of all the BI platform products, administration tools, architecture, web and application servers, BusinessObjects repositories and domains. Practice installing, configuring, clustering, tuning, auditing, and tracing your system in a safe environment to ensure that you are familiar with best practices to do it right the first time.

Who should attend?
Systems administrators and architects who are interested in the technical and practical aspects of administering Business Objects Enterprise 6.0..

What will I learn?
On completion of this course delegates will understand how the BI platform is the foundations for other Business Objects offerings, namely Data Integrator and Application Foundation. You will also understand end-user software from an end-user and administrative perspective in addition to the systems architecture. They will learn how to install and configure ASP and JSP implementations of Business Objects systems and servers in clusters. In addition, they will be able to build a Broadcast Agent; improve Business Objects sever performance; set up, run and analyze traces; and understand deployment principles.

Topics Covered

• Overview - Provides an overview of Business Objects products and explains where the BI platform sits in the Business Objects end-to-end enterprise solution.
• Report Builders - Learn about report builders' roles and the tools and products needed in any successful Business Objects 2-tier and 3-tier deployment.
  
• Learn how to delegate log on to an existing WebIntelligence system, and create, edit, and distribute WebIntellignece and Business Objects reports.
  
• Architecture Overview - Understand what servers are needed and how they interact.
  
• 2-tier Installation - Install desktop and administration products and set up middleware connections to the database.
  
• Understand the XML license file needed for all Business Objects products and what the .key file is for.
  
• Database-tier - Review database structure, universe design considerations, and learn about the Business Objects repository.
  
• Create and populate a repository and distribute it to multiple domains.
  
• Use Supervisor to add users and connect to a corporate database.
  
• Web and Application Servers - Install Apache web servers and Tomcat application servers to set up a JSP environment to install and configure a Business Objects server.
  
• Learn about the administration console and Business Objects server processes.
  
• Broadcast Agent - Learn about Broadcast Agent and how to configure and test it.
  
• Clustering - Learn the purpose and specific implementation of the object request broker (ORB) and he application services framework (ASF).
  
• Understand the role of the primary, secondary, and client nodes and how to configure them for load-balancing.
• Configure and load balance a cluster.
  
• Performance and Tuning - Improve the performance of your system by learning what impacts performance and what you can do to improve it.
  
• Auditing and Trace Logging - Audit and trace your system to understand what's going on behind the scenes.
  
• Deploying - realize how you can deploy Enterprise 6 platform within your company's existing inter-, intra- and extranet environment to have a viable, secure, profitable and integrated BI platform solution.
  
• Learn how Business Objects Enterprise 6 interacts with redirectors, firewalls, multiple web and application servers, and multiple clusters

Delivery and duration
Four-day instructor-led course.

Class Fee
$2,500.00

Certification Applicability
This offering is not applicable to any certification.

Prerequisites
Familiarity with Windows 2000 administration.

Crystal Reports 10: Report Design I Fundamentals of Report Design (top)

This two-day instructor-led course is designed to give learners comprehensive skills and in-depth knowledge to plan and create reports that will help them analyze and interpret important information.

The Crystal Reports 10: The Fundamentals of Report Design course is a core course in the Crystal Reports Certified Professional (CRCP) certification and an elective course in the Crystal Enterprise Certified Professional (CECP) certification.

Who should attend?
This course is designed for report designers, new to Crystal Reports, who are responsible for creating and distributing reports.

What will I learn?
After completing the course, learners will be able to:

• Plan a report
  
• Create a report
  
• Organize data on a report
  
• Format a report
  
• Create basic formulas
  
• Apply section formatting
  
• Apply conditional reporting
  
• Present data visually
  
• Distribute a report

Course Agenda
Planning a Report

Defining database concepts

• Planning the layout and content of a report
• Developing a prototype of a report
  

Selecting Records

• Defining the Select Expert
  
• Determining the record selection criteria
  
• Defining saved and refreshed data
  
• Applying record selection
  
• Applying additional record selection criteria
  
• Modifying record selection
  
• Applying time-based record selection
  

Creating a Report

• Connecting to a data source
  
• Adding tables
  
• Defining the design environment
  
• Inserting objects on a report
  
• Previewing and saving a report
  
• Positioning and sizing objects
  
• Formatting objects
  

Organizing Data on a Report

• Sorting records
• Grouping records
• Summarizing data
  

Applying Section Formatting

• Formatting sections
• Creating a summary report
• Formatting a Report

Adding graphical elements

• Combining text objects with database fields
  
• Formatting individual elements of a text object
  
• Apply specialized formatting
  
• Inserting fields with pre-built functions

Representing Data Visually

• Creating a chart

Distributing Reports

• Exporting a report
  
• Saving a report to Crystal Enterprise Creating Basic Formulas
  
• Defining a formula
  
• Creating a formula
  
• Applying Boolean formulas
  
• Applying If-Then-Else formulas
  
• Applying date calculations
  
• Applying number calculations
  
• Applying string manipulation

Applying Conditional Reporting

• Determining trends in data
• Formatting data conditionally

Delivery and duration
Two-day instructor-led course.

Class Fee
$1,000.00

Certification Applicability
The Crystal Reports 10: The Fundamentals of Report Design course is a core course in the Crystal Reports Certified Professional (CRCP) certification and an elective course in the Crystal Enterprise Certified Professional (CECP) certification.

Prerequisites
In this course you will be working intensively with Crystal Reports. To successfully understand the content and complete the activities, you must already able to:

• Understand and use Windows conventions
• Understand basic database concepts

Crystal Reports 10: Report Design II Business Reporting Solutions (top)

This two-day instructor-led course is designed to give learners comprehensive skills and in-depth knowledge to plan and create reports that will help them analyze and interpret important information.

The Crystal Reports 10: Report Design II - Business Reporting Solutions course is a core course in the Crystal Reports Certified Professional (CRCP) certification.

Who should attend?
This course is designed for report designers, who have taken CR10: Report Design I - Fundamentals of Report Design, responsible for creating & distributing reports.

What will I learn?
After completing the course, learners will be able to:

• Use the Repository
• Create complex formulas
• Create Report Templates
• Build parameterized reports
• Summarize data with Cross-Tabs
• Use report sections
• Build specialized reports
• Share reports on the web

Course Agenda
Use the Repository

• Manage the Crystal Repository
  
• Add folders to the Repository
  
• Add objects to the Repository
  
• Update Connection to the Repository Object in the Report
  
• Delete objects to the Repository
  
• Connect to your own Repository
  
• Create a Report from an SQL Command
  
• Create a Report from an Business View

Create Report Templates

• Applying a Crystal defined templates
  
• Building a Template without a data source
  
• Removing Templates

Create complex formulas

• Use Functions and Operators
  
• Define control structures available in Crystal Syntax
  
• Use Variables
  
• Use Arrays

Build parameterized reports

• Define and create parameters
  
• Use edit masks and descriptions
  
• Build a report with multiple parameters
  
• Create a date range parameter

Summarizing data with Cross-Tabs

• Build a basic Cross-tab
  
• Format a Cross-tab

Use report sections

• Use Sections
• Use group related functions to format sections
• Use Section Underlay

Share reports on the web

• Define how Crystal Reports fits into the Crystal solution
  
• Use Crystal Enterprise Publishing Wizard
  
• View Parameterized Report in Crystal Enterprise

Build specialized reports

• Use the Running Total Expert
  
• Create a Form Letter
  
• Add Hyperlinks to a report
  
• Build a Report with Alerts
  
• Create a Top N Report

Delivery and duration
Two-day instructor-led course.

Class Fee
$1,000.00

Certification Applicability
The Crystal Reports 10: Report Design II - Business Reporting Solutions course is a core course in the Crystal Reports Certified Professional (CRCP) certification.

Prerequisites
In this course you will be working intensively with Crystal Reports. To successfully understand the content and complete the activities, you must already able to:

• Understand and use Windows conventions
• Understand basic database concepts
• Understand concepts taught in Report Design I

Note: Topics on Report Design II build on Report Design I concepts, therefore it is important that learners have a solid understanding of the concepts taught in Report Design I.