Sample script for empty or blank lines added when the crystal report prints documents

Assume that each document prints a total of five lines, a maximum of four lines are added,
Define four blank sections in the repeated table bodies.
The primary task is to determine when and when the four sections are displayed based on the number of records.
The suppression display script of the defined section is:
Section 1. The first blank section must be displayed only when the number of records is equal to 1.
If onlastrecord = false then
Formula = true
Else

If (count ({sales order table body. Product Code}) mod 5> 1) then
Formula = true
Else
If (count ({sales single table body. Product Code}) mod 5 = 0) then
Formula = true
Else
Formula = false
End if
End if
End if

Section 2: the second blank section must be displayed only when the number of records is equal to 1 or 2.
If onlastrecord = false then
Formula = true
Else
If (count ({sales order table body. Product Code}) mod 5> 2) then
Formula = true
Else
If (count ({sales single table body. Product Code}) mod 5 = 0) then
Formula = true
Else
Formula = false
End if
End if
End if

The other two sections are very simple.
Note that the demarcation condition is processing when 0 is returned and the number of records is zero after the modulo operation is fully calculated.

Copyright Disclaimer: csdn is the hosting service provider of this blog. If this article involves copyright issues, csdn does not assume relevant responsibilities. Ask the copyright owner to contact the author directly.