ID: Q122906
The information in this article applies to:
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.
When the Report Wizard makes a Report, it checks the Print When Box and chooses Print Repeated Values NO.
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.
4. Change Print Repeated Values to YES.
5. Save the Report.
This behavior is by design.
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
Last Reviewed: June 27, 1995