Print When

Allows the conditional printing of an object based on the value of an expression and controls how objects print when bands are continued.

For field objects, the Print When dialog box controls whether values that do not change from band to band are printed. For non-field objects, this dialog box controls how continued bands are printed.

  1. Place a control on a report or label.

  2. In the control's dialog box, choose Print When.

    The Print When dialog box appears.

    Note: A slightly different version of the Print When dialog box appears when you draw a rectangle or line on a report or label, double-click it, and choose Print When from the Rectangle/Line dialog box.

    Information on the Rectangle/Line dialog box is available in Rectangle/Line.

  3. Set the Print repeated values option.

    Note: This option applies to non-field objects only, such as OLE objects, labels, lines, rectangles, and rounded rectangles.

    • Select Yes to print objects when bands containing the object are started.

    • Select No to not print the object unless one or both of the following are checked.

      • In first whole band of new page/column
      • When detail overflows to new page/column

  4. Set Print repeated values option (field objects).

    • Select Yes to print repeated values.
    • Select No to not print repeated values.

  5. Set Also Print options.

    • Select In First Whole Band Of New Page/Column to print the field in the first band of a new page or column that is not an overflow from a previous page or column.

      This box is automatically enabled if you check Yes for Print Repeated Values, and is optional if you check No for Print Repeated Values.

    • Select When This Group Changes to print the field when the chosen group changes.

      This option is available only if a data group exists and you choose a data group.

    • Select When Detail Overflows to New Page/Column to print the field when the Detail band overflows to a new page or a new column.

  6. Type an expression in Print Only When Expression Is True or displays the Expression Builder dialog box to define an expression to be evaluated before the field prints.

    Information on the Expression Builder is available in Expression Builder.

    All other options in this form except Remove Line If Blank are disabled if you include an expression.

  7. Select Remove Line If Blank to collapse the band if an object is not printing and no other object is occupying the same horizontal space.

 

Related Topics: