Users who need to develop reports that include complex formulae & functions and users who need to manipulate large volumes of data in order to produce accurate results.
Objectives:
By the end of the course users will be able to create reports which contain complex formula using variables and functions. Users will also be able to query data sources using SQL commands and expressions.
Prerequisites:
Users must be able to confidently create a report that includes sorting, grouping and summary data.
Duration:
2 Days
Cost:
£395 + VAT
Course Date
Location
Demand led
Call to request dates
More On Parameter Fields
Static & Dynamic, Pick List Parameters
Parameter Edit Masks
Sub Reports & Sections
Creating Linked & Unlinked Sub Reports
Inserting, Deleting & Merging Sections
Controlling Report Pages
Linking & Embedding Objects
Formulae Revision
If… Then… Else… Statements
More on Formulae & Functions
Crystal Syntax & Built In Functions
String & Date Functions
Variables
What is a Variable?
Declaring Variables
Calling Variables in a Formula
Referencing Array & Range Variables
Understanding Multi-Pass Reporting & Formula Evaluation
