________________________________________________________________ Crystal Decisions Technical Support - Sample Reports - Formulas Phone: (604) 669-8379 Answers by Email: http://support.crystaldecisions.com/support/answers.asp WARNING These reports are for demonstration only. They are fully documented and not supported by tech support. ________________________________________________________________ PRODUCT VERSION These report files are for use with version 8.x of Crystal Reports only. ________________________________________________________________ DESCRIPTION These sample reports are based on the Xtreme.mdb sample database that installs with Crystal Reports. They are fully documented and designed to demonstrate how common reporting challenges can be accomplished or showcase the latest enhancements. Conditional Structures in Crystal and Basic Syntax.rpt This report demonstrated various looping and case control structures in both Crystal and Basic syntax. ExtractFileNameFromPath.rpt The report shows how to use an IF THEN statement to strip a filename from a path. LatitudeLongitudeConverterSCR7.rpt This report shows how to convert an integer value into a Latitude or a Longitude ManualRunningTotals Basics.rpt Learning how to use Manual Running Totals Median_Calculation_v8.rpt This report demonstrates how to use an array formula to calculate the median of a group. MedianManualCalculationSCR7.rpt This report demonstrates how to use a manual running total to calculate the median of a group. RunningPercentOfPreviousEightRecordsSCR7.rpt This report demonstrates how to use variables to calculate a percentage of the previous 8 records. StringManualRunningTotalSCR7.rpt This report demonstrates how to use a running total with a string type variable. ToWordsIncludingDecimals.rpt This sample report demonstrates how you can convert a number with two decimal places to words. Wildcard Report.rpt This report allows a user to search for a particular string based on partial string values with the use of wildcard characters. ________________________________________________________________ FILES File Modification Date Conditional Structures in Crystal and Basic Syntax.rpt 04/11/2001 ExtractFileNameFromPath.rpt 08/09/2001 LatitudeLongitudeConverterSCR7.rpt 04/02/2001 ManualRunningTotals Basics.rpt 07/31/2001 Median_Calculation_v8.rpt 04/02/2001 MedianManualCalculationSCR7.rpt 04/02/2001 RunningPercentOfPreviousEightRecordsSCR7.rpt 04/02/2001 StringManualRunningTotalSCR7.rpt 04/02/2001 ToWordsIncludingDecimals.rpt 08/09/2001 Wildcard Report.rpt 07/29/2001 ________________________________________________________________ ADDITIONAL INFO Crystal Services can customize your report using these techniques. For more information, please see: http://www.crystaldecisions.com/services/consulting/ ________________________________________________________________ Last updated on January 22,2002 ________________________________________________________________