About Us Courses Schedules Learning Options Certifications Training Rooms Skills Testing Case Studies Events Contact Us
Training Information Technology Forsythes Group
Courses & Certifications Desktop Applications Microsoft Product Courses Microsoft Word Courses Microsoft Excel Courses Microsoft Access Courses Microsoft Outlook Courses Microsoft Project Courses MS PowerPoint Courses Updating to Office 2007 InfoPath 2003 Microsoft Visio Microsoft Publisher Microsoft Frontpage Windows XP Adobe Product Courses Adobe Acrobat 8 Adobe InDesign CS Photoshop CS Courses Adobe Photoshop CS-3 Adobe Illustrator CS Adobe Flash CS3 Dreamweaver 8 Dreamweaver MX MYOB Accounting Corel Draw v12 Crystal Reports Level 1 Crystal Reports Level 2 Technical Professional Development Need further information on Crystal Reports Courses? Click here Enrollment form Crystal Reports -Intermediate - Level 2 Level 2 Course start date: 27-Nov-2008, 25-Feb-2009, 22-Apr-2009, 24-Jun-2009 Training Location 9 Denison St, Newcastle West Duration: 1 Day Price: $550.00 Inc GST Overview 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. 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 IT & Training provides instructor led computer training on the Microsoft Office and Adobe range of applications. We service Newcastle, the Hunter Valley, Lake Macquarie and the 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.

	2008 Forsythes IT & Training - All Rights Reserved	Privacy Policy	Terms & Conditions	Site Map	Links & Resources	Home	Website Design - Indelible Image