|
Tips from our free
newsletter for Crystal Reports designers
Chelsea Technologies is the publisher
of Crystal Clear, a free newsletter of tips and hints for users of Crystal Reports
and
Seagate Info.
We published our first issue in November 1999. We
have had a great response to this and it is now finding an international
audience with hundreds of readers in New Zealand, Australia, USA and over
26 other countries.
If you have a tip to share, we will mention
your name and organisation if we publish it.
The format of the newsletter is as acrobat 6.0 PDF file. We
recommend you download the latest Acrobat reader to view this. 
The
Back issues are zipped copies of the newsletters with a separate zip file
for each year.
If you would like to be
on our mailing list then please
email
us.
We will not pass your email address to other organisations. We may sometimes
send you information about our products.
See also our sister company CrystalKiwi
blog for other tips.
Issue 71: January - March 2010
Audit who has been running your reports using the Share UFL; extract the
date value from a DateTime Field using SQL; Email multiple HTML messages
from one report; New CrystalCalendar utility to build a report on a date
range; Exporting memo fields to CSV; How to calculate Geometric Means; How
to handle Numeric Overflow when calculating a geometric mean
Issue 70: October - December 2009
Field Mapping in Subreports; New Crystal Reports 2008 versions of cView and
cViewSERVER; improvements to XML and Share UFL; Crystal Reports 2008 Service
Packs and Fix Packs; Radar Charts; Crystal Reports 2008 User Guide; 32 bit
and 64 bit support in Crystal Reports; HTML tag support in Text
Interpretation;
Issue 69: July - September 2009
Use your file system as a data source; When are variables calculated?
Combine records with a cartesian join to the same table; Thermometer and
Gauge charts; Where to find the Days360 function; Splitting a
string;Conditionally suppress a column in a crosstab; Page numbers in a
large report header section;
Issue 68: April-June 2009
Page Headers in a subreport; Book Review: Crystal Reports 2008 by
George Peck; How to use Optional parameters in record selection;
How to display optional parameters in a report heading; Days360
function; UpFrom and UpTo in ranges; UNION vs UNION ALL; On Demand
SubReport to perform a special action; ODBC on 64 bit Windows; SAP User
Conference details;
Issue 67: January- March 2009
Time Zone adjustments in older versions of Crystal Reports; Displaying
Minutes as Hours and Minutes; Using Hierarchical Summaries in formulas using
DisplayString; Sculpture on the Shore 2008; Column Sequence in a report;
trigonometric functions in Formulas; Where to store dynamic images; How to
tab the explorers; How to read CHM files on Windows Vista; Report Title
special field in a subreport
Issue 66: July - September 2008
Time Zone explanation; Time Zones in Crystal Reports; Time Zone Functions;
ShiftDateTime example; Time Zones with Dynamic Dates in cViewSERVER and
cViewMANAGER; How to deliver a confidential report; Embedded Summaries in a
Crosstab in Crystal Reports 2008; Percentage Summaries in a Crosstab; Use
the Workbench to manage your projects; Evaluation Times are important to
understand;
Issue 65: April - June 2008
Problem with date formula in Leap Year; Use Share UFL to improve report
performance; Use a comments formula to keep a version history; Use two page
footers for odd/even professional page numbering; IIF() and IF THEN ELSE
don't do the same thing; DateDiff for monthly date differences; Drill down
on two fields at one level; Use DrillDownGroupLevel to customise your page
heading; New Crosstab Grid Functions in Crystal Reports 2008; Creating a
Calculated Member in a Crosstab; XNPV and XIRR functions; Create multiple
export files with the Grid UFL
Issue 64: January - March 2008
General comments on Crystal Reports 2008;
Demonstration files for Crystal Reports 2008; Section Expert
improvements; Introduction to crosstab improvements; Grouping improvements
in recent versions; IRR Function; Where User Function Libraries are
installed.
See previous years Index of subjects:
2007
2006
2005
2004
2003
2002
2001
2000
1999
|
Are you looking
for a cost-effective way to schedule your reports?
See
cViewSERVER
for a Windows Service solution. Benefit: The
machine does not need to be logged on
See
cViewMANAGER
for a scheduler on your desktop
Do you want your
users to view your Crystal reports in a very cost-effective way?
See
cView viewer
Are you looking
for a way to display images in your reports?
See
cViewIMAGE
You may
download a pdf of our back issues below
Our most current issue
Crystal Clear 71
Jan-Mar 2010
2010
2009
2008
2007
2006
2005
2004
2003
2002
2001
2000
1999
Sister company blog CrystalKiwi
|