PRB: Data Appears to Be Missing in Group/Total Report WizardID: Q122906 The information in this article applies to:
SYMPTOMSWhen 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. CAUSEWhen the Report Wizard makes a Report, it checks the Print When Box and chooses Print Repeated Values NO. RESOLUTIONTo 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. STATUSThis behavior is by design. MORE INFORMATIONSteps to Reproduce Behavior1. 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 |