Advanced Crystal Reports 2008 tutorials : learn quickly/cost-effectively with this 'Advanced Crystal Reports 2

Advanced Crystal Reports 2008 CD Training Course Contents:

Before We Start

• What Will I Be Able To Do At The End Of This Course
• Using The Files Included With This Course
• Installing The SQL Server Sample Databases
• About The Tutor

Getting Up To Speed

• Creating A Report From Scratch
• Adding And Linking Additional Database Tables
• Creating A Formula Field
• Sorting Data Within A Report
• Grouping Reports
• Adding Summary Functions
• Filtering Data In The Report
• Swapping The Data-source Of A Report

Conditional Formatting

• Using The Highlighting Expert
• Changing The Order That Conditions Are Met
• Removing Highlighting Expert Conditions
• Applying ON/OFF Conditional Formatting
• Removing Conditional ON/OFF Formatting
• Font Color Controlled By A Condition
• Font Style Controlled By A Condition
• Removing Or Disabling Conditional Formatting
• Clever Conditional Formatting Alternating Page NOs
• Clever Conditional Formatting Banded Report

Advanced Formulas Using Variables

• Declaring Variables To Use In Reports
• Understanding The Multiple Pass Report Generation
• Making Use Of Multi-Pass In A Report
• Using And Outputting Multiple Variables At Once
• Using Variables In Multiple Formulas And Locations
• Creating And Using User Defined Functions

SQL And Commands

• Standard Query Language (SQL)
• Defining Your Own SQL As The Data Source
• Adding Parameters To Your Own SQL Statement

Parameter Fields

• Creating A Parameter Field And Using It To Filter Data
• Parameter Fields To Customize Formatting
• Letting The User Change The Color Of Banded Reports
• Parameter Controlled Sort Order
• Making Use Of Masks In Parameters

Report Alerts

• Adding An Alert To A Report
• Triggering A Report Alert
• Viewing Record Sets Created By Alerts
• Add A Formula To Generate The Alert Message
• Using A Parameter Value With A Report Alert

Multiple Sections

• Inserting Extra Sections By Dividing Existing Sections
• Deleting And Merging Sections
• Splitting Existing Content Between Sections
• Moving A Sections Position In A Report
• Uses For Multiple Page Header Footer Sections
• Multiple Sections Can Provide Column Headings In Drilldown Reports
• Adding Continued To Page Heading When Required

Sub Reports

• What Is A Sub Report
• Creating And Importing An Unlinked Sub Report
• Create And Insert A Linked Sub Report
• On Demand Sub Reports
• Hiding Sub Reports That Contain No Data
• Dealing With Overlapping Sub Reports
• Methods For Updating Changes Made To The Sub Report
• Pass Data Between Sub And Main Report Using Variables

Cross Tabs

• Adding A Cross Tab To A Report
• Cross Tabs Within Group Headers Or Footers
• Generating A Month Name Instead Of A Number
• Making Use Of Formulas In Cross Tabs
• Utilizing A Parameter Field To Control A Cross Tab
• Formatting A Cross Tab And Its Components
• Turning On And Off Totals
• Change The Calculation Between The Rows And Columns
• Placing More Than One Cross Tab On A Report
• Sorting A Crosstab By The Summarized Data
• Insert Multiple Rows And Or Columns
• Use The Step By Step Crosstab Wizard

Charting

• Creating A Chart in CR 2008
• Changing The Chart Type
• Formatting And Renaming The Chart Labels
• Customize The Appearance Of A Given Chart
• Sorting And Top N In Charts
• Placing Charts Within Group Headers Or Footers
• Managing Multiple Charts In A Report
• A Special Case The Pie Chart
• Charts Based On Cross Tabs

Crystal Reports Reader And Automated Report Distributor

• Downloading The Reader And The Automated Report Distributor
• Installing The Reader And The Distributor (CRD)
• Report Viewer File Management
• Running Reports In The Viewer
• Exporting Data From The Reader
• Filtering Data With The Reader
• Setup And Configure CRD
• Create A Simple Single Report Daily Schedule