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,
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
Open the report or label in the appropriate designer.
On the Report menu, click Variables.
The Report Properties dialog box opens.
In the Report Properties dialog box, click the Variables tab if it is not selected.
In the Variables list, drag the mover button on the left of the variable to the position you want.
When you are finished, click OK.
For more information, see Variables Tab, Report Properties Dialog Box (Report Builder).