Chelsea Technologies Ltd - Crystal techniques. Sample reports
Go to the sample report description and screenshot
Sample Report zip files can be downloaded below:
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 some years back
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.
In Issue 34 (March 2003) we explained how to display a running total field in a crosstab.
This uses one of the 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.
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)
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. Charley Nash (from Nashville, TN) suggests some of us like to do things the hard way. Here is his formula
< Month (CurrentDate) or //birthday in prior month
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 Charley Nash’s excellent formula for accurately calculating a person’s age as at any date. Charley has now sent us the formula as a Custom Function. Place this in the repository to have the function available in all your reports.
Birth, datetimevar Current)
If you copy & paste, remember to check that minus signs are copied correctly, as they may copy as a dash sign.
SAP have an interesting example of a report which shows multiple summaries by several time periods based on a user entered end datetime.
Maps for use in Crystal Reports
File Name: MAPS_NZ.EXE Originally compatible with versions: 7.0 only 16 & 32 bit
Modified by Chelsea Technologies Ltd for use with later versions of Crystal
Reports. Now compatible with Crystal Reports 8.0, 8.5, 9.0 and 10.0.
Are you looking for a cost-effective way to schedule your reports?
See cViewSERVER for a Windows Service solution. Benefit: The machine does not need to be logged on
See cViewMANAGER for a scheduler on your desktop
Do you want your users to view your Crystal reports in a very cost-effective way?
See cView viewer
Are you looking for a way to display images in your reports?
Crystal Clear Index
Here are brief descriptions of each tip in our back issues. If you would like to download a pdf with the full tip, see below.
You may download a pdf of our back issues below