Sunday February 5, 2012  
About Us
Info Request
Forums
Careers
Contact
--
REM Products
Training and Education
   Anvil Certification
   HEAT End User
   HEAT Administration
   Goldmine Introduction
   Goldmine Advanced
   Crystal Reports Introduction
   Crystal Reports Advanced
Professional Services
Partner Pavilion
Downloads
Support
Sample Videos
Authorized Resellers
Customer Testimonials
Purchase Software
---
Anvil

Frontrange Tech Partner
 
Training and Education


"You took the time to work with my technicians and teach them how to use the product. You are always there to support us when we get in over our head and for that I appreciate that you appreciate the meaning of SERVICE! "
-- Saga Solutions

"The Anvil product allows us to synchronize our Goldmine data as well as push our legacy data to our workstations in very little time. With any product there was a certain amount of growing pains and with little documentation available for this product we relied heavily on The Trainer?s for support who in turn had to obtain direct support from Anvil. The commitment to make the product a success was always there from all parties. Overall, the product is now working well and we are building on its framework to automatically push sales leads to Goldmine and thus saving much manual entry work that was done in the past. We look forward to its continued use as we expand our CRM initiatives."
-- Can Par

Crystal Reports Advanced

Overview

This two-day course is designed to build on the topics learned in Report Design Introduction to increase report design skills and discover the reporting power of Crystal Reports. Along with hands-on practice, the course covers grouping options, formulas such as variables and functions, geographical mapping, parameters, cross-tabs, and report distribution.

Audience

Learners who want to further develop their basic report design skills using Crystal Reports

Prerequisites:

Learners must have taken the Report Design Introduction course and/or understand basic report design concepts such as linking, record selection, sorting, grouping, summarizing, basic formulas, conditional reporting and section formatting. Learners who have not completed Report Design Introduction course should complete the prerequisite exercise and bring it to class.

Topics Covered:

Report Creation Review

Grouping Options

Applying specified order grouping

Using the Top N/Sort Group Expert

Creating a group selection based on summary information

Grouping on Date or Date/Time fields

Grouping data hierarchically

Sections

Using sections

Formatting sections

Formulas

Understanding formula language and syntax

Using functions and operators

Using variables

Using an If-Then-Else control structure

Parameters

Defining parameter fields

Creating parameter fields

Using parameter fields

Geographical Mapping

Defining Geographical Mapping

Creating a map based on summarized data

Creating a map based on detail or formula fields

Editing a map with the Map Expert

Editing a map on the Analyzer tab

Resolving data mismatches

Cross-Tabs

Defining Cross-Tabs

Creating a Cross-Tab

Formatting Cross-Tabs

Charting on a Cross-Tab summary field

Mapping on a Cross-Tab summary field

Report Distribution

Exporting reports

Viewing reports over the Web