We use cookies to offer you a better experience and to analyse how visitors use our site, you may consent to our cookies by continuing to use our site, or you may view more information and choose to reject cookies by clicking here. Thank you

Contact us online or call us on 0191 377 8377

  • Name*:*
  • Organisation:
  • Telephone:
  • Email:*
  • Message*:*
  • Send me a copy of this email
  • Send me course updates from time to time via email

    Your subscription will naturally terminate after your chosen time limit. We will get in touch just before the end so that you can subscribe again if you would like to continue receiving information after that point.

* Required Fields

PDF
Course Crystal Reports Level 2
  • Public Scheduled Price£795 +VAT
  • Course Duration2 Days
  • Course Options
    Private
    Private
    Flexible content, flexible date, flexible location, variable length, private to your organisation - Courses can be held at one of our training venues or at another location convenient to you. Training can be set over a number of days or weeks to allow for practice time between training sessions.
    Bespoke
    Bespoke
    Bespoke private training can be based on an existing course or a number of lessons taken from several courses, we can also write bespoke courses for you based on your in-house systems or development program.

Overview
Delegates will learn how to create advanced formulas in Crystal Reports, format Crystal reports based on calculation results (conditional formatting), use multiple sections, insert sub reports and access data from sources other than PC databases.
Prerequisites
    • To ensure your success on this advanced Crystal Reports course, we recommend that you first attend the course Crystal Reports Level 1 course, or have equivalent knowledge.
Objectives
    • Understand and control the calculation process used to compile your data in Crystal Reports.
    • Control the appearance of your Crystal report using conditional format statements and multiple sections.
    • Create parameter formulas that allow users to determine what data they want to see on a Crystal report.
    • Enhance the analysis capability of your cross-tabs.
    • Create Crystal Reports formulas with multiple statements and use variables.
    • Extend your reporting capacity by utilizing sub-reports.
    • Access data from SQL/ODBC data sources, and generate queries using your own SQL statements.
    • Create and edit graphical representations of your data using the Chart Expert or modify existing
What's included
    • Laptops are available for training delivered at client's premises
    • Lunch and refreshments when training is delivered at our training venues
    • Comprehensive course materials and exercises
Course Content
    • Crystal Reports Review Exercises
      Formatting Crystal Reports sections for summary/drill-down
      Creating formulas in Crystal Reports
      Selecting, grouping and summarizing
      Adding and linking databases
      Creating a basic Crystal report
    • Conditional Formatting in Crystal Reports
      Removing conditional formatting
      Using the Crystal Reports highlighting expert
      Assigning conditional attribute formatting
      Applying and removing conditional on/off formatting in Crystal Reports
      Understanding the difference between absolute and conditional formatting
    • Advanced Formulas / Variables in Crystal Reports
      Using variables in formulas
      Creating formulas using multiple variables in your Crystal report
      Using evaluation time functions
      Understanding multiple pass reporting
      Creating running totals
    • SQL and Commands in Crystal Reports
      Adding parameters to your own SQL statement
      Defining your own SQL as the Crystal report data source
      Introduction to standard query language (SQL)
    • Crystal Reports Parameter Fields
      Using Crystal Reports parameter fields to set conditional formats
      Using Crystal Reports parameter fields to specify sort criteria
      Understanding edit masks in Crystal Reports
    • Report Alerts
      Viewing record sets created by use of alerts
      Creating and using Crystal report alerts
    • Crystal Reports Multiple Sections
      Working with multiple sections and conditional formats
      Moving, splitting and merging sections
      Inserting and deleting sections
    • Subreports
      Using variables to pass data from a sub report to the main report
      Creating on-demand subreports
      Formatting subreports
      Inserting unlinked and linked subreports
      Identifying when subreports are needed
    • Basic & Advanced Cross-Tabs
      Using Crystal Reports formula fields & parameter fields with cross tab reports
      Formatting cross Tab components
      Inserting multiple rows, columns and summarized fields
      Creating basic and advanced cross tab Crystal reports
    • Charting
      Formatting existing graphs
      Creating basic, calculating and cross tab related charts
      Using the Crystal Reports Chart Expert
      Crystal Reports chart types and layout options

 

IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk

Printed: 16 Jun 19

 

 

 

Contact us

  • Name*:*
  • Organisation:
  • Telephone:
  • Email:*
  • Message*:*
  • Send me a copy of this email
  • Send me course updates from time to time via email

    Your subscription will naturally terminate after your chosen time limit. We will get in touch just before the end so that you can subscribe again if you would like to continue receiving information after that point.

* Required Fields