Skip to Content
0
Former Member
May 26, 2008 at 02:03 PM

Problem with the Sum() function in Crystal XI. Showing count of the values instead of sum when applied.

728 Views

We have migrated one application from .net framework 1.0 to framework 2 (from Visual studio 2003 to Visual STUDIO 2005). Now after migration we are facing some problem related to the sum function in Crystal report 10. It is not working properly. It is returning tootal count values .

So we migrated to Crystalreport XI release 2 (though still using evaluation version for testing purpose), the problem is not yet resolved.

The problem we are facing is 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".

In the 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).

I was browsing the net and saw running totals can be a work around ?

Can anyone help me and how to use the running total in solving the problem ?