CFREPORT  
Description

Runs a predefined Crystal Reports report. Applies only to Windows systems. Uses the CFCRYSTAL.exe file to generate reports. Sets parameters in the Crystal Reports engine according to its attribute values.

 
Category

Extensibility tags

 
Syntax
    <cfreport 
   report = "report_path"
   dataSource = "ds_name" 
   type = "type" 
   timeout = "number of seconds" 
   orderBy = "result_order"
   username = "username"
   password = "password"
   formula = "formula">
</cfreport>

  
 
See also

cfcollection, cfexecute, cfindex, cfobject, cfsearch, cfwddx

 
History

New in ColdFusion MX: Crystal Reports establishes an independent connection to the data source. The connection is not subject to any ColdFusion data source-specific restrictions. For example, the Crystal Reports server can access a data source regardless of whether it is disabled in the ColdFusion Administrator.

 
Usage

This tag requires an end tag.

 
Example
<!--- This view-only example shows the use of cfreport --->
<h3>cfreport Tag<h3>
<p>cfreport lets reports from the Crystal Reports Professional report writer
display through a ColdFusion interface. To run, the tag requires the 
name of the report. cfreport can also pass information to the report 
file displayed, to change the output conditions.
<p>This example would run a report called "monthlysales.rpt " and pass it an
optional filter condition to show only the information for a subset 
of the report.

<cfreport report = '/reports/monthlysales.rpt'>
     {Departments.Department} = `International'
</cfreport>

<p>Substitute your report files and filters for this code. cfreport can put 
Crystal Reports into web pages.
DATASOURCE  
  Optional
 

Name of registered or native data source

TYPE  
  Optional
 
Default value: "standard"
  • standard (not valid for Crystal Reports 8.0)
  • netscape
  • microsoft
TIMEOUT  
  Optional
 

Maximum time, in seconds, in which a connection must be made to a Crystal Report

REPORT  
  Required
 

Report path. Store Crystal Reports files in the same directories as ColdFusion page files.

ORDERBY  
  Optional
 

Orders results according to your specifications.

USERNAME  
  Optional
 

Username required for entry into database from which report is created. Overrides default settings for data source in ColdFusion Administrator.

PASSWORD  
  Optional
 

Password that corresponds to username required for database access. Overrides default settings for data source in ColdFusion Administrator.

FORMULA  
  Optional
 

One or more named formulas. Terminate each formula with a semicolon. Use the format:

formula = "formulaname1 = 'formula1';formulaname2 = 'formula2';"

If you use a semicolon in a formula, you must escape it by typing it twice (;;). For example:

formula = "Name1 = 'Val_1a;;Val_1b';Name2 = 'Val2';"