| Crystal Reports: Advanced Tutorials Online |
 |
|
Description Crystal Reports: Advanced
Crystal Reports is one of the most popular report writing applications available today. Its ability to create complex reports from a variety of data connections (including Microsoft, Oracle, and Business Objects) is highly acclaimed. In this VTC course, expert instructor Lauri Matson walks you through the power of Crystal Reports, exploring its features and showing you how to simplify the complexities. Anyone involved in creating reports from stored data will benefit from this course. You'll become be a master of design, formulas, parameters, and more. You will learn how to create advanced reports, analyze databases and table relationships, write formulas and functions, enhance your reports with charts and graphs, and much, much more. Experience with databases and spreadsheet programs is assumed, prior knowledge of Crystal Reports is recommended. To begin learning today, simply click on the movie links. |
| Sample - Preview the First 3 chapters of Crystal Reports: Advanced video free. Free learning Crystal Reports: Advanced online. |
01 Introduction
0101 Welcome
0102 Work Files
02 Review of the Basics
0201 Planning a Report
0202 Inserting Fields
0203 The Screen Layout
0204 Hints for Formatting
0205 Grids and Guidelines
0206 Reviewing the Menus
03 Advanced Database Concepts
0301 Connection Types
0302 Using the Database Expert
0303 Database Verification
0304 Verification Options in Crystal
0305 Relationships and Joins
0306 Types of Joins
0307 Mapping Database Fields
04 Viewing Your Data
0401 Views and Queries
0402 Options and Your Data
0403 Expressions vs. Commands
05 Working with SQL
0501 SQL Command Select
0502 Combing Multiple Tables
0503 SQL Order By / Where / Alias
06 Refresher of Formulas
0601 The Basics
0602 Editing Formulas
0603 Referencing Fields
07 Formula Syntax
0701 Basic vs Crystal Syntax
0702 Syntax Continued
0703 Variable Example
0704 Using Help for Syntax
0705 Placement of Formulas
08 More Formulas
0801 Select Expression
0802 Dates and Formats
0803 Extracting from a Field
0804 Extraction Example
0805 Commonly Used Formulas
09 SQL
0901 SQL Expressions
0902 Expression Use of Select
0903 SQL Command Example
0904 Commonly Used Expressions
10 Running Totals
1001 Review of Running Totals
1002 Groups and Totals
1003 Manual Totals
1004 Conditional Totals
1005 Reset in Formula
11 Custom Functions
1101 Understanding Custom Functions
1102 Creating a Function
1103 Properties
1104 More Examples
12 Performance
1201 Indexing
1202 Indexing Continued
1203 Strategies for Performance
1204 Performance Continued
1205 Optimizing for the Web
13 Design and Creation
1301 Planning your Report
1302 Data Implications
1303 Adventureworks Schematics
14 Refresher on Cross-Tab Reports
1401 Using a Cross-Tab
1402 Formatting Cross-Tab by Design
1403 Formatting in Preview
1404 Cross-Tab Design
1405 Cross-Tab Vocabulary
1406 Cross-Tab Example
15 Subreports
1501 Inserting Subreports
1502 Formatting
1503 Subreports as Charts
1504 OnDemand and Unrelated Reports
16 Time and Variables
1601 Date and Time in Fields
1602 Date Format to Text
1603 Working with Hours
17 Groups
1701 Reviewing Groups
1702 Grouping on a Formula Field
1703 Grouping Hierarchically
1704 Working with Multiple Sections
18 Parameters
1801 Reviewing the Basic Parameter
1802 Using Multiple Values
1803 Using SQL Commands
1804 Dynamic Values
1805 Parameters and Conditional Formats
19 Charts
1901 Preparing a Report
1902 Using the Wizard
1903 Formatting
1904 Selecting a Chart Type
1905 Trendlines
1906 Conditional Formatting
1907 Charts in a Group Header
20 Mapping
2001 Creating a Map
2002 Formatting a Map
2003 Mapping Groups
2004 Groups Continued
21 Other Tips and Tricks
2101 Mailing Labels
2102 Working with Form Letters
2103 Creating Alerts
2104 Working with Alerts
2105 Adding Tool Tips
2106 Conditional Formatting
2107 Alternate Row Formatting
22 Conclusion
2201 The Viewer
2202 Dashboards and Excelsius
2203 Remember the Help Menu
2204 Wrap Up
23 Credits
2301 About the Author
sku |
|
