1. Home
  2. Forum
  3. Angular
  4. Metemathical equations in report
Starting in 2019, the Reporting control is no longer included in Essential Studio®. If you're experiencing issues with the Syncfusion� Reporting Platform, Report Viewer, Report Designer, or Report Writer, we recommend migrating to Bold Reports, our dedicated reporting platform.

Bold Reports offers a comprehensive suite of tools and features for all your reporting needs, and we will help you make a smooth transition from the discontinued control. Our support team at https://support.boldreports.com/ is here to assist you with any questions or difficulties you may encounter during the migration process.

We thank you for choosing Syncfusion� and appreciate your understanding.

Metemathical equations in report

Hello,
is there a possibility to do mathematical equations like add, substract, multiply and etc. in report?
I tried to add two numbers and to substract two numbers. While doing mathematical equations values are interpreted like string instead of numbers.
In visual studio report server it working correctly, but in ejReportViewer not.
Substract in ejReportViewer:

Add in ejReportViewer:

Add and substract result in visual studio report server (with same rdl file):


1 Reply
YD Yuvaraj Devarajan Syncfusion Team January 22, 2018 08:44 AM UTC

Hi AC, 

On further analysis of the shared screenshot, the mentioned problem occurs when you have used the textbox reportitem values for the arithmetic calculation.  Hence the values are consider as string, so we request you to convert the string value to long in-order to avoid the mentioned problem at your end as shown in below expression, 

Expression: 
=CLng(ReportItems!Textbox1.Value) + CLng(ReportItems!Textbox8.Value) 

=CLng(ReportItems!Textbox1.Value) - CLng(ReportItems!Textbox8.Value) 


Regards, 
Yuvaraj D. 


Loader.
Up arrow icon