Event Report.Custom Calc - pre-processing of the input data

2017-08-13

New CustomCalc event for the Report object is called when evaluating an expression in an object or when you receive data back from the data source. So we can use this event to intercept the data and spoofing. When this can be useful? For example, when you need to filter the values in the incoming data or to replace any row.

Let's look at an example. Сreate a simple WindowsForms application. Add the data source to the project, and the DataSet component. Also, place the component Report on the form.

In the drop-down menu of the Report component, select the item “Select Data Source”:

 

And choose our data source.

Now, select the item “Design Report” from the same menu. To demonstrate, I added a couple of fields from the Employee table:

 

For interest's see how the report looks now:

 

Save the report and close the Report Designer. Add a button to the form. And click event for it:

1
2
3
4
5
6
7
8
9
10
11
private void Run_Click(object sender, EventArgs e)
 
 {
 
 report1.Load("D://Reports//Simple.frx");
 
 report1.Prepare();
 
 report1.ShowPrepared();
 
 }

 Here, everything is banal. I have uploaded created earlier report. Then prepared it and showed.

And now, add the event CustomCalc for the report1 object:

 

1
2
3
4
5
6
7
8
9
10
11
12
13
 private void report1_CustomCalc(object sender, FastReport.CustomCalcEventArgs e)
 
 {
 
 if (e.CalculatedObject.Equals("Roberto") )
 
 {
 
 e.CalculatedObject = "Test Name";
 
 }
 
 }

 Here we intercept the needed data and replaces them. All data passes through CalculatedObject object during construction of the report. We catch the needed information "Roberto". And replace them.

You can replace the entire data field. In this case, the condition would look like this:

1
if (e.Expression.IndexOf("employee.FirstName") != -1)

 We wrote the code for the data substitution directly in the event handler CustomCalc. You can also assign the event handler directly in the code, for example in MVC application. With a convenient location in the application code we write:

1
report1.CustomCalc += FReport_CustomCalc;

  And the event handler:

1
2
3
4
5
6
7
8
9
10
11
12
13
private void FReport_CustomCalc(object sender, CustomCalcEventArgs e)
 
 {
 
 if (e.Expression.IndexOf("Employees.FirstName") != -1)
 
 { 
 
 e.CalculatedObject = "Test Name";
 
 }
 
 }

 Run the application. Click the button and see our report:

 

Let's compare this screenshot with one that was made earlier. As you can see, the first entry and the name of the employee Roberto put in a condition and has been replaced by Test Name.

Thus, we have a way to replace some of the data in the report. It probably will be used at sophisticated users of FastReport.

FastReport .NET
October 13, 2025

How to Use Excel Formulas in a Report When Exporting to MS Excel

Starting with version FastReport .NET 2026.1, it is now possible to export formulas to Microsoft Excel. It is important to set up formula exports correctly and follow the syntax.
September 30, 2025

How to Install the FastReport .NET Report Designer with Pre-installed Plugins

Read the article as from version 2025.2.5 for FastReport .NET WinForms and FastReport .NET WEB allows you to install a report designer with all plugins without building dll files.
September 23, 2025

How to Export a Report to JPEG / PNG / BMP / GIF / TIFF / EMF from FastReport .NET

In this article, we will look at how to easily and efficiently export reports from FastReport .NET in JPEG, PNG, BMP, GIF, TIFF and EMF.

© 1998-2025 Fast Reports Inc.