A list of official sample reports demonstrating the Crystal Report design concept

Concept | design | sample | Crystal Report Overview

In this document, you will get a list of sample reports created by technical support. These sample reports demonstrate a variety of report creation techniques. The aim is to model concepts. These sample reports are fully documented and are not supported by technical support. The document contains a description of each application and its download link.


Directory

Sample reports for Model report design
Array example
Business Day and Hours sample
Cross Representation example
Date and Time samples
formatting and text samples
Example of a formula
Figure example
Groups and drilldown examples
label Example
parameter example
Sub-report Example
Table Links Example

Contact CRYSTAL decisions for technical support
________________________________________________________________

Sample reports for Model report design

Array example
FileName: cr_arrays_samples.zip
This file contains a variety of sample reports demonstrating how to build and use arrays in Crystal Report 8.x.

Http://support.crystaldecisions.com/communityCS/FilesAndUpdates/cr_arrays_samples.zip.asp

· Bubblesort.rpt
This report shows you how to create a formula to sort the elements in an array. Users should be familiar with arrays and advanced formulas.

· Cr_dynamic_array_builder_crystal_syntax.rpt
This report demonstrates how to build an array step-by-step along with the report process.

· Cr_index_not_store_and_fetch.rpt
The report demonstrates how to set up pointers for reports, using dynamic array creation and subreports. Users should be familiar with arrays and subreports.

· Cr_looping_through_multiple_value_paremeter.rpt
This report demonstrates how to use an array to check for multivalued parameters for data entry. Users should be familiar with arrays and complex formulas.

· Cr_manual_running_array.rpt
This report shows a variety of ways to use array summation. Users should be familiar with arrays.

Vcr_pass_values_from_main_report.rpt
The report demonstrates how to pass an array from the main report to a subreport. Users should be familiar with arrays and subreports.

· Manual Top N.rpt
The report shows how to use arrays to change the "top N" reports to sort by different fields. Users should be familiar with arrays.

· Random Record Generator.rpt
The report allows the user to enter a value that specifies the number of returned records, and the returned records are randomly generated. Users should be familiar with arrays and complex formulas.

· Cr_multiple_arrays_dynamically_populated.rpt
The report allows users to create multiple arrays when the number of records exceeds 1000.
________________________________________________________________

Business Day and Hours sample
FileName: cr_businessdh_samples.zip
This file contains a variety of sample reports that demonstrate the calculation of business days and hours in Crystal Report 8.x.

Http://support.crystaldecisions.com/communityCS/FilesAndUpdates/cr_businessdh_samples.zip.asp

· Business_days_v8.rpt
This report demonstrates how to create an array of all business days that contain a specified year. Users should be familiar with arrays and complex formulas.

· Businessdays_hours.rpt
This report shows how to create a formula that calculates the number of business days/business hours between two date-time fields.
________________________________________________________________

Cross Representation example
FileName: cr_crosstabs_samples_zip
This file contains a variety of sample reports to demonstrate how to create and use crosstab tables in Crystal Report 8.x.

Http://support.crystaldecisions.com/communityCS/FilesAndUpdates/cr_crosstabs_samples.zip.asp

· Mockcrosstabscr7.rpt
This report demonstrates how to create a crosstab appearance for reports that do not use a crosstab object.

· Virtualpagenumbersscr8.rpt
This report demonstrates a workaround for numbering virtual pages within a crosstab table. Users should be familiar with cross tables and simple formulas.

· WPR formulae in Crosstabs.rpt
Typically, a whileprintingrecords formula cannot be used in a crosstab table, and the report gives a workaround. Users should be familiar with subreports and advanced formulas.
________________________________________________________________

Date and Time samples
FileName: cr_date_time_samples.zip
This file contains a variety of sample reports that demonstrate the calculation of date and time ranges in Crystal Report 8.x.

Http://support.crystaldecisions.com/communityCS/FilesAndUpdates/cr_date_time_samples.zip.asp

· Calendar Which populates all dates in a range.rpt
The report creates a real calendar format. Users only need to set up subreports to point to their databases. The work is minimal to the user.

· Conditional Date Ranges passed to Server.rpt
This report demonstrates how to pass a multiple conditional if-then-else statement to a SQL query generated by a crystal report.

· Datetimediff.rpt
The report demonstrates how to calculate the gap between two datetime fields and display the output in a variety of formats.

· Populate dates Between with charting.rpt
The report demonstrates how to display a range of all dates and charts that are based on the entire date range, even if the actual date may not exist in the database. For advanced users only. Users should be familiar with arrays and subreports.

Populate dates Between.rpt
The report demonstrates how to display a range of all dates, even if some dates may not exist in the database. For advanced users only. Users should be familiar with arrays and subreports.
________________________________________________________________

