Ensure that the SQL used to retrieve the result set is already grouped in the appropriate order typically you implement grouping by specifying an ORDER BY clause in the SQL SELECT statement used for the report. The ColdFusion Report Builder does not group data itself. The group break completes the old group by displaying the group footer and starts the new group by displaying the group header.
When the department ID changes, the ColdFusion Report Builder triggers a group break. Grouping the data by department lets users quickly understand department salary characteristics. For example, you could create a report that displays departments, employees, and their salaries. You can define separate headings for each new group and also display group-specific summary information, such as subtotals at the end of each group's area of the report. You can add clarity to a report's organization by grouping the information.
For more information, including troubleshooting tips, see Report Builder online Help. With Report Builder, you can include data in reports in a variety of formats, and perform calculations on the information.
0 kommentar(er)
