Crystal Reports 2013 Beginner-Intermediate

Back to Crystal Reports Training

InfoSol does not currently offer Crystal Reports training, but you can view our other BusinessObjects training offerings on our BusinessObjects Training page

Price: Contact below for quote

Duration: 1 Day

See Course Availability

Who is this course intended for?

This course is designed for people who are new to Crystal Reports 2013 and need to learn concepts and theory. It is a hands-on course that will give you enough practice to go back and start working on reports in your environment.

What will I learn?

Have you always wanted to create complex pixel perfect reports but thought it would be too time consuming to learn?   Well this class is just for you!   In just one day, you will learn how to do this using Crystal Reports 2013.    This class will teach you the basics of creating a simple Crystal Report that contains prompts, formulas, summaries and graphs.   This class focuses on the complete workflow of creating a Crystal Report; from connecting to your data source to exporting the report for an end user. The course is activity intense – hands on and focuses on the report features that you will use the most.

What should I know?

Knowledge of databases and database concepts, such as joining tables together, and some reporting background (it can be in other products).

Course Agenda

Day 1

  • Crystal Reports Introduction, Snapshot of the UI and Exploring Data Sources
  • Basic Report Creation
  • Applying Filters
  • Sorting, Inserting Summaries and Grouping Data
  • Adding special fields and applying logos to report
  • Working with Sections and creating Summary Reports
  • Basic Formulas
  • Conditional Formatting & Highlighting Expert
  • Introduction to Charts
  • Exporting and Distributing options

Available Dates:

 

 

Web Intelligence 4.2 Beginner | Intermediate | Advanced Boot Camps

Back to Web Intelligence Training

Beginner | Intermediate | Advanced Boot Camps

Price: $495 per student, per day
Duration: 3 Days

Course Description:

Users and report designers, who are new to Web Intelligence 4.2 and need to learn to access, analyze and share data using Web Intelligence. After completing this course, you will be able to create, format and maintain Web Intelligence documents and use complex functions such as: creating documents using multiple sources, using functions for character, date and strings, redefining calculation contexts, using “If” logic, as well as linking Web Intelligence documents.

Please Note: This course is broken into three days: Beginner, Intermediate, and Advanced. Students can customize their learning experience by selecting specific level of training needs. For example, you can register for just the Beginning course or continue onto Day 2 with the Intermediate and Day 3 with the Advanced.

Intended Audience:

Users and report designers, who are new to Web Intelligence 4.2

Prerequisites:

Beginner Course: None prerequisites!

Intermediate Course: The beginner course is recommended.

Advanced Course: The beginner and intermediate course is recommended.

Agenda: 3 Days

Day 1 – Beginner Course

Introduction to SAP Business Objects

  • Introduction to BI Launchpad
  • Introduction to Web Intelligence
  • Introduction to Universe
  • Different Interfaces

Understanding Web Intelligence Document

  • Opening a Web Intelligence document
  • Creating a new document
  • Editing a document

Query Panel

  • Toolbars
  • Data Manager
  • Adding Objects

Query Filters

  • Purpose of Filters
  • Elements of Filters
  • Type of Filters
  • Working with Filters

Report Manager

  • Understanding the Report Manager
  • Panels
  • Design Toolbar and Toolboxes
  • Navigating the Document
  • Working with Table, Charts and other visual elements
  • Table & Cell Formatting
  • Adding, Editing & Deleting Comments
  • Adding/Deleting Reports

Organizing Data

  • Sorting
  • Breaks
  • Summarizing Data
  • Sections
  • Functions
  • Conditional Alerts

Data Filters

  • Block Filters
  • Report Filters
  • Input Controls
  • Element Linking
  • Ranking

Day 2 – Intermediate Course

Formulas & Variables

  • Introduction to Formula
  • Create a formula
  • Formula Editor
  • Pre-defined Formulas
  • Create a variable

Queries & Data Providers

  • Types of Queries
  • Combined Queries
  • Advanced Filter – Subqueries
  • Advanced Filter – Query of a Query
  • Multiple Queries
  • Personal data providers
  • Free-Hand SQL  as source
  • Merging Dimensions
  • Changing a Data Source

Report Functions

  • Tracking Data Changes
  • Optional Function Parameters
  • Using Functions to override report filters in Calculations
  • Shared Elements

Drill Down

  • Activate drill down on a document
  • Drilling down on selected hierarchy

Day 3 – Advanced Course

Calculation Context

  • Custom calculation context
    • Input Context
    • Output Context

Report Techniques

  • Passing a constant to a Document
  • Limit number of rows on a page
  • Grouping, If, Then Else
  • Using hyperlinks to open documents
  • Handling Nulls or Blanks

Useful Features

  • Outline
  • Cascading Input Control
  • Dynamic Metric/Dimensions
  • Using Web Services as a data source
  • Creating Web Services from Webi parts

What your Universe Designer Can Do for You

  • Prompt for Section Breaks
  • Delegated Measures
  • Cascading Prompts
  • Automatic Date Prompts
Available Dates: 

Please Note: This course is broken into three days: Beginner, Intermediate, and Advanced. Students can customize their learning experience by selecting specific level of training needs. For example, you can register for just the Beginning course or continue onto Day 2 with the Intermediate and Day 3 with the Advanced.

Location and Local Accommodations

InfoSol is pleased to offer discounted rates at nearby hotels. When reserving a room, be certain to ask for the InfoSol Negotiated Rate. All of our preferred hotels offer a free shuttle to/from InfoSol and within a 5 miles radius.

Hilton Garden Inn   (623) 434-5556 (1.6 mi.)
Reservations click here.

Courtyard by Marriott (623) 580-8844 (2.5 mi.)
Reservations
click here.

Hampton Inn & Suites (623) 516-9300 (5 mi.)
Reservations
click here.

Homewood Suites  (623) 580-1800 (5 mi.)
Reservations
click here.

Country Inn & Suites (623) 879-9000 (1.3 mi.)
Reservations click here.

If you have any questions, please do not hesitate to contact us, (623)707-7600