Crystal Reports

September 3rd, 2016

  • Essentials & Beyond
  • Advanced

Crystal Reports – Essentials & Beyond

Delivery & Duration

  • Face-to-face: 2 days, OR
  • Live online: 6 x 1-hour sessions

General Outline

This course is designed for users with little or no experience with Crystal Reports but who have the need to generate reports based on data available to them.

Students will learn the basics of report creation including sorting, grouping, linking, basic formula creation, working with report experts and how to distribute reports to other users.

Detailed Content

By the end of this course, participants will be able to:

  • Plan reports including data and appearance.
  • Describe the components of the main screen.
  • Create reports based on database information.
  • Use a report expert and copy existing reports.
  • Add, modify, and remove report objects such as data fields, text objects, file information, graphics or decorative lines, and boxes.
  • Format the appearance of reports.
  • Change selection criteria and sort order.
  • Create subtotals, grand totals and summaries.
  • Create, edit, and delete formulas.
  • Use built-in formula language.
  • Create and modify links.
  • Identify and control report sections.
  • Distribute reports through a variety of methods.
  • Publish reports to a Web site.

Flexible Options

Courses are delivered in our training rooms, or can be conducted in your training room onsite, or as live, online sessions. And content/outcomes can be customised/tailor-made to your requirements.

See Benefits to the right for a list of services provided to all participants (depending on the course).

For more details or to inquire about a closed corporate or online program, use our inquiry form here or phone us on (02) 6041 2711.

Prerequisites

No experience in using Crystal Reports is required nor assumed. Participants are expected to have a sound knowledge of and experience with a Windows PC. Although no database experience is necessary, some of the concepts may be more meaningful if the user has worked with database applications before. A basic knowledge of relational data concepts and querying is also recommended.

Dates + Book Now
Download Course Guide

Benefits

Crystal Reports – Advanced

Delivery & Duration

  • Face-to-face: 2 day, OR
  • Live online: 6 x 1-hour sessions

General Outline

This course goes beyond the basics and focuses on more advanced features within Crystal Reports.

You will use variables and multiple statements in formulas, create and use parameter fields, develop conditional format statements and work with multiple sections.

The course is designed for people who require the use of advanced formulas and formatting, need to access information that is not PC-based, or need to set up reports that other users will access and run. Many shortcuts and time-saving techniques used in creating advanced reports are also covered.

Detailed Content

By the end of this course, participants will be able to:

  • Create formulas with multiple statements and variables.
  • Control calculation processes used to compile data.
  • Control reports using conditional format statements and multiple sections.
  • Create parameter formulas to allow users control over report appearance.
  • Use report alerts to notify about data changes.
  • Enhance the analysis capability of cross-tabs.
  • Extend reporting capacity with subreports.
  • Access data from SQL/ODBC data sources.
  • Generate queries using SQL Designer.
  • Create and modify dictionary files to simplify the reporting process.
  • Create and edit graphical representations of data.
  • Use Chart Expert to create new charts.
  • Modify existing graphs with Chart Analyzer.

Flexible Options

Courses are delivered in our training rooms, or can be conducted in your training room onsite, or as live, online sessions. And content/outcomes can be customised/tailor-made to your requirements.

See Benefits to the right for a list of services provided to all participants (depending on the course).

For more details or to inquire about a closed corporate or online program, use our inquiry form here or phone us on (02) 6041 2711.

Prerequisites

CLASS Training Essentials and Beyond Course or proven experience with Crystal Reports. Also experience with querying and database relationships will be an advantage.

  • Three Big Word Tips

    September 3rd, 2016

    Think you know Word? Three great tips we use all the time.

  • Xero Big Tips

    September 3rd, 2016

    Our 4 Big Xero Tips for making Xero do the work for you…

  • Manipulating Data Easily in Excel

    September 3rd, 2016

    Check out the ‘magic’ of Excel’s Flash Fill feature to manipulate data.

  • Youth in the iGeneration

    September 3rd, 2016

    Challenges we face from and for our youth and how to manage them in today’s tech world.

IT Training AND Courses
EDUCATE, ENHANCE & PERFORM
We are here to help you work smarter with your IT tools. Whether it's for business, work or fun, our services will increase your productivity and minimise your stress. Look around for info about our services and courses, dates, bookings, help desk, resources and more.
  • Analysis of your needs.
  • Face-to-face or live, online.
  • Our training rooms or yours.
  • Extensive training manuals.
  • Help desk support.
Our corporate video
Call (02) 6041 2711