formatting and text samples
FileName: cr_formattext_samples.zip
This file contains a variety of sample reports to demonstrate different formatting options in the Crystal Report 8.x.

Http://support.crystaldecisions.com/communityCS/FilesAndUpdates/cr_formattext_samples.zip.asp

· Ascii_translator.rpt
The report shows the output of 254 ASCII characters after using the CHR function.

· Changingsortorderoflastname.rpt
This report shows you how to change the sort order of a last name when it contains a special character Furu apostrophe.

· Checkboxtypes.rpt
The report shows a variety of different check boxes that you can take advantage of when you use WingDings fonts.

· Decimalformattrailingzeros.rpt
This report shows how to drop trailing zeros in a numeric field.

· Displayover254characterswithformulas.rpt
This report shows you how to create a large string with a formula and display a large amount of text at the end of the report.

· Groupsincolumns.rpt
The report shows how to use multiple-column formatting to group in separate columns.

· Preventingwidowedheadersfooters.rpt
This grouped report, created in Crystal Report Designer, prevents a group header or group footer from appearing alone on a page that does not have the appropriate data. This report is recommended for all levels of users.
________________________________________________________________

Example of a formula
FileName: cr_formula_samples.zip
This file contains sample reports that demonstrate several types of formulas. These sample reports contain topics such as creating a manual run sum (manual running totals), converting numbers with two decimal digits to characters, and so on. for Crystal Report 8.x.

Http://support.crystaldecisions.com/communityCS/FilesAndUpdates/cr_formula_samples.zip.asp

· Conditional structures in Crystal and Basic syntax.rpt
The report, with Crystal and Basic Two syntax, demonstrates a variety of loops and selection control structures.

· Extractfilenamefrompath.rpt
This report shows you how to use the IF THEN statement to peel the file name from the path.

· Latitudelongitudeconverterscr7.rpt
The report shows how to convert an integer value to latitude or longitude.

· Manualrunningtotals basics.rpt
Learn how to use a manual run totals.

· Median_calculation_v8.rpt
This report demonstrates how to use an array formula to calculate the median value of a group.

· Medianmanualcalculationscr7.rpt
This report demonstrates how to use the median value of a manual run totals calculation group.

· Runningpercentofpreviouseightrecordsscr7.rpt
This report demonstrates how to use a variable to calculate the percentage of the first eight records.

· Stringmanualrunningtotalscr7.rpt
This report demonstrates how to use a run total with a string type variable.

· Towordsincludingdecimals.rpt
The sample report demonstrates how to convert a number with two decimal digits to a character.

Cwildcard report.rpt
This report allows users to search for a specific string based on a partial string value using wildcard characters.
________________________________________________________________

Figure example
FileName: cr_graphing_samples.zip
This file contains a sample report of the chart features in the Model Crystal Report 8.x.

Http://support.crystaldecisions.com/communityCS/FilesAndUpdates/cr_graphing_samples.zip.asp

· Banner or Virtual Page report.rpt
This report demonstrates workarounds to accommodate large charts or objects by creating virtual pages.

· Barchartwithmovingaveragev8.rpt
The report contains a bar chart with dynamically tuned moving average trendline.

· Color_coded_chart.rpt
This report demonstrates how to create a color-coded diagram without using the Chart Wizard.

· Display Month Names on X axis.rpt
This report demonstrates how to display a month name on the x-axis of a chart.

Graph on% change.rpt
The sample report demonstrates how to represent "percent change" in a chart. For advanced users only. Users should be familiar with subreports and advanced formulas.
________________________________________________________________

Groups and drilldown examples
FileName: cr_groups_drilldown_samples.zip
This file contains sample reports to demonstrate the various groupings and Drill-down features and techniques in the Crystal Report 8.x.

Http://support.crystaldecisions.com/communityCS/FilesAndUpdates/cr_groups_drilldown_samples.zip.asp

· Datetypegroupbyparameterchoice.rpt
The report demonstrates how to group by day/week/month (based on parameters for user input).

· Drilldown-fakepageheaders.rpt
This report demonstrates how to use markup technology to create a virtual header for a Drill-down report.

· Groupbyfinancialyear.rpt
The report shows how to group by fiscal year. In these examples, the financial year begins on July 1 and ends on June 30. Therefore, June 15, 2001 will be classified into fiscal year 2000. July 15, 2001 will be classified into fiscal year 2001.

· Groupbyspecificrecordnumber.rpt
This report demonstrates how to create a group that contains a specified number of records. Users should be familiar with the concept of manually running totals and grouping.

· Groupingdynamicallyonparameter.rpt
This report shows you how to prompt the user to select a field so that the report can be grouped dynamically.

