Further Details
Course Content
Overview
Increase report design skills
Architecture
Structured query language in relation to Crystal reports
Advanced formula creation
Repository
Custom Functions
Graphs
Report Creation Review
Reviewing Report Creation
Reviewing Linking
Reviewing Record Selection
Reviewing Grouping Options
Reviewing Formula and summary Reporting
Sections
Using Sections
Formatting Sections
Multiple Sections
Dictionaries
Creating and using Dictionaries
Modifying Dictionaries
Advanced Formulas
Understanding formula language and syntax
Understanding multi-pass reporting
Running totals
Installing and Using UFL’s
Using variables
Understanding arrays
Using control structures
Conditional formatting
Using Internal Crystal key words
Parameters
Defining Parameter Fields
Creating Parameter Fields
Using Parameters in grouping
Using parameters in sorting
Wild card parameters
Subreports
Defining subreports
Creating an unlinked subreport
Creating an On Demand subreport
Passing information from a subreport to the main report
Cross-Tabs
Defining Cross-Tab objects
Creating Cross-Tabs
Formatting Cross-Tabs
Charting on a Cross-Tab summary field
Repository and Custom Functions
Adding Objects and Images to the Repository
Adding Commands via SQL
Creating Custom Functions
Converting Functions
Using Functions
Graphs and Analyses
Basic Graphs
Graphs at group level
Cross tab graphs
Top N with Graphs
Editing Graphs
Guide price
Please Call |