Training Course

Crystal Reports Level 2

PDF
2 Days
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.

Private Training

Flexible dates, location and content. All prices exclude VAT.

Course 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.

Course 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

Included with this course

    • Lunch and refreshments when training is delivered at our training venues
    • Comprehensive course materials and exercises

Crystal Reports Level 2 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

 

Private Training

Flexible dates, location and content. All prices exclude VAT.
  • Call us on
    0191 377 8377
    to discuss your requirements.
    Mon-Fri 9am-5pm.
    Have a Question?
    Keep me up to date with offers and news
    By submitting this form, you consent to IT Training Solutions Ltd storing your information in order to respond to your request.
  • Crystal Reports Level 2 Course Options
    Private
    Private
    Flexible course content, flexible training date(s), flexible location(s), variable course 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.
    Virtual
    Virtual
    These courses can be attended from anywhere.
  • Virtual Training

"Really enjoyed the course and meeting [the trainer], who was very patient and knowledgeable :"

M.R. Teesworks, Visio Essentials

"Well presented. Kept everyone engaged throughout."

K.H. Alnwick Medical Group, Coaching and Mentoring

What were the most useful aspects of the course "Explanation of planning, setting objectives"

S.T. Tiplady Safety Services Ltd, Train the Trainer Training Skills for the Workplace

"[The trainer] covered the basics of using Power BI in a really accessible manner which was easy to understand."

L.C. NOCN Group, Microsoft Power BI Desktop

Following this training what are you going to do differently "Will be leading the effort to replace a large number of reports currently done in Excel with Power BI variants to better present the data, and make reproduction far faster."

T.W. Network Rail, Microsoft Power BI Desktop

"I now understand how to use PowerBi and feel confident that I will be able to create my reports through this system"

P.H. Northern Powergrid, Microsoft Power BI Desktop

Which part of the course did you find particularly valuable "Learning short cuts and filters"

M.C. CMR UK Ltd, Excel Level 2

"Great Course! Great Trainer!"

A.M. Hemingways, Excel Level 2

 

Private Training

Flexible dates, location and content. All prices exclude VAT.

 

Please contact us to discuss your Crystal Reports Level 2 course, we have many solutions available to ensure you receive the best training possible.
 Learn with IT Training Solutions. Small course sizes. Course materials included. Flexible Crystal Reports Level 2 course content. Expert trainers and tried & tested training methods. Many course materials available online using your personal training account.  Please contact us to book a place or request a quote for your Crystal Reports Level 2 course.

General Information

Crystal Reports is a registered trademark Crystal Reports training courses in Durham, Washington, Newcastle and throughout North East England. Crystal Reports training in Newcastle. Crystal Reports Training Sunderland. Crystal Reports Training in Durham, Washington, Sunderland, throughout the North East. Crystal Reports training Newcastle. < a href=';/crystal-reports-training-courses-north-east-sunderland-gateshead/crystal-reports-training-courses-sunderland-durham.asp';>Crystal Reports training courses in Sunderland and Gateshead.</a> Crystal Reports courses in Newcastle.
IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:1/14/2025 5:34:46 PM