You can specify a target alias for each Detail band to vary the order of record processing.
To specify a target alias for a Detail band
-
Open the report or label in the appropriate designer.
-
On the Report menu, click Edit Bands.
-
In the Edit Bands dialog box, click the Detail band you want, and then OK.
The Detail Band Properties dialog box opens.
Note: If the _REPORTBUILDER system variable is not set to the default Report Builder or is set to a third-party builder, the Detail dialog box displays or a different dialog box might display. For more information, see _REPORTBUILDER System Variable and Report Band Properties Dialog Box. -
In the Detail Band Properties dialog box, click the Band tab.
-
In the Target alias expression box, type the target alias expression. To build an expression, click the ellipsis (…) button to open the Expression Builder.
Note: Enclosing the target expression in quotation marks ( ""
) evaluates the expression as a literal, while omitting quotation marks evaluates the expression as a variable containing the target alias. -
When you are finished, click OK.
For more information, see Band Tab, Report Band Properties Dialog Box (Report Builder).