Variables Tab, Report Properties Dialog Box (Report Builder)

JavaScript Editor js editor     Web development 



Main Page

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



JavaScript Editor js editor     Web development