# How to Periodically Add Blank Lines in a Report

ID: Q107607

The information in this article applies to:

- Microsoft FoxPro for Windows, version 2.5, 2.5a, and 2.5b

## 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 © 1999 Microsoft Corporation. All rights reserved. Terms of Use.