# How used the sum function in crystal reports

Kenny Tangnde

Total Post:68

Points:476

Posted by  Kenny Tangnde
15006  View(s)
Ratings:
Rate this:

hi all,

i have a product table ,i already achieve subtotal function field ,but now i want achieve total a function.
my subtotal function is:{Product_Tb.Product Quantity} * {Product_Tb.Product Price}
then how  will  to total a function achieve,
i try below "total"function:
sum({Product_Tb.Product Quantity} * {Product_Tb.Product Price}
)
but crystal reports prompt  error:here need one the field

1. ##### Re: How used the sum function in crystal reports

hi,
Colud you please tell me on which basis you want to make total of subcategory.
Could you will explain me in more details.

1. ##### Re: How used the sum function in crystal reports

hi Rohit Kesharwani

i want achieve used sum function  statistical all subtotal.

1. ##### Re: How used the sum function in crystal reports

Hello aken..

You can achieve the total function by using Running Total Field:

For running total field see this link:

https://www.mindstick.com/Articles/614/running-total-field-in-crystal-report Total Field in Crystal Report

For the above problem:

Right click on running total field-->Select New-->Put the Formula(created qty * price) from the left pane to Field to summarize field and select sum from the Type of summary dropdownlist--click ok.

After this drag the running field and drop it into footer section of the report. Finally you can see a total in footer section.

Thanks.

Modified On Mar-18-2016 04:56:11 AM
1. ##### Re: How used the sum function in crystal reports

hi Rohit Kesharwani ,

thanks.

Modified On Mar-29-2018 04:36:54 AM
1. ##### Re: How used the sum function in crystal reports

hi Rohit Kesharwani ,

i looked your blog article,me to very appreciate you write article.
Unfortunately I can not use vs2010 some crystal reports functional.

Error:Failed to load properly "Microsoft.Data.Entity.Design.BootstrapPackage.BootstrapPackage,Microsoft.Data.Entity.Design.BootstrapPackage,Version=10.0.0.0,Culture=neutral,PublicKeyToken=b03f5f7f11d50a3a" package.

Modified On Mar-29-2018 04:37:13 AM
1. ##### Re: How used the sum function in crystal reports

hello aken,

i think you do not install a VS 2010 properly or not using a proper setup to install.

1. ##### Re: How used the sum function in crystal reports

Hi aken H

You need to check System.Data.Entity dll. You can try by replacing this dll via microsoft site.

Maybe ur application starts working.

Thanks.

1. ##### Re: How used the sum function in crystal reports

hi Rohit Kesharwani ,

thanks.

Modified On Mar-29-2018 04:37:25 AM
1. ##### Re: How used the sum function in crystal reports

hi Rohit Kesharwani,

thanks.

1. ##### Re: How used the sum function in crystal reports

Can anyone briefly explain how to use crystal reports formula section..I want to know the formula section of the Crystal reports from scratch..

1.   Modified On Mar-14-2016 08:22:15 AM