[Crystal Report] The recordnumber application controls the number of lines displayed on each page and the color of the line.

I am often asked how to limit the number of lines displayed on each page. I also see someone using the high field method.

The formula uses the crystal syntax, and the database uses the ACCESS database provided by the crystal report.
Take the orders table as an example.

Select several fields for a simple report, draw a small grid, and Preview It. The data in each row is displayed on a full page. There are 21 pages in total.

We limit 10 lines per page

In the design section, right-click and choose "expert" to operate on the "details" section. The following steps are shown in the figure. Add a formula control page.

When you preview the page, you will find 84 pages, as we want :)

Next we will doSimple line Color Display,
Press ctrl to select all fields in turn
Right click and select "format field", as shown in the following figure.

Edit Formula

After the formula is saved, you can preview it again.

Or is it relatively simple?