Output N-th number of records on the report page

2017-08-18

The function of limitation of the number of output records often causes some difficulties with FastReport.Net users despite the fact, that it is considered to be rather simple. This work seeks to bridge the knowledge gap in the way of displaying a certain number of records on a page with the help of a script report.

 It must be mentioned, that the following script is very simple and requires basic knowledge in programming only.

Let us take a close look at the demo report given bellow:

The following list will be formed with the help of the system variable [#Row].

Set “RowCoun value” 25 in the "data band" properties. Now, the list will consist of 25 lines.  

Build the report:

The example aims to output 5 lines on a page.

For the band "Data" create an event “BeforePrint”. 

Go to the editor of the report script:

Write the following code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
public class ReportScript
 {
int counter = 0;
 
 private void Data1_BeforePrint(object sender, EventArgs e)
 {
 if (counter >= 5)
 {
Engine.StartNewPage();
 counter = 0;
}
counter++;
 }
 }

 It should be mentioned, that the counter variable is declared globally. As it is seen, before every displaying of data the counter is checked. After reaching the number of 5 lines, the report engine starts a new page of the report and the counter is reset.

So, we need to have 5 pages with lists of 5 lines.

Since the page contains a list consisting of only 5 lines, it is needed to set the automatic page height:

 

“UnlimitedHeight” property will allow to reduce the height of the page in our case.

 Now, run the report:

 A report script is a flexible tool. By adding only 5 lines of a code, we have achieved the desired result.

.NET .NET FastReport FastReport
July 04, 2025

How to Transition from FastReport Publisher to the Corporate Server

In this material, we will discuss the reasons for replacing Publisher with the Corporate Server along with a migration plan.
June 27, 2025

Publisher — the Ideal Solution for Small and Medium-Sized Businesses

In this article, we will take a detailed look at how these services help address different user needs so that you can choose the solution that best fits your requirements.
June 05, 2025

FastReport License Agreement: Translation from Legalese into Human

A plain-language explanation of the key restrictions in the FastReport license agreement, along with an invitation to discuss custom usage and partnership opportunities.
Fast Reports
  • 800-985-8986 (English, US)
  • +31 97 01025-8466 (English, EU)
  • +49 30 56837-3928 (German, DE)
  • +55 19 98147-8148 (Portuguese, BR)
  • info@fast-report.com
  • 66 Canal Center Plaza, Ste 505, Alexandria, VA 22314

© 1998-2025 Fast Reports Inc.