Share via

Variables Tab, Report Properties Dialog Box (Report Builder)

  • Article

Makes it possible for you to create, change, or delete variables for a report or label. You can also change the order in which report variables are evaluated.

This tab is pre-selected when you choose Variables from the Report menu or the report layout context menu.

Note

This tab replaces the functionality of the native Visual FoxPro Report Variables Dialog Box when the Report Builder is active.

  • Variables
    Displays the names of variables defined in the report layout, and allows you to change the order of report variable evaluation.
  • Add
    Opens an input box for you to specify the name of a new report variable.
  • Remove
    Deletes the currently selected variable in the Variables list box.
  • Value to store
    Specifies an expression that is used to determine the value of the report variable during a report run. The report engine evaluates this expression each time it moves the record pointer as it processes the records in the current scope. Clicking the ellipsis (…) button opens the Expression Builder so you can build an expression. For more information, see Expression Builder Dialog Box.
  • Initial value
    Specifies an expression that is used to determine the initial value of the report variable. Clicking the ellipsis (…) button opens the Expression Builder.

  • Reset value based on
    Specifies the point at which to reset the variable to its initial value. The default value is End of Report.

    Note

    If you have specified data groups in the report, Detail bands, or target alias expressions for Detail bands, the Reset value based on list displays those items.

  • Calculation type
    Specifies additional calculations to perform when determining the next value of the report variable as the report engine moves the record pointer during a report run.

    Note

    Cumulative calculations are reset depending on the Reset value based on option.

    • None

      The result of the Value to store expression is assigned directly to the value of the report variable.

    • Count

      The value of the report variable is incremented by 1. (The Value to store expression is not evaluated.)

    • Sum

      Adds the result of the Value to store expression to the current value of the report variable.

    • Average

      Computes the arithmetic mean of the result of the Value to store expression for each record traversed thus far and assigns it to the report variable. (The Initial value of the report variable is not included in this calculation.)

    • Lowest

      Compares the current value of the report variable with the result of the Value to store expression and assigns the lesser of the two values to the report variable.

    • Highest

      Compares the current value of the report variable with the result of the Value to store expression and assigns the greater of the two values to the report variable.

    • Std Deviation

      Computes the square root of the variance of the result of the Value to store expression for each record traversed thus far and assigns it to the report variable. (The Initial value of the report variable is not included in this calculation.)

    • Variance

      Measures the degree to which the result of the Value to store expression varies from the average for the records traversed thus far and assigns it to the report variable. (The Initial value of the report variable is not included in this calculation.)

  • Release after report
    Releases the report variable from memory after the report has completed processing. When this option is not selected, the report variable remains in memory until Visual FoxPro quits or the CLEAR ALL or CLEAR MEMORY commands are called. For more information, see CLEAR Commands

See Also

Reference

Report Properties Dialog Box (Report Builder)

Other Resources

Working with Report Variables