Crystal Report example script for adding blank lines or blank lines when printing documents

Source: Internet
Author: User
Tags count
Report Printing | script | example | Crystal Report assuming that our documents are printed in five lines per sheet, the maximum number of blank lines will be increased by 4 rows.
Define the four blank sections in the recurring table body.
Our first task is to determine when the four sections are displayed and when they will not appear, based on the number of records.
The suppressed display script for the section we defined is:
Section 1, the first blank section needs to be displayed only if the number of records equals 1 o'clock.
If Onlastrecord=false Then
FORMULA = TRUE
Else

If COUNT ({Sales Single table body. Commodity code}) mod 5 > 1) Then
FORMULA = TRUE
Else
If COUNT ({sales list body. Commodity code}) MoD 5 = 0) Then
FORMULA = TRUE
Else
FORMULA = FALSE
End If
End If
End If

Section 2 to display the second blank section only if the number of records equals 1 or equal to 2 o'clock.
If Onlastrecord=false Then
FORMULA = TRUE
Else
If COUNT ({Sales Single table body. Commodity code}) mod 5 > 2) Then
FORMULA = TRUE
Else
If COUNT ({sales list body. Commodity code}) MoD 5 = 0) Then
FORMULA = TRUE
Else
FORMULA = FALSE
End If
End If
End If

The other two sections, and so on are very simple.
Note that the boundary condition is the processing of the case that returns 0 and the number of records itself is zero after the total modulo.







Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.