Crystal Reports:
Analyze your address book with Crystal Reports

You can use a wide variety of data sources for your Crystal Report. Recently, we used Crystal Reports to analyze the mailing list for Crystal Clear. We just wanted to see where Crystal Clear is distributed. 

The first step was to use Outlook as our data source, and the Contact Folder where we keep all your email addresses.  A simple formula picked up the top level domain (.nz, .com, .au, .uk, etc.) from the address, we then made the report a summary/drill down report. 

There are many of you. Our local New Zealand readership is the largest group followed closely by all the .com addresses (which is primarily in the United States). We have a large readership from Australia, United Kingdom, Canada and the Netherlands. It was also interesting to see individuals from over 20 other countries. You know who you are and we are delighted we have a newsletter you appreciate.

This article is copyrighted by Crystalkeen, Mindconnection, and Chelsea Technologies Ltd. It may be freely copied and distributed as long as the original copyright is displayed and no modifications are made to this material. Extracts are permitted. The names Crystal Reports and Seagate Info are trademarks owned by Business Objects.