There are two types of formulas that we can make use of: one is Reporting Services formulas and the other is MS Excel dynamic formula provided by Aspose.Cells for Reporting services. Using Reporting Services formulas in Aspose.Cells.Report.Designer is same as applying formulas in Visual Studio. Users can set Reporting Services formulas based on the values of Cells in report template, the formulas will be calculated and the calculation results will be filled back to Cells at rendering time.

Comparing it with Reporting Services formulas, MS Excel dynamic formula is not calculated but converted to a real MS Excel formula according to certain rules / regulations and then filled back to Cells at rendering time.

A Sample report containing formulas (calculated) is exported using Aspose.Cells for Reporting Services.