Chelsea Technologies Ltd - Crystal Clear newsletter

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.

Index 2010

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

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.

See previous years Index of subjects: