JavaScript Editor js editor     Web development 

Main Page

Visual FoxPro evaluates report variables in the order they appear in the Report Variables dialog box, which can affect the value of expressions that reference them. For example, suppose a report variable tTotal is specified as containing the results of the sum of two other report variables, tDelivered and tOutstanding. These two variables must appear in the report variable list before tTotal, otherwise the value of tTotal may be incorrect.

If you change the ordering of data groups in your report, report variables might not reset on the correct field. For example, if your report has two data groups and you change the order of the two groups, the variables remain set on the original positions of those groups.

To change report variable order

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

  2. On the Report menu, click Variables.

    The Report Properties dialog box opens.

    If the _REPORTBUILDER system variable is not set to the default Report Builder or is set to a third-party builder, the Report Variables dialog box displays or a different dialog box might display. For more information, see _REPORTBUILDER System Variable and Report Variables Dialog Box.

  3. In the Report Properties dialog box, click the Variables tab if it is not selected.

  4. In the Variables list, drag the mover button on the left of the variable to the position you want.

  5. When you are finished, click OK.

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

See Also

JavaScript Editor js editor     Web development