The information in this article applies to:
- Microsoft FoxPro for MS-DOS, versions 2.0, 2.5, and 2.5a
SUMMARY
Using the procedure described below, you can build a report to skip one or
more lines after a specific number of detail lines in FoxPro versions 2.0
and later for MS-DOS.
MORE INFORMATION
To create a report to skip one line every five detail lines:
- Create a quick report or open an existing report.
- From the Report menu, choose Variables.
- Choose the Add button and enter the following information in the
Report Variables dialog box:
Variable Name: REC
Value to Store: any database field
Initial Value: 0
Reset: End of Report or End of page
Calculate: Count
- Choose OK twice.
- Move the cursor to a blank space on the detail band.
- From the Report menu, choose Add Line.
- Move all fields in the detail band up one line.
- Move the cursor to the last line of the detail band.
- From the Report menu, choose Field.
- Choose the Expression button, and type the following in the Report
Expression dialog box:
IIF(MOD(REC,5)=0,CHR(255),"")
NOTE: To change the number of detail lines to print, change the
number 5 to the number of lines to print in the previous
command.
- Choose the Verify button to confirm that the expression is valid.
- Choose OK twice.
- From the Report menu, choose Page Layout.
- Choose the Options button.
- Select the Suppress Blank Lines check box.
- Choose OK twice.
- To add more than one blank line, repeat steps 5-8. Select the
field created in steps 9-12. From the Edit menu, choose Copy,
then from the Edit menu, choose Paste. Move the new field to the
last line of the detail band.
|