Crystal Reports 2011 Advanced Video Tutorial Course

CareerVision Training

£ 70 - (83 )
IVA inc.

Informazione importanti

  • Training
  • Advanced
  • A distanza
  • Durata:
  • Quando:
    Da definire
  • Invio di materiale didattico

• Format: DVD-ROM
• Duration: 7 Hours (79 lessons)
• Instructor: Guy Vaccaro
• Platform: Windows PC or Mac

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.

Informazione importanti

Requisiti: 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.


Dove e quando

Inizio Luogo
Da definire
Distance Learning

Cosa impari in questo corso?

Database Administration
Parameter Fields
SQL Commands


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 Report
02. 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 Functions
03. 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 Values
04. 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 Input
05. 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 Alert
06. 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 Groups
07. 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 Reports
08. 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 Charts
09. 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 Tab
10. 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 Functions
11. 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 Commands
12. Summary and Beyond
1201 Investigating The Data Map Tool
1202 Distribute Crystal Reports Viewer To Non Developers
1203 Were You Ready?

Ulteriori informazioni