Chelsea Technologies Ltd - Crystal Clear subject index

Chelsea Technologies Ltd - Crystal Clear

Home	Products	Services	Download	Newsletter Crystal Clear	Buy at Crystalkeen	FAQs To Helplink site

Index by subject

Here are brief descriptions of each tip in our back issues. If you would like to download a pdf with the full tip, see the right hand panel.

2010

2009

2008

2007

2006

2005

2004

2003

2002

2001

2000

1999

Index by subject sorted alphabetically

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	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	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