Crystal Reports XI - Level 2

STATE CITY NSW QLD VIC WA Sydney DATE Choose a date... 23 Apr 15 - 24 Apr 15 20 May 15 - 21 May 15 21 May 15 - 22 May 15 21 May 15 - 22 May 15 17 Jun 15 - 18 Jun 15 18 Jun 15 - 19 Jun 15 08 Jul 15 - 09 Jul 15 09 Jul 15 - 10 Jul 15 05 Aug 15 - 06 Aug 15 What is OLL? PRICE DURATION $1,620.00 inc. GST 2 Days COURSE REGISTRATION I'm based in...* NSW NT QLD SA TAS VIC WA Human Test: 4 + 5 = Overview: 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 to make it easier for other people to create reports. They may or may not have programming and/or SQL experience. Target Audience: 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 to make it easier for other people to create reports. They may or may not have programming and/or SQL experience. Pre-requisites: Crystal Reports® XI - Level 1 or equivalent knowledge. Knowledge of programming and/or SQL would also be helpful. At Course Completion: Upon successful completion of this course, students will be able to: Create automatic and manual running totals. Work with cross-tab reports. Add subreports. Create drill-downs in a report. Use SQL statements in report processing. Create complex formulas. Add charts to reports. Enhance report functionality. Show more Outline: Expand All 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 a Primary Report Edit a Subreport's Structure Format a Subreport Using the Format Editor Share Variables Between Subreports and Primary Reports 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 by Writing SQL Statements Create a report Using SQL Queries Summarize Report Data Using SQL Aggregate Functions Create Joins Using SQL Create Subqueries Create a SQL Expression Field Lesson 6: Charting Data Create a Bar Chart Modify a Chart Format a Chart Create a Chart Template Create a Top N Chart Create a Cross-tab Chart Lesson 7: Reporting on Excel Data with Crystal Reports Create a Report Based on Excel Data Modify a Report Generated from Excel Data Update Data in a Report Based on Excel Data Lesson 8: Working with Prompts Create a Static Prompt Create a Dynamic Prompt Lesson 9: Enhancing Report Functionality Group Data Hierarchically Create a Dynamic Image Create a Report Alert Create a Geographic Map	Course Ratings Averaged from 234 responses. Overall Satisfaction
CODE:XI-0-NH85518S-ILT

Choose your nearest New Horizons location below to view our EOCY offers:
BRISBANE	MELBOURNE	SYDNEY