Re: Add two fields on the report
Posted: Tue Jan 17, 2017 12:08 pm
Last release php 2016.3
Reporting tool and data analytics tools for creating reports and dashboards in ASP.NET, ASP.NET MVC, .NET Core, Blazor, Angular, PHP, Python, WPF, JavaScript, and Java applications.
https://forum.stimulsoft.com/
miguelcaro wrote:Since the datasource that we connect to Firebird 2.5 returns all the fields in String format, when we design a databand with 2 fields, supposedly numeric, we can not perform calculations with them. Stimulsoft php forces us to edit in the datasource, the string fields to numerics (double).
Datasource1.Amount1 and Datasource1.Amount2 are StringField in the datasource. If you put a new text object and edit it with this expression. The report fails.
{ Datasource1.Amount1 + Datasource1.Amount2 }
But... if you edit this two fields to "double" in the Datasource , Report works fine.