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
ColdFusion MX: Changed data source connection behavior: Crystal Reports now 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';"