Reporting features

Easy-to-use interface

Employ a banded user interface with integrated online Help, For more information, see User interface usage, tips, and techniques.

Query Builder

Display, select, and order database tables and columns used in a report. The Query Builder creates SQL (also called internal SQL), which you can optionally customize using Advanced Query Builder. For more information, see Using the Query Builder.

Multiple display options

Display ColdFusion Report (CFR) files directly in a browser (no coding is required to create or display a ColdFusion report), or invoke a report with the cfreport tag, optionally passing query data to use instead of the internal SQL. For more information, see Displaying reports.

Report preview

Use Preview (F12) to display your report, optionally displaying a CFM page that invokes the report through the cfreport tag. For more information, see Previewing reports.

Familiar language

Use CFML in the Report Builder, as follows:

Advanced query mode Create a customized query object for the report using the cfquery tag, the QueryNew function, or any tag that returns a query. For more information, see Advanced query mode.

Report functions Create user-defined functions that you can use to populate report fields. For more information, see Report functions.

Formatting Use CFML functions to format report fields. For more information, see Expressions and the Expression Builder.

Global control of textual data

Use text styles for report-wide control over display fields. For more information, see Using text styles.

Wizards

The Report Builder provides the following wizards:

Report Creation Wizard Define SQL, report fields, grouping, and other display options. For more information, see Using the Report Creation Wizard.

Chart Wizard Define chart data, chart type, chart series, and other charting options. For more information, see Using charts.

Subreport Wizard Insert a subreport and select other subreport options, including subreport parameters. For more information, see Using subreports.

Server Setup Wizard Create settings for an RDS server, including file location and URL. For more information, see Setup Wizard.

Grouping

Define groups, each of which has its own group header and group footer bands. In particular, you can use calculated fields in group footer bands to easily display group totals for numeric fields. For more information, see Grouping and group breaks.

Charting

Insert a chart in any report band, displaying data from a variety of sources. For more information, see Using charts.

Subreports

Insert another report in any report band, optionally passing it a subreport parameter to control the data displayed in the subreport. For more information, see Using subreports.