Accessibility

Table of Contents

Using the ColdFusion Report Builder – Part 1: Creating Reports and Subreports

Binding Subreports to Main Reports with Parameters

Generally, you can link a subreport to a main report by passing a value from the query in the main report as a parameter to the subreport; this value filters data in the subreport query. You can link the reports through the Subreport Parameters property of the subreport component. Find this property in the Data category of the subreport properties (see Figure 2).

Subreport Parameters property

Figure 2. Subreport Parameters property

This property corresponds to the input parameters of the subreport. The name of this property must match the name of the input parameter of the subreport. The Subreport Parameters property is an expression usually mapped to a field of the query in the main report (see Figure 3). You can view this property by clicking the ellipsis in the lower right corner in Figure 2.

Subreport Parameters expression

Figure 3. Subreport Parameters expression