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