MACROMEDIA COLDFUSION MX 61-CFML, Reference

Page: 296 / 806

296 Chapter 2: ColdFusion Tags
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.
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