Share via


How to: Specify Target Aliases for Detail Bands

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

  1. Open the report or label in the appropriate designer.

  2. On the Report menu, click Edit Bands.

  3. 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.

  4. In the Detail Band Properties dialog box, click the Band tab.

  5. 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.

  6. When you are finished, click OK.

For more information, see Band Tab, Report Band Properties Dialog Box (Report Builder).

See Also

Other Resources

Working with Report Bands
Working with Data in Reports