Microsoft KB Archive/122906

{| = PRB: Data Appears to Be Missing in Group/Total Report Wizard =
 * width="100%"|

ID: Q122906

The information in this article applies to:


 * 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 .

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.

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.

Additional reference words: FoxWin 2.60 2.60a KBCategory: kbtool kbprb KBSubcategory: FxtoolWizother
 * }