ID: Q107607
The information in this article applies to:
You can build report that skips one or more lines every so many detail lines by using the procedure described below.
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.
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.
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.
Object menu.
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.
Last Reviewed: June 27, 1995