cfreport

Used to do either of the following:
- Execute a report definition created with the ColdFusion
Report Builder, displaying it in PDF, FlashPaper, or Excel
format. You can optionally save this report to a file.
- Run 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.

 <cfreport>

 cfreport();

This tag requires Adobe ColdFusion. Not supported on Lucee, OpenBD, etc.

cfreport Attribute Reference

template

Specifies the path to the report definition file,
relative to the web root.

format

Specifies the output format. Values:
  • PDF
  • FlashPaper
  • Excel
  • RTF
  • HTML
  • XML

name

The name of the ColdFusion variable that will hold
the report output. You cannot specify both name and
filename.

filename

The filename to contain the report. You cannot
specify both name and filename.

query

The name of the query that contains input data for
the report. If you omit this parameter, the report
definition obtains data from the internal SQL or from
cfreportparam items.

overwrite
Default: NO

Specifies whether to overwrite files that have the
same name as that specified in the filename attribute.
Default: false

encryption
Default: none

Specifies whether the output is encrypted. PDF format only.
Default: none Values:
  • 128-bit
  • 40-bit
  • none

ownerpassword

Specifies an owner password. PDF format only.

userpassword

Specifies a user password. PDF format only.

permissions

Specifies one or more permissions. PDF format only.
Separate multiple permissions with a comma. Values:
  • AllowPrinting, AllowCopy, AllowScreenReaders
  • AllowPrinting
  • AllowModifyContents
  • AllowCopy
  • AllowModifyAnnotations
  • AllowFillIn
  • AllowScreenReaders
  • AllowAssembly
  • AllowDegradedPrinting
  • AllowPrinting, AllowModifyContents, AllowCopy, AllowModifyAnnotations, AllowFillIn, AllowScreenReaders, AllowAssembly, AllowDegradedPrinting

datasource

Name of registered or native data source.

type
Default: standard

* standard (not valid for Crystal Reports 8.0)
* netscape
* microsoft Values:
  • standard
  • netscape
  • microsoft

timeout

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

report

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

orderby

Orders results according to your specifications.

username

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

password

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

formula

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

resourceTimespan

Life span of the resource directory. Used only with format=HTML

style

Style in CSS format that overrides a style defined in the Report Builder report at run time.

Fork me on GitHub