Call on 1300 794 006 Advanced Search

Home > Technical > Crystal Reports

Crystal Reports 2008 - Level 2 Book a course:   Location: Sydney Melbourne Brisbane Date: Choose a date... 30 May 12 - 31 May 12 13 Jun 12 - 14 Jun 12 27 Jun 12 - 28 Jun 12 11 Jul 12 - 12 Jul 12 25 Jul 12 - 26 Jul 12 08 Aug 12 - 09 Aug 12 22 Aug 12 - 23 Aug 12 05 Sep 12 - 06 Sep 12 19 Sep 12 - 20 Sep 12 10 Oct 12 - 11 Oct 12 24 Oct 12 - 25 Oct 12 07 Nov 12 - 08 Nov 12 21 Nov 12 - 22 Nov 12 05 Dec 12 - 06 Dec 12 {None} 9:00 AM - 5:00 PM 9:00 AM - 5:00 PM 9:00 AM - 5:00 PM 9:00 AM - 5:00 PM 9:00 AM - 5:00 PM 9:00 AM - 5:00 PM 9:00 AM - 5:00 PM 9:00 AM - 5:00 PM 9:00 AM - 5:00 PM 9:00 AM - 5:00 PM 9:00 AM - 5:00 PM 9:00 AM - 5:00 PM 9:00 AM - 5:00 PM 9:00 AM - 5:00 PM   Duration: 2 Days Time: 9:00 AM - 5:00 PM   Price: $1,500.00 inc. GST Print Preview | Send to a friend    Learning Method: Instructor Led Duration: 2 Days Overview: Until now, you have used Crystal Reports to build and modify reports. You want to use the advanced functionality of Crystal Reports to generate reports in the format you desire. In this course, you will create complex reports and data sources using Crystal Reports' tools. You will not only create more sophisticated reports including subreports and cross-tabs, but you will also increase the speed and efficiency of your reports by using SQL queries. 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 that make it easier for other people to create reports. They may or may not have programming and/or SQL experience. Pre-requisites: Crystal Reports® 2008: Level 1. A knowledge of programming and/or SQL would also be helpful. At Course Completion: After completing 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. Outline: Expand All Module 1: Creating Running Totals Create a Running Total Field Modify a Running Total Field Create a Manual Running Total Module 2: Working with Cross-Tabs Create a Cross-Tab Report Format a Cross-Tab Report Create Groups in Cross-Tab Reports Module 3: Adding Subreports Insert a Subreport Edit a Subreport Share Variables Module 4: Creating Drill-Downs in a Report Create a Drill-Down Create Headings for Drill-Down Data Module 5: Using SQL Statements in Report Processing Create a Report Using SQL Queries Summarise Report Data Create Joins Using SQL Create Subqueries Create a SQL Expression Field Module 6: Creating Complex Formulas Work with Loops Work with Arrays Module 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 Module 8: Enhancing Report Functionality Organise Data Based on a Hierarchy Create a Dynamic Image Create a Report Alert Create a Geographic Map Appendix A: Managing Reports Appendix B: Processing Data on the Server Appendix C: Detecting and Fixing Problems

Course Ratings Averaged from 70 responses. Instructor's Knowledge Training Quality Training Objectives Training Overall Courseware Quality What do these ratings mean? Extraordinary Great Good Average Poor Name: Company: Phone: Email: Location: BrisbaneCanberraCrn-CairnsMelbournePerthSydney How can we assist you?: Bookmark & Share

Home | Search | Site Map | Legal | Privacy Policy | Terms of Use | Contact | Links & Resources | Career Opportunities

Copyright © 2009 New Horizons Learning Centres Holdings Pty Ltd. All rights reserved. ABN: 86 168 459 086

Developed by Globe Web Services