The
Expert's
Guide to Totals in Crystal Reports
Just $24 - Immediate
Download
using
Visa/MC/Amex/Disc
Did
you know
that there are at least 4 different methods for creating totals in a
Crystal Report? Many people paint themselves into a corner by
using the wrong method. Why
not let a master teacher show you each of these methods, and when they
should be used. I have explained these methods to hundreds of
students and my explanations and exercises have been refined
and
rewritten through
10 years of teaching. Let me share this experience with you
through my new book, The
Expert’s Guide
to Totals in Crystal Reports.
The
material includes an in depth discussion of each feature, example
reports that
illustrate the techniques, and exercises that walk you
through each step. The exercises are the key. They
have
been written to provide practical examples that are easy to understand
and follow. Also included
are several relevant articles borrowed from my Expert
Techniques for Crystal Reports Vol. I and II. The
material
is condensed
into 35 no-nonsense pages and is backed up with 24 sample
reports. The exercises provide keystroke by keystroke
instructions to implementing each of the discussed features.
The
material is
primarily applicable
to versions 8.5, 9, 10 and 11 and the sample reports
can
be
opened
with any of these Crystal versions. Most of the
material
can be applied to older versions as well and an appendix is supplied to
discuss the differences.
The
Expert’s Guide
to Totals in Crystal Reports costs only
$24 and
you can
download
it immediately using any major Credit Card. You can also send
a
PayPal payment
to
my
Email address and you should have the material within 24
hours.
If you
prefer
to mail me a check, please include your Email address and make the
check
payable
to:
Ken
Hamady
525K East Market St.
PMB
#299
Leesburg, VA 20176
I also provide
Email support
and
telephone training on any Crystal Reports topic. I charge
$140
per hour
billed in 15 minute increments. This is a great way to learn
Crystal technique, one-on-one, with a Crystal Reports expert.
Outline
of The
Expert's Guide to Totals in Crystal Reports:
Summary
Fields
Creating a Summary Field
Changing a Summary Field
Using
Summary Functions in Filters
Adding a Group Selection Rule
Understanding how Group Selection is Different from Record Selection
Writing a Group Selection Formula
Using
Summary Functions to Rank Groups
Using
Summary Functions in Formulas
Using Grand Totals in a calculation
Using Subtotals in a
calculation
Conditional
Totals
Creating a Conditional Total
Advantages of Conditional Totals over Running Totals
Manual Cross-Tabs from Conditional Totals
Automatic
Running Totals
Creating a Running Total
Using the Evaluate setting
Using Reset to Creating Running Subtotals
Running
Totals using variables
The Running Grand Total
The Running Subtotal
Accumulating values once per group
Totaling the values from a recurring Subreport
Tips
and
Tricks
21. Forcing a formula to return a Null value
23. Reasons to group on a formula that contains a database field,
instead of the field itself
25. The easy way to add the Distinct Counts of several groups, and get
a grand total
35. Grouping subtotals into ranges
55. Show groups when an individual record in the group meets criteria
56. Select Groups that are missing a specific type of record
Appendix
for Versions before v9
Summary Fields
Conditional Totals
Group Sorting/TopN
Running Total Fields
Running Totals with Variables
Back
to KenHamady.com