Crystal Clear - Sample Reports

CrystalKiwi Site

Calendar Report

Running Totals in a Crosstab

Wrapping Crosstab

Index

Subject

1999

2000

2001

2002

2003

2004

2005

2006

Calendar Report

Glen Brickey of eLoutions in Florida created this impressive report which displays a series of daily charts in a calendar format.

There were so many interesting techniques in this report we covered it over several issues

• Issue 24 (December 2001): Introduction and initial discussion
• Issue 25 (January/February 2002) How to identify the start days for the month.
• Issue 26 (March/April) How to display daily charts
• Issue 27(July 2002) Chart synchronization

This is the most popular sample request.  Even now, years later it is still very popular. The report was developed with Crystal Reports 8.0 so can be viewed with that or any later version.

Running Totals in a Crosstab

In Issue 34 (March 2003) we explained how to display a running total field in a crosstab.

This uses one of the neat new features in Crystal Reports 9, so requires that or a later version.

The sorting of the data becomes a critical issue prior to loading into a crosstab.

Wrapping Crosstab

When Howard Hammerman and Bruce saw Cathy Mitchisch demonstrate this technique at the CDUGNA New Orleans conference (May 2004) we were very impressed. 

You can take a crosstab object and wrap the columns that would normally appear on the horizontal page into a subsequent section. 

You need to use the SQL command object in Crystal Reports 9 (or a stored procedure/view that does something similar in an older version).

This was covered in Issue 44 (August 2004)

Age as a custom function (Crystal Reports v9 onward)

From Crystal Clear issue no 41

In issue 23 of Crystal Clear back in November 2001 we published Charliy Nash’s excellent formula for accurately calculating a person’s age as at any date.  Charliy has now sent us the formula as a Custom Function.  Place this in the repository to have the function available in all your reports. 

Function (datetimevar Birth, datetimevar Current)
if Month(Birth) < Month(Current) or
   (Month(Birth) = Month(Current) and Day(Birth) <= Day(Current))
then year(Current) - year(Birth)
else year(Current) - year(Birth) - 1

If you copy & paste, remember to check that minus signs are copied correctly, as they may copy as a dash sign.

Calculate Age in a formula

From Crystal Clear issue no 23

In Issue 22 Sep-Oct 2001 we showed you several ways to calculate an accurate age from a date field.  Charliy Nash (from Nashville, TN) suggests some of us like to do things the hard way.  Here is his formula

if Month ({table.datefield}) < Month (CurrentDate) or //birthday in prior month
  (Month ({table.datefield}) = Month (CurrentDate) and  //or birthday this month
   Day ({table.datefield}) <= Day (CurrentDate)) // and one day prior this month
then
    Year(CurrentDate) - Year({table.datefield}) // difference in years
else
    Year(CurrentDate) - Year({table.datefield})– 1 // difference less 1

Back Issues

1999
2000
2001
2002
2003
2004
2005

 current issue