COURSE INTRODUCTION
In this Crystal Reports 2011 Advanced training course, expert trainer and author Guy Vaccaro covers advanced topics and tools available to you in Crystal Reports. This course is for users that are already familiar with the basic operation of Crystal Reports, and want to get more in-depth with its capabilities.

Guys starts you off easy, with a quick review of some of the basics of Crystal Reports, and then take you right into some of the more complex features. You begin with conditional formatting then move on to working with parameter fields and report alerts. You will learn how to create multiple sections, and sub reports. Advanced charting is covered, along with cross-tabs, formulas, even a chapter on SQL commands.

Wichtige informationen

Voraussetzungen: This is a DVD Video Tutorial Course which is shipped to you. Work through the video tutorials at your own pace. If you have the software you can practice along with the instructor using the same exercise files as the instructor which are included on the DVD. The narrated training videos demonstrate the key tools and professional techniques helping you to work faster and smarter. All the concepts of each application are explained clearly and precisely. The DVD works on PC and Mac. You can jump to and from lessons and work at your own pace.

Veranstaltungsort(e)

Wo und wann

Beginn

Lage

Freie Auswahl

Distance Learning

Was lernen Sie in diesem Kurs?

Database Administration

Formatting

Parameter Fields

Reports

SQL Commands

Themenkreis

01. Introduction 0101 Am I Ready For This Advanced Course 0102 Installing And Connecting To The Sample Databases Provided 0103 Using The Working Files Effectively 0104 About The Author 0105 Swapping The Data Source Of A Report02. Revision 0201 Creating A Report Without The Wizard 0202 Adding And Linking Multiple Database Tables 0203 Making Use Of Formula Fields 0204 Overriding The Database Default Sort 0205 Filtering Data To Reduce The Quantity 0206 Grouping Data In Reports 0207 Special User Defined Groups 0208 Adding Summary Functions03. Conditional Formatting 0301 Using The Highlighting Expert 0302 Changing The Order That Conditions Are Effective 0303 Removing The Highlighting Expert Conditions 0304 Applying On/Off Conditional Formatting 0305 Font Color And Typeface Controlled By A Condition 0306 Edit/Remove/Copy/Disable Conditional Formatting 0307 Create Alternate Page Numbers Through Conditional Formatting 0308 Creating A Banded Report 0309 Formatting Controlled By Summary Values04. Parameter Fields 0401 Creating A Parameter Field To Filter Data 0402 Parameter Fields Used To Customize Formatting 0403 Letting The User Change The Color Of Banded Reports 0404 Parameter Controlled Order By 0405 Parameter Masks To Control User Input05. Report Alerts 0501 Adding And Triggering A Report Alert 0502 Editing Alerts And Viewing Triggered Values 0503 Use A Formula In The Alert Message 0504 Using A Parameter Value With A Report Alert06. Multiple Sections 0601 Creating And Managing Extra Report Sections 0602 Different Headers And Footers On Odd And Even Pages 0603 Use Split Sections To Add A Watermark 0604 Column Headings In Drilldown Reports 0605 Add Continued To Page Header For Multiple Page Groups07. Sub Reports 0701 What Is A Sub Report 0702 Creating And Importing Unlinked Sub Reports 0703 Create And Insert A Linked Sub Report 0704 On Demand Sub Reports 0705 Hiding Sub Reports That Contain No Data 0706 Dealing With Overlapping Sub Reports 0707 Methods For Updating Changes Made To Sub Reports08. Charting 0801 Creating A Chart 0802 Changing The Chart Type Of Your Chart 0803 Chart Formatting And Label Editing 0804 Multiple Series Of Data In A Chart 0805 Special Groups Within A Chart To Improve Appearance 0806 Using Top N In Charts 0807 Placing Charts In Group Headers And Footers 0808 Managing Multiple Charts In A Report 0809 A Special Chart Type The Pie 0810 Multiple Series Data Using Pie Charts09. Cross-Tabs 0901 Adding A Cross Tab To A Report 0902 Generating The Month Name As A Heading 0903 Totals On Or Off Top Or Bottom 0904 Formatting A Cross Tab And Its Components 0905 Use Of Conditional Formatting In A Cross Tab 0906 Cross-Tabs With Group Headers Or Footers 0907 Placing More Than One Cross Tab On A Report 0908 Sorting A Cross Tab By Its Summarized Data 0909 Changing The Calculation Within The Data Area 0910 Use Of A Parameter To Allow User Choice Of Grouping 0911 Insert Multiple Grouping 0912 Cross Tab Wizard Vs Manually Creation 0913 A Quick Chart From A Cross Tab10. Advanced Formulas 1001 Declaring Variables To Use In Formulas 1002 Application Of A Variable In A Report 1003 Multi Pass Reporting Explained 1004 Altering The Multi Pass In A Formula 1005 Outputting Multiple Variable Values From One Formula 1006 Using Shared Variables To Exchange Data With A Sub Report 1007 User Defined Functions11. SQL And Commands 1101 Standard Query Language (SQL) 1102 Using Your Own SQL As A Reports Data Source 1103 Adding Parameters To User Defined SQL Commands12. Summary and Beyond 1201 Investigating The Data Map Tool 1202 Distribute Crystal Reports Viewer To Non Developers1203 Were You Ready?