Problem in the SUM() function of Crystal report XI RELEASE 2 Evaluation version
We have migrated one application from .net 2000 to .net 2005. Now after migration we are facing some problem related to crystal report. The sum function is not working properly. After migration of crystal report 10 to crystal report XI release 2 (though still using evaluation version for testing purpose), the problem is not yet resolved. The problems are described briefly below:
While using the summary in the group field, it is showing the number of rows instead of the sum of the values.
We have checked the same with min-max functions, and it is working properly with those.
We checked the same with average function but in that case it is throwing an error at execution time saying, "The Report Application Server failed".
We have tried to make the sum by formula field. In such case, it is not showing any syntactical error but at execution time, it is throwing an error saying "A number field or currency amount field is required here". Here it is important to make a note that in the report the datatype of the field on which we are applying the sum function, is number, and in the table from where the data is fetched, the datatype is numeric(9,6).
Many thanks in advance for your kind support in this regards.