Crystal Reports 2008 - Level 2 New Horizons Ireland
Price: AED 4,485

    Course details

    In this course, students create complex reports and data sources using Crystal Reports' tools. They will also increase the speed and efficiency of their reports by using SQL queries.

    Course Outline

    1 - Creating Running Totals

    • Create a Running Total Field
    • Modify a Running Total Field
    • Create a Manual Running Total

    2 - Working with Cross-Tabs

    • Create a Cross-Tab Report
    • Format a Cross-Tab Report
    • Create Groups in Cross-Tab Reports

    3 - Adding Subreports

    • Insert a Subreport
    • Edit a Subreport
    • Share Variables

    4 - Creating Drill-Downs in a Report

    • Create a Drill-Down
    • Create Headings for Drill-Down Data

    5 - Using SQL Statements in Report Processing

    • Create a Report Using SQL Queries
    • Summarize Report Data
    • Create Joins Using SQL
    • Create Subqueries
    • Create a SQL Expression Field

    6 - Creating Complex Formulas

    • Work with Loops
    • Work with Arrays

    7 - Adding Charts to Reports

    • Create Charts
    • Create a Chart with a Drill-Down
    • Create a Top N Chart
    • Create a Cross-Tab Chart
    • Create Charts for Grouped Data
    • Format a Chart
    • Create a Chart Template

    8 - Enhancing Report Functionality

    • Organize Data Based on a Hierarchy
    • Create a Dynamic Image
    • Create a Report Alert
    • Create a Geographic Map
    Updated on 08 November, 2015

    About New Horizons Ireland

    With a very convenient location next to Jervis street in Dublin 1, we offer a wide range of IT and business skills courses and we can also send our instructors to your location.

    We are 100% Irish owned, but we are also part of the largest independent IT Training Provider, New Horizons Computer Learning Centres who deliver more courses than any other IT training company.

    Because we're local, we understand the needs of business and individuals in our community. Whether you choose to take classes in person or online, you're always welcome to call or stop by.

    See all New Horizons Ireland courses
    Are you from New Horizons Ireland ? Claim your course!
    Courses you can instantly connect with... Do an online course on SQL Server starting now. See all courses

    Is this the right course for you?

    Rate this page

    Didn't find what you were looking for ?

    or