Crystal Reports -Intermediate – Level 2

In this course, students will learn how to create more sophisticated reports like subreports and cross-tabs. Also, they learn how to increase the speed and efficiency of their reports by using SQL queries and dictionaries.

TAKE THE LEAP

Area of Learning — Crystal Reports -Intermediate – Level 2

Description Intakes
Cluster 1 Project 1 and 2
Virtual Lesson 1 (3hr)
  • Session 1: Induction to TAE40116 and Zoom
  • Session 2: The VET Sector
Current:
25th May 2020
Next:
25th May 2020
Saturday:
25th May 2020
Virtual Lesson 2 (3hr)
  • Session 3: Analysing the training package, qualification and unit of competency
  • Session 4: Developing a Learning and Assessment Program
Current:
25th May 2020
Next:
25th May 2020
Saturday:
25th May 2020
Virtual Lesson 3 (2hr)
  • Session 5: Develop and customising support strategies
Current:
25th May 2020
Next:
25th May 2020
Saturday:
25th May 2020
Cluster 1 Project 3
Virtual Lesson 4 (2hr 30mins)
  • Session 6: LLN Intro
  • Session 7: Unpack Unit of Competency & Analysing LLN Requirements
Current:
25th May 2020
Next:
25th May 2020
Saturday:
25th May 2020
Virtual Lesson 5 (3hr)
  • Session 8: Determine LLN skills of learner group, Access LLN Support
  • Session 9: Customise learning and support strategies, prepare resources to address LLN skills requirements
Current:
25th May 2020
Next:
25th May 2020
Saturday:
25th May 2020
Assessment Session - Present and gain feedback (2hr)Forsythes Training co-ordinate and undertake observations
Current:
25th May 2020
Next:
25th May 2020
Saturday:
25th May 2020
Cluster 1 Additional Coaching Support Session (Monthly)
Current:
25th May 2020
Next:
25th May 2020
Saturday:
25th May 2020
Cluster 2
Virtual Lesson 6 (2hr)
  • Session 10: Overview of DEL401 DEL402 Developing an Individual Pathway Plan & Developing Session Plan
Current:
25th May 2020
Next:
25th May 2020
Saturday:
25th May 2020
Assessment Session Task 4 Role Play - Negotiating and gaining agreement on Individual Pathway Plan (2hr)Forsythes Training co-ordinate and undertake observations
Current:
25th May 2020
Next:
25th May 2020
Saturday:
25th May 2020
Virtual Lesson 7(1hr 30mins)
  • Session 11: Project 1
Current:
25th May 2020
Next:
25th May 2020
Saturday:
25th May 2020
Assessment Session Task 3 (2hr)Forsythes Training co-ordinate and undertake observations
Current:
25th May 2020
Next:
25th May 2020
Saturday:
25th May 2020
Virtual Lesson 8 (1hr)
  • Session 12: Project 2 & 3
Current:
25th May 2020
Next:
25th May 2020
Saturday:
25th May 2020
Assessment Sessions 2x40min deliverables (16hr MAX)Forsythes Training co-ordinate and undertake observations Options available:
  1. Record in the workplace with minimum of eight
  2. Attend webinars max 16 hours
Current:
25th May 2020
Next:
25th May 2020
Saturday:
25th May 2020
Cluster 2 Additional Coaching Support Session (Monthly)
Current:
25th May 2020
Next:
25th May 2020
Saturday:
25th May 2020
Cluster 3
Virtual Lesson 9 (3hr)
  • Session 13: Intro to Assessor Cluster
  • Session 14: Analyse unit of Competency
Current:
25th May 2020
Next:
25th May 2020
Saturday:
25th May 2020
Virtual Lesson 10 (3hr)
  • Session 15: Developing assessment instruments
Current:
25th May 2020
Next:
25th May 2020
Saturday:
25th May 2020
Virtual Lesson 11 (3hr)
  • Session 16: Developing Pre-Brief and Assessment Plan
  • Session 17: Trialling and Conducting Assessment
Current:
25th May 2020
Next:
25th May 2020
Saturday:
25th May 2020
Assessment Session - Conducting Assessment (7hr)Forsythes Training co-ordinate and undertake observations
Current:
25th May 2020
Next:
25th May 2020
Saturday:
25th May 2020
Virtual Lesson 12 (3hr)
  • Session 18: Validation
  • Session 19: RPL
  • Session 20: Review
Current:
25th May 2020
Next:
25th May 2020
Saturday:
25th May 2020
Cluster 3 Additional Coaching Support Session (Monthly)
Current:
25th May 2020
Next:
25th May 2020
Saturday:
25th May 2020

Course Outline

Lesson 1: Creating Running Totals

  • Create a Running Total Field
  • Modify a Running Total Field
  • Create a Manual Running Total on Detail Data
  • Create a Manual Running Total on Summary Data

Lesson 2: Building Cross-tabs in Your Report

  • Create a Cross-tab
  • Create a Specified Group Order
  • Filter a Cross-tab by Group
  • Change the Cross-tab Format
  • Conditionally Format Rows and Columns
  • Keep Groups Together

Lesson 3: Adding Subreports

  • Insert a Subreport
  • Link a Subreport to Data in a Primary Report
  • Edit a Subreport
  • Format a Subreport Using the Format Editor
  • Share Formulas Between Main and Subreports
  • Create an On-demand Subreport

Lesson 4: Creating Drill-downs

  • Create a Drill-down
  • Create Separate Headings for Drill-down Data

Lesson 5: Enhancing Report Processing Using SQL

  • Create a Report Using SQL Queries
  • Summarise Report Data Using SQL Aggregate Functions
  • Create Joins Using SQL
  • Create Subqueries
  • Create an SQL Expression Field to Promote Server-side Processing

Lesson 6: Charting Data

  • Create a Bar Chart
  • Modify a Chart
  • Create a Top N Chart
  • Format a Chart
  • Create a Chart Template

Lesson 7: Reporting on Excel Data

  • Create a Report Based on Excel Data
  • Modify a Report Generated from Excel Data
  • Update Data in a Report Based on Excel Data

Forsythes Training provides instructor led computer training on the Microsoft Office and Adobe range of applications. We service Sydney, Newcastle, the Hunter Valley, Lake Macquarie, Central and Northern Coasts of New South Wales (NSW) Australia.With our mobile training room we can provide a range of courses on-site at your premises.

Now is the time to get qualified.

Discover our areas of learning.

Forsythes Training is an established, trusted, quality training provider with an extensive list of corporate clients and individuals who have attended our training courses over the last twenty years in a variety of learning areas: