Cannot implicitly add value to unidentified type.

Xavi

In a report, I have created a total as average of a numeric field.

If Convert Null option is checked, everything works fine. When I unchecked it (the option that I need to use), I get the following error:

FastReport.Net v1.3.14
Cannot implicitly add value to unidentified type.
at FastReport.Variant.op_Addition(Variant subjectVariant, Object value)


Do you know what it means?

Thank you

AlexTZ

One of data rows contains a null value which you are trying to sum. The "Convert null values" option is designed to handle this case correctly.

Xavi

But it is not consistent with the aggregate functions of any database, including Ansi/ISO standards.
"Sum" function must ignore nulls, precisely it is one of the good features of working with null values.
I do not use "Convert null values" in any report, never. null does not mean 0, it means "unknown". If I use "Convert null values", then other functions as Average will not work correctly.
I would suggest to improve the sum function, ignoring null values. It would not affect your current specifications and it will be more consistent with the industry standards.

Thank you

AlexTZ

I've added check for null & DBNull values. It will be available in the next daily build.