· Show consecutive Groups.rpt
The report shows how to group continuously, even when there are no records in a particular group. For advanced users only.

· Suppressgroupsbasedonawhileprintingrecordsvalue.rpt
The report is based on the Whileprintingrecords formula and returns only the groups that contain specific values. Users should be familiar with arrays and subreports.

· Suppressgroupsbasedonwhilereadingrecordsvalue.rpt
The sample report shows how you can display only groups that contain specific records.

· Suppressingrecordsincludedinothergroupsv8.rpt
The sample report demonstrates how conditional suppression displays records that are contained in other groups. Users should be familiar with arrays, shared variables, and subreports.
________________________________________________________________

label Example
FileName: cr_labels_samples.zip
This file contains a variety of sample reports that demonstrate how to create labels in Crystal Report 8.x.

Http://support.crystaldecisions.com/communityCS/FilesAndUpdates/cr_labels_samples.zip.asp

· Duplicate_mail_labels.rpt
This report demonstrates how to create a duplicate label. Users should be familiar with subreports and shared variables.

labels looping using basic syntax link.rpt
The example report prints each label x times, where x is entered as a parameter value. For advanced users only.

· Samemaillabelononepage.rpt
The sample report shows how to repeat mailing labels across the page. In this case, the mailing label is specified by a parameter. Suitable for intermediate users.
________________________________________________________________

parameter example
FileName: cr_parameters_samples.zip
This file contains a variety of sample reports that demonstrate how to use multiple types of parameters in Crystal Report 8.x.

Http://support.crystaldecisions.com/communityCS/FilesAndUpdates/cr_parameters_samples.zip.asp

· Allorspecificparameters.rpt
This report shows you how to create a parameter that takes into account the return value "all". Users should be familiar with the record selection formula.

· Optionalparameterentry.rpt
This report demonstrates how to allow a user to retain blank parameters. Users should be familiar with complex formulas.

· Setcurrentdateasdefaultparameterv8.rpt
This report demonstrates how to use the current date as the default parameter value. Users should be familiar with parameters and intermediate formulas.

· Topnwithparameter.rpt
This report demonstrates how to create a report that displays the top N groups based on the values entered by the user. Users should be familiar with the "top N", parameters, and conditional suppression display.

· Userfriendlydateparamconversionv8.rpt
The report demonstrates two ways to prompt the user for input parameters and then convert them to the available date formats. Suitable for intermediate users.
________________________________________________________________

Sub-report Example
FileName: cr_subreports_samples.zip
This file contains a number of sample reports that demonstrate the subreport feature of the Crystal Report 8.x.

Http://support.crystaldecisions.com/communityCS/FilesAndUpdates/cr_subreports_samples.zip.asp

· Creating_fake_records.rpt
This report demonstrates how to display a record that does not exist in the database. Users should be familiar with subreports and shared variables.

· Exceptions.rpt
This report demonstrates how to use subreports to show only companies that do not sell products. Users should be familiar with subreports and shared variables.

· Passvaluesfrommainreport.rpt
This report demonstrates how to pass an array from the main report to a subreport. Users should be familiar with arrays and subreports.

· Store_fetchstoredvariablesample.rpt
This report demonstrates how to use shared variables as well as storage and extraction.

· Subreportlinkedonmultivalueparamsv7.rpt
This report demonstrates the workaround for linking a subreport to a main report on a multivalued parameter.

· Suppressingblanksubreports.rpt
This report demonstrates how to use a markup formula to hide a section that produces a blank subreport.

· Suppressingblanksubreports_array.rpt
This report demonstrates how to suppress the display of blank subreports without creating a blank style. Users should be familiar with arrays and subreports.

· One_prompt.rpt
This report demonstrates how to use a set of parameters to enter hints for the main reports and subreports.

· Two_prompts.rpt
This report demonstrates parameter input prompts for the main report and subreport, respectively.

· One_way_link.rpt
This report demonstrates how to use a one-way link to create a chart on a two-pass formula. Users should be familiar with arrays and subreports.

· Fake_page_header.rpt
This report demonstrates how to create a header for a subreport.
________________________________________________________________

Table Links Example
FileName: cr_table_linking_samples.zip
This file contains a sample report that demonstrates the effect of different link types between tables on the result set in Crystal Report 8.5.

Http://support.crystaldecisions.com/communityCS/FilesAndUpdates/cr_table_linking_samples.zip.asp

· Odbcjointypes.rpt
This report demonstrates how different ODBC connection types between two tables affect the returned recordset.

· Linkingtestdatabase.mdb
This is the sample database created for ODBCJOINTYPES.RPT. The report contains the saved data, so you can view the report without having to install the file.