This Crystal course is for users who are comfortable with designing basic reports and Excel formulae and functions. Learn to work with multi-section reports, parameter queries, cross tab reports and to get accurate results using sophisticated formulae.
- Course Outline
Advanced Crystal Reports
This is a 2-day hands-on, instructor-led course.In this course, participants build on what they learned in our Introduction to Crystal Reports course. The course is two days in duration. Class size is limited to six participants. Topics covered include:
· Review of the basics · Additional Fields and Formats
inserting special fields
inserting fields in text objects
inserting pictures · Sorting, Grouping and Summarizing
modifying group options
creating specified groups
inserting subtotals, grand totals, summaries
inserting running totals
using the Top N Sort/Group Expert · Creating Formulae
using the Formula Editor
creating formulae using string functions
using if-then-else formulae
nesting if-then-else statements · Working With Sections
using drill-down reports · Linking
using the Visual Linking expert · Working With Multiple Sections
inserting, splitting, moving, merging
and deleting sections
formatting objects conditionally
alternating background colours for rows
eliminating blank lines when fields are empty
eliminating blank lines conditionally
creating watermarks · Conditional Formatting
absolute vs. conditional formatting
inserting a new page after a certain group
adding borders to specific groups · Parameters
creating, using and modifying parameter fields
report title parameters · Cross Tabs
creating and formatting cross tab reports · Advanced Formulae
multiple statement formulae
using variables in formulae
variable arrays · Subreports
combining unrelated reports using subreports
using subreports with unlinkable data
displaying different views of the same data
on-demand subreports · Report Distribution
exporting a report to another format
- Prerequisites & Certificates
Good working knowledge of basic Crystal features including creating queries and reports.
Participants will receive: - a manual - files used during the classes - a certificate of completion Fee includes 6 months of free telephone or e-mail support on topics covered during the course.
- Cancellation Policy
- Map & Reviews
Neilson & Associates
[ View Provider's Profile ]
This course has not yet been rated by one of our members.
If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.
This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.
This page has been viewed 307 times.