Chelsea Technologies Ltd

Crystal Clear Newsletter

Home Products Services Download Resources Purchases Help

Index

Subject

Samples


1999

2000

2001

2002

2003

2004

2005

2006

2007

2008

2009

 

 

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,  Seagate Info and Crystal Enterprise.  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.

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 contact us by email. We will not pass your email on to other organisations or use your address for unsolicited marketing purposes.


Index 2009

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


Index 2008

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.

Back Issues

1999
2000
2001
2002

2003
2004
2005
2006
2007
2008
2009

 current issue  
Crystal Clear 70
Oct-Dec 2009


Sample Report Files

Sales Calendar

Calendar Report

Running Totals in a Crosstab

Wrapping Crosstab

PDF Drill Down

Crosstab calculations

Hierarchical Summary in a formula

 

Bruce Ferguson & Mo Naughton
Copyright © 2010 Chelsea Chelsea Technologies Ltd. All rights reserved.
Revised: January 26, 2010.