Chelsea Technologies Ltd - Crystal Clear subject index

Chelsea Technologies Ltd - Crystal Clear

Home	Products	Services	Download	Resources	Purchases	Help

CrystalKiwi Site

Index

Subject

1999

2000

2001

2002

2003

2004

2005

2006

2007

2008

2009

Index by subject

A very important question to ask of every report	Issue 26: March/April 2002
Accidentally upgraded to Crystal Reports 9.0?	Issue 39: January 2004
Acrobat versions of manuals on the CD	Issue 38: July/August 2003
Adjust page number	Issue 24: December 2001
Age formula as a custom function	Issue 41: May 2004
Aggregate data in SQL using GROUP BY	Issue 21: August 2001
Alert Function	Issue 16: March 2001
An easy way to see the SQL behind your report	Issue 20: July 2001
Analyze your address book with Crystal Reports	Issue 26: March/April 2002
Another age calculation	Issue 23: November 2001
Applications mixing versions of Crystal Reports	Issue 38: July/August 2003
Artistic Interlude: Liam O'Neill Outdoor Wooden Sculpture	Issue 48: December 2004
Artistic Interlude: Sculpture On Shore 2004	Issue 47: November 2004
Atomic Principle in database design	Issue 42: June 2004
Audit your reports with additional Crystal Reports	Issue 52: January 2005
Audit your reports with Share UFL	Issue 71: January-March 2010
Automatic 4-4-5 account period formulas	Issue 26: March/April 2002
Average can be Mean, Median or Mode	Issue 42: June 2004
Avoid reset of variables in repeated headers	Issue 28: August 2002
Background colors on a section	Issue 30: November 2002
Backup your rpt files	Issue 04: February 2000
Bar code reports	Issue 07: May 2000
Be careful rounding negative numbers	Issue 32: January 2003
Be careful with smart linking	Issue 26: March/April 2002
Benchmark reports with Performance Information	Issue 42: June 2004
Blank labels at the top of the first page	Issue 61: March/April 2007
Book Review: Code Complete by Steven McConnell	Issue 37: June 2003
Book Review: Crystal Reports 9 - The Complete Reference by George Peck	Issue 33: February 2003
Book Review: Crystal Reports 10 - The Complete Reference by George Peck	Issue 43: July 2004
Book Review: Crystal Reports XI - The Complete Reference by George Peck	Issue 54: March 2006
Book Review: Crystal Reports 2008 - The Complete Reference by George Peck	Issue 68: April-June 2009
Book Review: SAMS Teach Yourself Crystal Reports in 24 Hours by Joe Estes	Issue 32: January 2003
Book Review: The Inmates are running the asylum by Alan Cooper	Issue 44: August 2004
Book Review: Visual Basic.NET Strategies, Concepts and Code by Dan Appleman	Issue 38: July/August 2003
Boolean algebra to negate an AND clause	Issue 42: June 2004
Box and Line formatting options	Issue 62: July/August 2007
Broadcast license requirements	Issue 30: November 2002
Build SQL from your report	Issue 37: June 2003
Business Objects to buy Crystal Decisions	Issue 38: July/August 2003
Business Objects purchase Crystal Decisions	Issue 39: January 2004
Business Objects User Conferences	Issue 47: November 2004
Business Objects User Conference in Orlando (November 2005)	Issue 52: January 2005
Business Objects XI Road Show	Issue 49: January/February 2005
Business Views - a beginners guide	Issue 42: June 2004
Calculating business days	Issue 12: October 2000
Calculate a specific day in next month	Issue 57: August 2006
Calculate a week number using formulas with variables	Issue 53: February 2006
Calculated Member in a Crosstab	Issue 65: April - June 2008
Calendar project introduction	Issue 24: December 2001
Calendar project: calculating calendar days	Issue 25: January/February 2002
Calendar report shows the full month if it starts on Friday or Saturday	Issue 61: March/April 2007
Calendar Report with wrapping on the top row.	Issue 62: July/August 2007
Calendar Report with thresholds	Issue 60: January/February 2007
Carry forward a value to next months report	Issue 63: September/October 2007
Cartesian Join to combine data from the same table	Issue 69: July-Sept 2009
Cascading Pick List in Crystal Reports XI	Issue 58: October 2006
CAST function in SQL	Issue 23: November 2001
CDUGNA 2004 Conference in New Orleans - report and photos	Issue 42: June 2004
Changing selection formula on a web page	Issue 11: September 2000
Changing the data file location at run time	Issue 06: April 2000
Chart synchronization in Calendar Project	Issue 27: July 2002
Chart templates to copy chart design	Issue 39: January 2004
Charts and underlay	Issue 27: July 2002
Check for divide by zero	Issue 54: March 2006
Column layout and sequence on the page	Issue 67: January/March 2009
COM data sources as a gateway to your legacy data	Issue 35: April 2003
Combine Alerts	Issue 28: August 2002
Conditional change of the color of a line	Issue 22: September/October 2001
Conditional column color in Crystal Reports XI	Issue 50: August 2005
Conditional formatting documentation	Issue 61: March/April 2007
Conditional page breaks	Issue 14: December 2000/January 2001
Conditional running totals	Issue 21: August 2001
Conditionally Suppress a column in a crosstab	Issue 69: July-Sept 2009
Conference news	Issue 22: September/October 2001
Conference news	Issue 40: Feb/Mar 2004
Conference news: Insight 2004	Issue 46: October 2004
Confidential Report Delivery	Issue 66: July/September 2008
Control export of your report in visual basic	Issue 21: August 2001
Convert Null to Default	Issue 09: July 2000
Copy format from one object to another	Issue 17: April 2001
Count Thursdays between two dates	Issue 34: March 2003
Crosstab analysis by day of week	Issue 63: September/October 2007
Crosstab features covered in previous issues	Issue 48: December 2004
Crosstab functions in Crystal Reports 2008	Issue 65: April - June 2008
Crosstab improvements in Crystal Reports 2008	Issue 64: Jan - Mar 2008
Crosstab wrapped into multiple groups on the page	Issue 44: August 2004
Crosstab summaries used in calculations inside the crosstab	Issue 56: May 2006
Crystal Analysis 10 now released	Issue 39: January 2004
Crystal Calendar Utility to generate date/time records	Issue 71: January-March 2010
Crystal Enterprise Installation	Issue 24: December 2001
Crystal Enterprise login via URL	Issue 24: December 2001
Crystal Enterprise 9.0 released	Issue 33: February 2003
Crystal Reports 8.5.	Issue 16: March 2001
Crystal Reports 9.0 charts	Issue 31: December 2002
Crystal Reports 9.0 developer and SQL improvements	Issue 28: August 2002
Crystal Reports 9.0 dictionary and SQL designer tools	Issue 33: February 2003
Crystal Reports 9.0 highlighting	Issue 30: November 2002
Crystal Reports 9.0 new features including new explorers, new toolbars, cross tab improvements and the formula workshop	Issue 29: September/October 2002
Crystal Reports 9.0 released	Issue 28: August 2002
Crystal Reports 9.0 repository	Issue 30: November 2002
Crystal Reports 9.0 SQL commands	Issue 30: November 2002
Crystal Reports 10.0 preview	Issue 38: July/August 2003
Crystal Reports 10.0 new special fields	Issue 41: May 2004
Crystal Reports 10.0 new features	Issue 39: January 2004
Crystal Reports XI printer settings	Issue 61: March/April 2007
Crystal Reports XI/R2	Issue 60: January/February 2007
Crystal Reports 2008 announced	Issue 63: September/October 2007
Crystal Reports 2008 general improvements	Issue 64: Jan - Mar 2008
Crystal Reports 2008 demonstration files	Issue 64: Jan - Mar 2008
Crystal Reports 2008 Service Packs and Hot Fixes	Issue 70: October/December 2009
Crystal Reports 2008 User Guide	Issue 70: October/December 2009
Crystal Reports and SQL	Issue 47: November 2004
Crystal SQL designer	Issue 20: July 2001
Currency as a numeric label	Issue 25: January/February 2002
Custom formulas	Issue 31: December 2002
Custom function: age	Issue 41: May 2004
Custom function: Day in the Year	Issue 44: August 2004
Custom function: ordinals (1st, 2nd, etc)	Issue 42: June 2004
Custom function: pad a string field to a fixed length	Issue 43: July 2004
Customize group name	Issue 10: August 2000
cView to View Crystal Reports	Issue 32: January 2003
cView now supports Crystal Reports 9.0	Issue 32: January 2003
cView 8.17 and 9.17 now available	Issue 39: January 2004
cViewIMAGE 3.1 is bigger and better	Issue 43: July 2004
cViewPICK to update parameter pick lists	Issue 33: February 2003
cViewPICK to update parameter pick lists	Issue 58: October 2006
cViewSQL to update your database	Issue 44: August 2004
cViewTEXT for dynamic text files in your report	Issue 43: July 2004
cViewTEXT to retrieve multiple text files into your report	Issue 53: February 2006
Daily chart in a report	Issue 26: March/April 2002
Date Conversion - from "21Jan2003" to a date field	Issue 32: January 2003
Date groups	Issue 10: August 2000
Date literals if you are outside the USA	Issue 45: September 2004
Date parameters on the Crystal Component Server	Issue 13: November 2000
Date ranges in the calendar report	Issue 61: March/April 2007
DateDiff function	Issue 12: October 2000
DateDiff calculating monthly differences	Issue 65: April - June 2008
DateSerial function	Issue 45: September 2004
Date Time fields at midday and midnight	Issue 52: January 2005
Daylight Savings causes problems in formulas	Issue 51: October/November 2005
Daylight Savings dates change in New Zealand in 2007/2008	Issue 62: July/August 2007
Days360 Function	Issue 68: April-June 2009
Days360 Function - where to find it?	Issue 69: July-Sept 2009
Discussion on rounding	Issue 08: June 2000
Discussion on rounding totals	Issue 09: July 2000
Display "continued" in repeated group header section	Issue 28: August 2002
Display Ditto (") for duplicate fields	Issue 33: February 2003
Display a superscript in a field	Issue 23: November 2001
Display array values	Issue 16: March 2001
Display Minutes as Hours and Minutes	Issue 67: January/March 2009
Display one word in a different color using html text interpretation	Issue 21: August 2001
Display Range values with "No Upper Bound"	Issue 40: Feb/Mar 2004
Display String Format Option	Issue 37: June 2003
Distinct Count total at higher level	Issue 41: May 2004
DLL utilities (DSX32 and Modules)	Issue 16: March 2001
Document your report with a History formula rather than use the Report Comments	Issue 65: April - June 2008
Don't change database values unless you need to	Issue 45: September 2004
Don't use reserved words in database design	Issue 25: January/February 2002
DrilldownGroupLevel function to create a custom page header	Issue 65: April - June 2008
Drill down on two fields at one level	Issue 65: April - June 2008
Drill down reports	Issue 03: January 2000
Drill down with PDF export reports	Issue 55: April 2005
Drill down with text objects	Issue 63: September/October 2007
Dynamic Ascending/Descending sort in Crystal Reports XI	Issue 50: August 2005
Dynamic and Cascading pick lists in Crystal Reports XI	Issue 50: August 2005
Dynamic crosstab	Issue 15: February 2001
Dynamic Dates with Time Zones in cViewSERVER and cViewMANAGER	Issue 66: July/September 2008
Dynamic groups and Ascending/Descending sequence using parameters	Issue 31: December 2002
Dynamic Image File Location	Issue 67: January/March 2009
Dynamic Images in a Report	Issue 34: March 2003
Dynamic Images in Crystal Reports XI	Issue 52: January 2005
Dynamic number of groups	Issue 33: February 2003
Dynamic Pick List in Crystal Reports XI	Issue 58: October 2006
Dynamic TopN report	Issue 28: August 2002
Dynamic TopN or BottomN report	Issue 33: February 2003
Dynamic TopN in Crystal Reports XI	Issue 50: August 2005
Easy guide to custom colors	Issue 30: November 2002
Edit Masks to correct parameter input	Issue 36: May 2003
Embedded summaries in a crosstab in Cr 2008	Issue 66: July/September 2008
EQV Boolean operator	Issue 44: August 2004
Evaluation Times are important	Issue 44: August 2004
Excel Export improved with our Grid UFL	Issue 66: July/September 2008
Exclude records from one table based on another table	Issue 61: March/April 2007
Exclusive OR in a Boolean formula	Issue 43: July 2004
Explorer Layout	Issue 67: January/March 2009
Export Memo Fields to CSV using the Grid UFL	Issue 71: January-March 2010
Export multiple files from your report using a UFL	Issue 65: April - June 2008
Export multiple HTML messages from one report	Issue 71: January-March 2010
Export part of your report using a UFL	Issue 39: January 2004
Export to Excel - useful techniques	Issue 32: January 2003
Extract a date value from a date-time field using SQL	Issue 71: January-March 2010
Extracting digits from a number	Issue 01: November 1999
Extracting file name from Path and File Name	Issue 17: April 2001
Extract sentences from a memo field	Issue 45: September 2004
Field Heading placement	Issue 47: November 2004
Field Mapping in Subreports	Issue 70: October/December 2009
File and report options in CR8.0	Issue 23: November 2001
File System as a data source	Issue 69: July-Sept 2009
File User Function Library released	Issue 40: Feb/Mar 2004
Find button to search your report	Issue 36: May 2003
Finding where parameters are being used	Issue 18: May 2001
Fix, Int and Truncate treat negative numbers differently	Issue 32: January 2003
Format graphic	Issue 24: December 2001
Formula challenge	Issue 13: November 2000
Formula for Birthday (this year) and Age (in years)	Issue 22: September/October 2001
Formula that returns a NULL value	Issue 63: September/October 2007
Formula to sort two dimensional product codes	Issue 58: October 2006
Free book for CR developers	Issue 37: June 2003
Gantt Chart to display a range of data	Issue 49: January/February 2005
Gauge chart quality bands	Issue 69: July-Sept 2009
Gauge chart to display your data	Issue 49: January/February 2005
Geometric Mean: how to calculate in your report	Issue 71: January-March 2010
Group by a field more than once	Issue 54: March 2006
Group Expert improvements	Issue 47: November 2004
Group Expert to manage your groups easily	Issue 46: October 2004
GroupName function	Issue 63: September/October 2007
Grouping improvements in recent versions	Issue 64: Jan - Mar 2008
Grouping on a formula and drill down report headings	Issue 03: January 2000
Grouping on a parameter	Issue 10: August 2000
Guidelines	Issue 05: March 2000
Heading list of multi value ranges	Issue 23: November 2001
Hierarchical group level	Issue 28: August 2002
Hierarchical grouping	Issue 13: November 2000
Hierarchical Group nesting in CR11	Issue 45: September 2004
Hierarchical group changes in Crystal Reports XI	Issue 50: August 2005
Hierarchical summaries in CR8.5	Issue 18: May 2001
Hierarchical summaries in formulas	Issue 54: March 2006
Hierarchical summaries in a formula using DisplayString	Issue 67: January/March 2009
Horizontal bar chart to mimic a Gantt chart	Issue 49: January/February 2005
Hot keys in Crystal reports to select design or preview window	Issue 55: April 2005
Hotkeys to cycle through windows applications and reports	Issue 56: May 2006
Hotkeys to cycle through applications	Issue 57: August 2006
How can you secure a report? (Reasons and Question)	Issue 39: January 2004
How Many bits does Crystal Reports support?	Issue 70: October/December 2009
How to change the decimals to suit the number	Issue 07: May 2000
How to compile reports with CR8	Issue 07: May 2000
How to export reports to PDF with CR8	Issue 07: May 2000
How to get the group tree back	Issue 61: March/April 2007
How to view CHM (Compiled Help) files on Windows Vista	Issue 67: January/March 2009
How to remove surplus blank pages from middle of report	Issue 19: June 2001
How to structure report and subreport	Issue 21: August 2001
HTML export hint	Issue 29: September/October 2002
HTML Tags	Issue 24: December 2001
HTML Tag support in Text Interpretation	Issue 70: October/December 2009
Hyperlink fields	Issue 11: September 2000
IIF() does not behave the same as IF THEN ELSE	Issue 65: April - June 2008
Images and Fonts not appearing as expected	Issue 57: August 2006
IMP Boolean operator	Issue 45: September 2004
Improve performance with Page N of M	Issue 15: February 2001
Improve performance with our Share UFL	Issue 65: April - June 2008
Include all data in your database design	Issue 47: November 2004
Include deleted data in your database design	Issue 46: October 2004
Identify the last group in a report	Issue 52: January 2005
Index by Subject (as at December 2002)	Issue 32: January 2003
Index for 1999 issues	Issue 13: November 2000
Index for 2000 issues	Issue 13: November 2000
Index for 2001 issues	Issue 24: December 2001
Index for 2002 issues	Issue 31: December 2002
Index in a page footer	Issue 14: December 2000/January 2001
Insert Summary changes in Crystal Reports XI/R2	Issue 60: January/February 2007
International Function Library (see here for example)	Issue 16: March 2001
IRR function	Issue 64: Jan - Mar 2008
Is that day in the weekend?	Issue 51: October/November 2005
IsBusinessDay function in Seagate Info 7.	Issue 13: November 2000
Java engine with e-learning modules	Issue 41: May 2004
Join and Split functions	Issue 16: March 2001
Join tables together with UNION join	Issue 20: July 2001
Keep Together Subreports and Crosstabs	Issue 34: March 2003
Keep Together to avoid blank pages	Issue 43: July 2004
File User Function Library released	Issue 40: Feb/Mar 2004
Label Report sizing with a Text Object and Using Object Size and Position	Issue 43: July 2004
Last Day in Month Formula	Issue 55: April 2005
Last Friday/Wednesday in the month formula	Issue 55: April 2005
Leap Year problem in formulas	Issue 40: Feb/Mar 2004
Left joins and record selection	Issue 41: May 2004
Left join problem solved with SQL	Issue 46: October 2004
List Your Crystal Reports with a Crystal Report	Issue 47: November 2004
Loading a parameter value using the OCX control	Issue 18: May 2001
Loading record selection formula via the OCX control	Issue 19: June 2001
Mailto hyperlink can include other fields	Issue 44: August 2004
Microsoft CRM integration with Crystal Reports	Issue 40: Feb/Mar 2004
Microsoft Reporting Services comparison	Issue 39: January 2004
Microsoft Tech Ed 2003 in Auckland	Issue 38: July/August 2003
Microsoft Tech Ed 2003 in Auckland	Issue 39: January 2004
Microsoft Tech Ed 2005 in Auckland	Issue 51: October/November 2005
Microsoft Tech Ed 2006 in Auckland	Issue 58: October 2006
Minimize all windows with a hot key	Issue 54: March 2006
Missing data at the beginning or end of a report	Issue 09: July 2000
Missing data in a report.	Issue 08: June 2000
Missing data in a report summary	Issue 47: November 2004
Missing date groups	Issue 12: October 2000
Missing last day from record selection	Issue 19: June 2001
Missing weeks and days in a group	Issue 13: November 2000
Multiple sections to select alternate formats	Issue 56: May 2006
Multiple column reports can include Groups	Issue 63: September/October 2007
Negative numbers display with CR or OD suffix	Issue 61: March/April 2007
New € symbol you may need	Issue 25: January/February 2002
New features in Crystal Reports XI	Issue 49: January/February 2005
New Orleans conference dates (2004)	Issue 41: May 2004
New product Crystal Analysis Professional 8.0	Issue 22: September/October 2001
New product Report Analyzer	Issue 22: September/October 2001
Not Equal Join between tables	Issue 36: May 2003
NPV function	Issue 63: September/October 2007
NthLargest Summary to award the silver and gold medals	Issue 44: August 2004
NULL values in a report	Issue 23: November 2001
Number of days in the month formula	Issue 55: April 2005
Numeric Overflow with Geometric Mean	Issue 71: January-March 2010
ODBC on 64 bit Windows	Issue 68: April-June 2009
OLAP as a data source in your report	Issue 58: October 2006
OLAP grid inside your report	Issue 48: December 2004
On demand subreport	Issue 02: December 1999
On demand subreport to mimic a drilldown	Issue 41: May 2004
On Demand Subreport to perform a specific action	Issue 68: April-June 2009
Open File Explorer with a hot key	Issue 54: March 2006
Optional Parameters in Record Selection	Issue 68: April-June 2009
Optional Parameters in Report Headings	Issue 68: April-June 2009
Page breaks for a group	Issue 14: December 2000/January 2001
Page Footers for odd and even page layout	Issue 65: April - June 2008
Page Footer section behaves differently	Issue 51: October/November 2005
Page Headings in a SubReport	Issue 68: April-June 2009
Page Headings on drill down	Issue 19: June 2001
Page Numbers in a Large Report Header section	Issue 69: July-Sept 2009
Parameter changes in Crystal Reports XI	Issue 50: August 2005
Parameters and visual basic (part 2)	Issue 23: November 2001
Parameters and visual basic using the OCX and RDC	Issue 22: September/October 2001
Parameters in formulas	Issue 18: May 2001
Parameters on the web (see here for example)	Issue 15: February 2001
Parameter pick list update	Issue 47: November 2004
Parameter to control chart layout selection	Issue 46: October 2004
Pareto Principle extended	Issue 52: January 2005
Percentage Summaries in a Crosstab	Issue 66: July/September 2008
PDF export can appear to drill down	Issue 55: April 2005
PDF export in CR8.5	Issue 20: July 2001
Perform Grouping on Server summary requirements	Issue 50: August 2005
Pick List data sources	Issue 58: October 2006
Pick List Utility	Issue 16: March 2001
Pie charts design tips	Issue 49: January/February 2005
PreviousIsNULL and NextIsNULL functions	Issue 42: June 2004
Printing a multiple value parameter value	Issue 04: February 2000
Printing a multiple value parameter using the FOR operator	Issue 05: March 2000
Printing a range parameter value	Issue 04: February 2000
Privacy policy	Issue 07: May 2000
Problem with formula calculating previous year end of month in a leap year	Issue 65: April - June 2008
Radar Charts	Issue 70: October/December 2009
Range in page footer	Issue 15: February 2001
Recognising NULL in formulas	Issue 09: July 2000
Record selection of future records	Issue 02: December 1999
Recover Excel Add-In if it disappears	Issue 38: July/August 2003
Recover invisible fields due to guideline overwrap	Issue 36: May 2003
Recrystallize your report	Issue 29: September/October 2002
Redisplay group heading when group continues on new page	Issue 28: August 2002
Register new Maps with MIGM30	Issue 40: Feb/Mar 2004
Release of Crystal Reports version 8.	Issue 05: March 2000
Remember to back up your rpt files	Issue 23: November 2001
Remember to back up your rpt files	Issue 47: November 2004
Remove duplicate values	Issue 33: February 2003
Remove repeating fields in your database design	Issue 44: August 2004
Repeat Group header on New Page	Issue 19: June 2001
Report Alerts in Cr8.5	Issue 19: June 2001
Report Analyzer for improved report management and documentation	Issue 16: March 2001
Report Analyzer 3.0 released	Issue 35: April 2003
Report Application Server licensing (Crystal Reports 9.0)	Issue 32: January 2003
Report Title in a Subreport	Issue 67: January/March 2009
Reports as HTML emails	Issue 29: September/October 2002
Reset a running total on a page break	Issue 21: August 2001
Retrieving a value from a subreport	Issue 01: November 1999
Review of the previous five years	Issue 47: November 2004
Round a number up	Issue 34: March 2003
Round a number up	Issue 37: June 2003
Round numbers to tens and hundreds	Issue 46: October 2004
Round to nearest 10c for those cash reports	Issue 57: August 2006
Rounding errors: why do we get them?	Issue 57: August 2006
Rounding errors: how can we eliminate them?	Issue 57: August 2006
Running total calculations using formulas and variables	Issue 21: August 2001
Running total fields	Issue 21: August 2001
Running Totals in a Crosstab	Issue 34: March 2003
SAP and Business Objects in friendly takeover	Issue 63: September/October 2007
Scenery: Auckland sky line	Issue 41: May 2004
Scenery: Mt Taranaki	Issue 42: June 2004
Scenery: Muriwai (fishing from the rocks)	Issue 43: July 2004
Scenery: Pahia in the Bay of Islands	Issue 44: August 2004
Sculpture on the Shore 2008	Issue 67: January/March 2009
Save Data with Report	Issue 04: February 2000
Saving summaries	Issue 13: November 2000
Seagate Info Input Directory Administration	Issue 09: July 2000
Section Expert improvements in Crystal Reports 2008	Issue 64: Jan - Mar 2008
Selecting all the objects in a section	Issue 50: August 2005
Selecting from a data range with null values	Issue 02: December 1999
SELECT INTO to create a summary table	Issue 35: April 2003
SELECT INTO to analyze patient data	Issue 36: May 2003
Send multiple emails from one report	Issue 25: January/February 2002
Set Alias in Crystal Reports 9.0	Issue 31: December 2002
Set default field formats	Issue 17: April 2001
Set Print Date/Time to move report in time	Issue 37: June 2003
Set Print Date/Time to test report at specific dates	Issue 56: May 2006
Shaded reports as you go down the page	Issue 35: April 2003
Shadow boxes with rounded corners	Issue 63: September/October 2007
Share data between reports with our Share UFL	Issue 62: July/August 2007
Share User Function Library Improvements	Issue 70: October/December 2009
Show headings on drill down	Issue 23: November 2001
Singularity Principle in database design	Issue 43: July 2004
Smiley and sad faces on a report	Issue 36: May 2003
Sort a string using a ripple sort	Issue 35: April 2003
Sort Fields	Issue 08: June 2000
Sort Parameter array before printing in a heading	Issue 50: August 2005
Sorting a field by numeric value with alpha prefix	Issue 57: August 2006
Sorting records by surname	Issue 05: March 2000
Specific digit in Pi formula	Issue 47: November 2004
Speed up reports with large image fields	Issue 20: July 2001
Splitting a string on a quote delimiter	Issue 69: July-Sept 2009
SQL command parameters	Issue 31: December 2002
SQL command to create audit of report runs	Issue 36: May 2003
SSAUG conference report	Issue 14: December 2000/January 2001
Static Pick List in Crystal Reports XI	Issue 58: October 2006
Start groups on new pages with a duplex printer	Issue 45: September 2004
Strike Out use in field formatting	Issue 50: August 2005
String variables longer than 254 characters	Issue 23: November 2001
Sub SELECT in SQL	Issue 22: September/October 2001
Subreport with no data	Issue 10: August 2000
Summarize a summary field	Issue 28: August 2002
Summarize an array	Issue 36: May 2003
Summary Field in a text object	Issue 62: July/August 2007
Target line on a chart	Issue 17: April 2001
Target line on a chart	Issue 27: July 2002
Temperature data displayed in a report	Issue 51: October/November 2005
Template hint	Issue 29: September/October 2002
Test your expertise	Issue 17: April 2001
Text Export uses screen resolution for document size	Issue 40: Feb/Mar 2004
Text File Lookup UFL	Issue 26: March/April 2002
Text interpretation with date field format strings	Issue 53: February 2006
Text Rotation	Issue 08: June 2000
Thanks to our contributors	Issue 47: November 2004
Thermometer Chart	Issue 69: July-Sept 2009
Time band formula	Issue 47: November 2004
Time Zone Adjustments in older versions of Crystal Reports	Issue 67: January/March 2009
Time Zone discussion	Issue 66: July/September 2008
Time Zone Functions	Issue 66: July/September 2008
Time Zones in Crystal Reports	Issue 66: July/September 2008
Trigonometric Functions in Crystal Reports Formulas	Issue 67: January/March 2009
Toolbars and layout in Crystal Reports XI	Issue 49: January/February 2005
Tool Tip Text	Issue 08: June 2000
TopN in a crosstab	Issue 19: June 2001
TopN reports can include dynamic numbers of groups	Issue 57: August 2006
TopN reports can include ties	Issue 57: August 2006
ToText with date format strings	Issue 53: February 2006
ToWords will round a value up	Issue 35: April 2003
ToWords to print words on cheques	Issue 35: April 2003
ToWords on Cheques - friendlier Custom Function	Issue 36: May 2003
Track version changes with text objects in the page header	Issue 54: March 2006
Turning on guidelines	Issue 57: August 2006
UNION vs UNION ALL	Issue 68: April-June 2009
Upfrom and UpTo keywords in a range	Issue 68: April-June 2009
Use Audit Reports to verify your other reports	Issue 31: December 2002
Use cell background color and border to format crosstab headings	Issue 48: December 2004
Use colors economically	Issue 27: July 2002
Use Crosstab as a group summary	Issue 35: April 2003
Use Crystal Reports to backup your disk files	Issue 53: February 2006
Use Disk UFL to manipulate files from within your report	Issue 53: February 2006
Use descriptions with Boolean parameters	Issue 39: January 2004
Use Export to Report Definition to find where that parameter is used	Issue 19: June 2001
Use manual crosstab for more control	Issue 48: December 2004
Use other summary functions in your crosstab	Issue 48: December 2004
Use parameters	Issue 18: May 2001
Use parameter to create multi purpose reports	Issue 58: October 2006
Use Report Alerts to audit your report	Issue 26: March/April 2002
Use Select Case to convert descriptions	Issue 26: March/April 2002
Use summaries to audit your data	Issue 27: July 2002
Use the Crystal OCX with Visual Basic	Issue 17: April 2001
User Function Libraries install instructions	Issue 64: Jan - Mar 2008
Useful web sites	Issue 11: September 2000
Using Internet newsgroups	Issue 17: April 2001
Using multiple similar subreports in a main report	Issue 06: April 2000
Using original order in a group (challenge)	Issue 23: November 2001
Using RTF and HTML in memo fields in a report	Issue 06: April 2000
Using the file system as a data source	Issue 01: November 1999
Using the Report Designer Component in Visual Basic	Issue 20: July 2001
User group conferences in 2004	Issue 39: January 2004
UTC time fields in your database design	Issue 41: May 2004
Utilities now available from our Web Site	Issue 35: April 2003
Utility to modify ODBC login	Issue 25: January/February 2002
Utility to modify printer drivers	Issue 25: January/February 2002
Utility to modify report database location	Issue 25: January/February 2002
Variables to interrogate data during crosstab processing	Issue 37: June 2003
Versions sharing reports	Issue 38: July/August 2003
View your Crystal Report on your iPOD or MP3 player	Issue 55: April 2005
Visual Studio 2005 and Crystal Reports	Issue 52: January 2005
Web Component Server	Issue 09: July 2000
Web server demonstration folders	Issue 23: November 2001
Web Server demonstration folders	Issue 47: November 2004
Web Server demonstration folders for Crystal Reports XI	Issue 50: August 2005
Week Number formula using DatePart function	Issue 52: January 2005
Week number formula for weeks that don't start on Sunday	Issue 54: March 2006
Weighted Averages for a more accurate summary	Issue 43: July 2004
What does that field really contain?	Issue 57: August 2006
What fields can you place on a chart?	Issue 27: July 2002
What features are in what versions?	Issue 39: January 2004
What has happened to Crystal Dictionaries?	Issue 46: October 2004
What is in version Crystal Reports 9.0?	Issue 27: July 2002
What makes a good report designer?	Issue 35: April 2003
When are variables calculated?	Issue 69: July-Sept 2009
When does the day start?	Issue 51: October/November 2005
Where are the Repository samples?	Issue 50: August 2005
Where can you find previous issues?	Issue 47: November 2004
Where do you place a chart on a Crystal Report?	Issue 27: July 2002
Which Crystal Reports 9 edition is for you?	Issue 29: September/October 2002
Why do we need summaries in formulas?	Issue 54: March 2006
Windows XP Service Pack 2 and Crystal Reports 8.5	Issue 46: October 2004
Workbench Explorer to manage projects	Issue 66: July/September 2008
Working Days UFL	Issue 16: March 2001
Wrapping a crosstab on the same page	Issue 44: August 2004
XML and Crystal Reports	Issue 11: September 2000
XML and Crystal Reports	Issue 23: November 2001
XML and Crystal Reports	Issue 47: November 2004
XML support in Cr8.5	Issue 22: September/October 2001
XML User Function Library Improvements	Issue 70: October/December 2009
XNPV and XIRR functions	Issue 65: April - June 2008
XOR in a Boolean formula	Issue 43: July 2004

Back Issues

1999
2000
2001
2002
2003
2004
2005
2006
2007
2008

current issue

Back Issues

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

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