More results...

Generic filters
Filter by Brands/Technologies

Crystal Reports 2016 – Part 2 training course

Instructor‑Led: $940 | Duration: 2 Days

In this course, students will create complex reports & data sources using the tools in Crystal Reports 2016. Students will not only create more complex reports including sub-reports and cross-tabs, but will also increase their speed and efficiency.

Reserve your seat in an upcoming class date or select a Learning Method below:

There are currently no upcoming course dates scheduled. Please complete the form to request a date/receive schedule update notifications:

    Course Highlights

    LEVEL: 
    • Beginner
    TOPICS & JOB ROLES: 

    Crystal Reports 2016 – Part 2 Course Outline

    In this course, students will create complex reports & data sources using the tools in Crystal Reports 2016. Students will not only create more complex reports including sub-reports and cross-tabs, but will also increase their speed and efficiency.

    Who Should Attend this Course?

    This course is designed for people who know how to create basic list and group reports and need to create reports that include subreports, cross-tabs, advanced formulas, and charts based on more than one data series. They may also need to build tools that make it easier for other people to create reports. They may or may not have programming and/or SQL experience.

    PREREQUISITES

    Crystal Reports 2016 — Part 1 or equivalent experience

    1 — CREATING RUNNING TOTALS

    • Topic A: Create a Running Total Field
    • Topic B: Modify a Running Total Field
    • Topic C: Create a Manual Running Total

    2 — WORKING WITH CROSS-TABS

    • Topic A: Create a Cross-Tab Report
    • Topic B: Format a Cross-Tab Report
    • Topic C: Create Groups in Cross-Tab Reports

    3 — ADDING SUBREPORTS

    • Topic A: Insert a Subreport
    • Topic B: Edit a Subreport
    • Topic C: Share Variables

    4 — CREATING DRILL-DOWNS IN A REPORT

    • Topic A: Create a Drill-Down
    • Topic B: Create Headings for Drill-Down Data

    5 — USING SQL STATEMENTS IN REPORT PROCESSING

    • Topic A: Create a Report Using SQL Queries
    • Topic B: Summarize Report Data
    • Topic C: Create Joins Using SQL
    • Topic D: Create Subqueries
    • Topic E: Create an SQL Expression Field

    6 — CREATING COMPLEX FORMULAS

    • Topic A: Work with Loops
    • Topic B: Work with Arrays

    7 — ADDING CHARTS TO REPORTS

    • Topic A: Create Charts
    • Topic B: Create a Chart with Drill-Down
    • Topic C: Create a Top N Chart
    • Topic D: Create a Cross-Tab Chart
    • Topic E: Create Charts for Grouped Data
    • Topic F: Format a Chart
    • Topic G: Create a Chart Template

    8 — ENHANCING REPORT FUNCTIONALITY

    • Topic A: Organize Data Based on a Hierarchy
    • Topic B: Create a Dynamic Image
    • Topic C: Create a Report Alert
    • Topic D: Create a Geographic Map

    9 — APPENDIX

    • Appendix A: Managing Reports
    • Appendix B: Processing Data on the Server
    • Appendix C: Detecting and Fixing Problems

    Related Job Roles

    This course builds skills and demonstrates qualifications for the job roles and average base salaries below. 

    Market Intelligence Analyst

    Demographer

    Education Research Analyst

    Mathematical Statistician

    Psychometric Consultant

    Quantitative Methodologist

    Explore Related Training Courses with TechSherpas 365

    Related products

    • Windows Server

      50255 Managing Windows Environments With Group Policy
      In this course, you will learn how to reduce costs and increase efficiencies in your network. You will discover how to consolidate the administration of an enterprise IT infrastructure with…Read more.
      5 days
      $595.00 - $2,795.00
      Classroom Live
      On-Demand Learning (ODL)
      Virtual Classroom
      Live, Instructor-Led (ILT)
    • Web Apps

      55337 Introduction To Programming
      In this 5-day course, students will learn the basics of computer programming through the use of Microsoft Visual Studio 2022 and the Visual C# and Visual Basic programming languages. The…Read more.
      5 days
      $595.00 - $2,795.00
      Classroom Live
      On-Demand Learning (ODL)
      Virtual Classroom
      Live, Instructor-Led (ILT)
    • Web Apps

      55339 Programming In C#
      This five- day training course teaches developers the programming skills that are required to create applications using the C# language. During their five days in the classroom, students review the…Read more.
      5 days
      $595.00 - $2,795.00
      Classroom Live
      On-Demand Learning (ODL)
      Virtual Classroom
      Live, Instructor-Led (ILT)
    • Microsoft 365

      55399 Implementing And Managing Microsoft Intune
      This three-day instructor-led course is aimed at modern device management professionals looking to manage their enterprise devices using Microsoft Intune. This course will cover Enrolment, Application Management, Endpoint Security and…Read more.
      3 days
      $595.00 - $1,795.00
      Classroom Live
      On-Demand Learning (ODL)
      Virtual Classroom
      Live, Instructor-Led (ILT)