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.

Syntax

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

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.

Attributes

Attribute Req/Opt Default Description

datasource
Optional

Name of registered or native data source

type
Optional
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';"

Attribute	Req/Opt	Default	Description
datasource	Optional		Name of registered or native data source
type	Optional	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';"`

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.