logo
small logo
  • Products
  • Buy
  • Support
  • Articles
  • Customer panel Support
    • en
    • pt
    • es
    • de
    • pl
    • JP
    • ZH
  • Home
  • /
  • Articles
  • /
  • How to display an estimated number of records on a report page
  • Report generators family FastReport brief review

    March 23, 2020

    Without reporting it is impossible to carry on business in any sphere of life. Bureaucracy

    read more
  • How to update the FastReport.Core web report

    September 21, 2020

    Sometimes you need to update the report, for example if you input a new variable

    read more
  • Reports and PDF documents in Blazor

    April 5, 2021

    Microsoft has recently launched a web platform called Blazor. This framework allows creating an interactive

    read more
  • How to install FastReport Business Graphics .NET

    August 18, 2021

    This article shows how to install FastReport Business Graphics .NET on your computer and how

    read more
  • Toilet paper printing

    March 30, 2020

    Gentlemen jokes aside! Today we are talking about toilet paper. This essential hygiene product was

    read more

How to display an estimated number of records on a report page

August 18, 2017

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.

about product download buy
avatar
Dmitriy Fedyashov
Technical Writer
Fast Reports Team: Dmitriy Fedyashov - Technical Writer at Fast Reports
.NET FastReport

Add comment
logo
  • 800-985-8986 (English, US)
  • +4930568373928 (German)
  • +55 19 98147-8148 (Portuguese)
  • info@fast-report.com
  • 901 N Pitt Str #325 Alexandria VA 22314
  • Buy
  • Download
  • Documentation
  • Testimonials
  • How to uninstall
  • Ticket system
  • FAQ
  • Tutorial Video
  • Forum
  • Articles
  • Our News
  • Press about us
  • Resellers
  • Extended licensing
  • Contact us

© 1998-2022 by Fast Reports Inc.

  • Privacy Policy