PRB: Data Appears to Be Missing in Group/Total Report Wizard

• Microsoft FoxPro for Windows, versions 2.6 and 2.6a

SYMPTOMS

When you make a report by using the Group/Total Report Wizard, some of the data in the Detail band for fields that are being totaled may appear to be missing. But the total for the Group is correct.

CAUSE

When the Report Wizard makes a Report, it checks the Print When Box and chooses Print Repeated Values NO.

RESOLUTION

To get all the values to print in the Detail band for fields being summed, you need to modify the Report in Report Writer.

1. In the Command window, enter MODIFY REPORT <Report Name>.

2. In Report Writer, double-click the Field to bring up the Report Expression Dialog box.

3. Click the Print When Box to open the Print When Dialog box.

4. Change Print Repeated Values to YES.

5. Save the Report.

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce Behavior

1. From the Run menu, choose Wizard Report.

2. In the Report Wizards Screen, pick Group/Total Report Wizard.

3. Open the INVOICES.DBF in FPW26/Tutorial.

4. Select a Style.

5. Add All Fields.

6. Group By CNO.

7. Press Next on Step 5 of 7.

8. Press Next on Step 6 of 7.

9. Choose Save and Print Report.