Report Expression Dialog Box

  • Article

Defines the contents of a field control in a report. This dialog box appears when you place a field control on a report or label.

Note

Depending on the setting of the _REPORTBUILDER system variable, this dialog may be replaced by an alternative user interface. For more information, see _REPORTBUILDER System Variable.

  • Expression
    Specifies an expression, such as the name of a variable or table field. The expression is evalulated at report run-time as the report engine renders output from the Field control. Clicking the ellipsis (…) button opens the Expression Builder so that you can build an expression. For more information, see Expression Builder Dialog Box.
  • Format
    When a valid expression is displayed in the Expression box, you can specify a format in this text box. Choose the dialog button to display the Format (Field) dialog box if you want to specify the format for the field in your report. For more information, see Format Expressions for Field Controls.

  • Field position
    Specifies position of the field in the report.

    • Float   Specifies that the selected field move relative to the size of the surrounding fields.

    • Fix Relative to Top of Band   Causes the field to remain in the position you give it in the Report or Label Designer and maintain that position relative to the top of the band.

    • Fix Relative to Bottom of Band   Causes the field to remain in the position you give it in the Report or Label Designer and maintain that position relative to the bottom of the band.

  • Stretch with overflow
    Specifies that the bottom of a Field control is extended vertically down the page to contain the full value of the evaluated expression.
  • Comment
    Makes it possible for you to add comments to the .frx or .lbx file. Comments are for reference only and do not appear anywhere in the printed report or label.
  • Calculations
    Displays the Calculate Field dialog box so you can select a calculation type to perform on the Field control expression and when to reset the calculation. For more information, see Calculate Field Dialog Box.
  • Print When
    Displays the Print When dialog box so that you can specify the conditions that must be met before the text is printed in your report or label. For more information, see Print When Dialog Box.

See Also

Reference

Expression Builder Dialog Box
Calculate Field Dialog Box
Format (Field) Dialog Box
Print When Dialog Box
Report Designer
Quick Report Dialog Box

Other Resources

Dialog Boxes (Visual FoxPro)