Crystal Reports: Advanced


  • Crystal Reports: Advanced, Singapore SKillsFuture elarning online course
  • Crystal Reports: Advanced, Singapore SKillsFuture elarning online course
  • Crystal Reports: Advanced, Singapore SKillsFuture elarning online course
  • Crystal Reports: Advanced, Singapore SKillsFuture elarning online course
  • Crystal Reports: Advanced, Singapore SKillsFuture elarning online course
  • Crystal Reports: Advanced, Singapore SKillsFuture elarning online course

Course Description

Crystal Reports is one of the most popular report writing applications available today. Its ability to create complex reports from a variety of data connections (including Microsoft, Oracle, and Business Objects) is highly acclaimed. In this VTC course, expert instructor Lauri Matson walks you through the power of Crystal Reports, exploring its features and showing you how to simplify the complexities. Anyone involved in creating reports from stored data will benefit from this course. You'll become be a master of design, formulas, parameters, and more. You will learn how to create advanced reports, analyze databases and table relationships, write formulas and functions, enhance your reports with charts and graphs, and much, much more. Experience with databases and spreadsheet programs is assumed, prior knowledge of Crystal Reports is recommended.

Learn how you can manage your database from becoming redundant.

- Find out how you can manage your database
- Learn ways to fully utilize your data's potential
- Know how to analyze reports from your data
- Learn commands, formula and queries for your database

This course is eligible for SkillsFuture Credit and UTAP funding.


Course Objectives

1. Understand the basics of Reporting 
2. Understand about the concepts of Database 
3. Know how to work with data using SQL and formula
4. Able to apply queries and formula to database for data  
5. Know how to read analysis from data 


Related Courses

  • Learn about Digital Audio with Steinberg Cubase 6

    Learn about Digital Audio with Steinberg Cubase 6

    SGD $49.00

    Course Description

    Steinberg's Cubase 6 is the latest update to the extremely popular professional digital audio workstation music software. In this course, author Mark Struthers will demonstrate how to make initial input and output connections to the program from the soundcard before examining routing in more detail. Additionally, insert and group effects are explored to help show how to enhance recorded audio tracks. Mark will walk you through the many-featured project window before showing you how to create and save your own project. Within the Cubase workflow, important terms such as clips, events, and parts are explained along with the distinction between lanes and tracks. Mark also covers insert and send effects, quantization, time stretch, and the Media Bay. Cubase comes equipped with VST instruments and, in particular, Groove Agent One and Halion Sonic SE are explored before working through the concepts behind a final mix and export to a finished audio track. Be able to produce music recording, arranging and editing with Steinberg. - Learn how to work with audio files using Steinberg- Know how Steinberg works as an audio editing software- Enable yourself to be able to produce your own music with Steinberg - Learn about the different techniques used in Steinberg to achieve quality audioThis course is SkillsFuture Credit Eligible.

    Read more...

  • Essential Online Course - Microsoft Access 2016

    Essential Online Course - Microsoft Access 2016

    SGD $299.00

    Course Description

    Microsoft Access is now much more than a way to create desktop databases. It’s an easy to use tool for quickly creating browser based database applications that help you run your business. Your data is automatically stored in a SQL database, so it’s more secure and scalable than ever, and you can easily share your applications with colleagues. This course will guide you through the basics of relational database design and through the creation of database objects. You will learn how to use forms, query tables and reports to manage data. You will understand the interface, customization and creation editing of the many objects available within the Microsoft Access application. This course is divided in to three separate levels being Basic Microsoft Access, Intermediate Microsoft Access and Advanced Microsoft Access. Realise the full potential of your data with Microsoft Access. - Learn about the functions in Microsoft Access that can help your understand data better  - Know the different ways of vizualising your data with Microsoft Access - Pick up the knowledge of utilizing Access for better understanding your data - Learn how you can stretch your data for optimum analysis

    Read more...

  • Sony DVD Architect Pro 5

    Sony DVD Architect Pro 5

    SGD $45.00

    Course Description

    Sony DVD Architect Pro 5 is the latest update to the extremely popular professional digital video authoring software. In this VTC course, users will be shown the initial system requirements necessary to run the program smoothly. Author Mark Struthers will then discuss the main functions as he demonstrates several methods for creating different types of projects including Menu-Based Projects and Music & Video Compilations. Important considerations such as Masks, Menus, and Themes are analyzed along the way. To conclude the course, methods of transferring projects to DVD are covered. Swiftly create professional-looking DVDs, even stunning widescreen productions. - Learn what goes into creating a DVD - Be able to create different kind of content in DVD - Learn how to create your own media content using Sony DVD Architect - Learn how to polish your projects before transferring into DVD

    Read more...


Content

Introduction

Preview Available

+

Welcome

Work Files

Review of the Basics

Preview Available

+

Planning a Report

Inserting Fields

The Screen Layout

Hints for Formatting

Grids and Guidelines

Reviewing the Menus

Advanced Database Concepts

+

Connection Types

Using the Database Expert

Database Verification

Verification Options in Crystal

Relationships and Joins

Types of Joins

Mapping Database Fields

Viewing Your Data

+

Views and Queries

Options and Your Data

Expressions vs. Commands

Working with SQL

+

SQL Command Select

Combing Multiple Tables

SQL Order By / Where / Alias

Refresher of Formulas

+

The Basics

Editing Formulas

Referencing Fields

Formula Syntax

+

Basic vs Crystal Syntax

Syntax Continued

Variable Example

Using Help for Syntax

Placement of Formulas

More Formulas

+

Select Expression

Dates and Formats

Extracting from a Field

Extraction Example

Commonly Used Formulas

SQL

+

SQL Expressions

Expression Use of Select

SQL Command Example

Commonly Used Expressions

Running Totals

+

Review of Running Totals

Groups and Totals

Manual Totals

Conditional Totals

Reset in Formula

Custom Functions

+

Understanding Custom Functions

Creating a Function

Properties

More Examples

Performance

+

Indexing

Indexing Continued

Strategies for Performance

Performance Continued

Optimizing for the Web

Design and Creation

+

Planning your Report

Data Implications

Adventureworks Schematics

Refresher on Cross-Tab Reports

+

Using a Cross-Tab

Formatting Cross-Tab by Design

Formatting in Preview

Cross-Tab Design

Cross-Tab Vocabulary

Cross-Tab Example

Subreports

+

Inserting Subreports

Formatting

Subreports as Charts

OnDemand and Unrelated Reports

Time and Variables

+

Date and Time in Fields

Date Format to Text

Working with Hours

Groups

+

Reviewing Groups

Grouping on a Formula Field

Grouping Hierarchically

Working with Multiple Sections

Parameters

+

Reviewing the Basic Parameter

Using Multiple Values

Using SQL Commands

Dynamic Values

Parameters and Conditional Formats

Charts

+

Preparing a Report

Using the Wizard

Formatting

Selecting a Chart Type

Trendlines

Conditional Formatting

Charts in a Group Header

Mapping

+

Creating a Map

Formatting a Map

Mapping Groups

Groups Continued

Other Tips and Tricks

+

Mailing Labels

Working with Form Letters

Creating Alerts

Working with Alerts

Adding Tool Tips

Conditional Formatting

Alternate Row Formatting

Conclusion

+
Resource Files

The Viewer

Dashboard and Xcelsius

Remember the Help Menu

Wrap Up

Credits

+

About the Author

SkillsFuture Credit Eligible
UTAP Funding Eligible
SGD $45.00
(Price excludes GST)
GET ACCESS NOW
Convince your boss email
This site is best viewed using the latest versions of Google Chrome, Apple Safari, Mozilla FireFox, Microsoft Internet Explorer 11 and Edge which supports HTML5/Webkit technologies.