How to Periodically Add Blank Lines in a Report

ID: Q107607

The information in this article applies to:

SUMMARY

You can build report that skips one or more lines every so many detail lines by using the procedure described below.

MORE INFORMATION

The following procedure will create a report that skips one line every five detail lines:

 1. Create a quick report or open an existing report.

 2. From the Report menu, choose Variables.

 3. Choose the Add button and enter the following information in the
    Report Variables dialog box:

       Variable Name: REC
       Value to Store: any numeric database field
       Initial Value: 0
       Reset: End of Report or End of page
       Calculate: Count

   NOTE: If Value to Store is not a numeric field, an "Invalid function
   argument value, type, or count" error message is displayed.

 4. Choose OK twice.

 5. Drag the Detail band separator button so that there is enough room for
    another line in the Detail band.

 6. Choose the Field tool.

 7. Drag in the Detail band to define the position and size of the new
    field.

 8. Choose the Expression button, and type the following in the Report
    Expression dialog box:

       "HI"

 9. Choose the Verify button to confirm that the expression is valid.

10. Choose OK.

11. Select the Print When check box.

12. Select the Print Only When Expression Is True check box.

13. Type the following in the Print Field When Expression dialog box:

       MOD(REC,5)=0

   NOTE: You can modify this command to skip a different number of detail
   lines by changing the number 5 to the number you want.

14. Choose the Verify button to confirm that the expression is valid.

15. Choose OK.

16. Select the Remove Line If Blank check box.

17. Choose OK twice.

18. Select the new field and move it so it is on the last line of the

    Detail band by itself.

19. Select the new field, and choose Pen Color and then White from the
   Object menu.

20. Double-click the Detail band separator button.

21. Clear the Constant Band Height check box.

22. To add more than one blank line, repeat step 5, and then select the

   field created in steps 6-17. From the Edit menu, choose Copy. From the
   Edit menu, choose Paste. Repeat step 18.

Additional reference words: FoxWin 2.50 2.50a 2.50b extra KBCategory: kbprg KBSubcategory: FxprgGeneral

Last Reviewed: June 27, 1995