Microsoft KB Archive/107607

{| = How to Periodically Add Blank Lines in a Report =
 * width="100%"|

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