Summation of Sum Formula in Crystal Report

crystal-reports crystal-reports-2008 crystal-reports-xi crystal-reports-8.5
xorpower picture xorpower · Feb 2, 2011 · Viewed 10.2k times · Source

I did a summation in one formula say Formula1. Now i created Formula2 which would do summation of Formula1 as Sum({@Formula1}).

But the crystal report gives the error as "The Field could not be summarized". I understand that summation of sum cannot be done, but i need to do this as Formula1 does summation of columns i.e. brings up Total and Formula2 brings up grand Total.

Please Help!

thanks

Answer

PowerUser picture PowerUser · Feb 2, 2011

  1. Does your Formula1 always evaluate to a numeric value? For example, if you designed Formula1 to display "-" instead of "0", that would cause the problem for Formula2.

  2. If this is a simple summation, you don't even need a Formula2. Crystal has a built-in alternative. On Formula1, go to right-click->Insert->Summary and choose where you want it (Group Footer or Report Footer)

Related questions

How to create Table in Crystal Report

Create Table in Crystal Report I am newbie to Crystal Report, and i am using Crystal Report 2008. I want to know, do we have table object in Crystal Report.. so that i can draw a table with specific rows and …

Read More
How do I point Crystal Reports at a new database

I have a Crystal Reports 2008 user that has over 100 custom developed reports. The reports all query Sql Server databases (SQL 2005). This database server is getting replaced with a new system (running SQL 2008 R2) and the existing databases will be moved …

Read More
Crystal Reports Custom IsNull Function

I am trying to create a custom IsNull Function in Crystal Reports; the function must act the same way as the IsNull Function in MS SQL Server. I want to specify a field, and if the field is null, then …

Read More