Home > DeveloperSection > Forums > How used the sum function in crystal reports
Kenny Tangnde

Total Post:68

Points:476
Posted on    September-09-2011 10:50 PM

 C# C# 
Ratings:


 12 Reply(s)
 11899  View(s)
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

thanks in advance.



Chris Anderson
Chris Anderson

Total Post:65

Points:455
Posted on    September-10-2011 12:39 AM

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

Kenny Tangnde

Total Post:68

Points:476
Posted on    September-10-2011 2:48 AM

hi Rohit Kesharwani

i want achieve used sum function  statistical all subtotal.


Chris Anderson
Chris Anderson

Total Post:65

Points:455
Posted on    September-10-2011 8:32 AM

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

Kenny Tangnde

Total Post:68

Points:476
Posted on    September-11-2011 3:38 AM

hi Rohit Kesharwani ,

      thanks for your answer.

other,can you  provide a vs2010 professional edition link address  give me.

thanks.

 

 


Kenny Tangnde

Total Post:68

Points:476
Posted on    September-11-2011 3:52 AM

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.


Chris Anderson
Chris Anderson

Total Post:65

Points:455
Posted on    September-12-2011 1:05 AM

hello aken,

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


Awadhendra Tiwari

Total Post:126

Points:882
Posted on    September-12-2011 5:34 AM

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.


Kenny Tangnde

Total Post:68

Points:476
Posted on    September-12-2011 9:52 AM

hi Rohit Kesharwani ,

you can provide link address?

thanks.


Kenny Tangnde

Total Post:68

Points:476
Posted on    September-13-2011 12:49 AM

 hi Rohit Kesharwani,

you used VS2010 is what edition, where are from download,can you provide download address.

thanks.


Alex R
Alex R

Total Post:40

Points:280
Posted on    September-13-2011 5:36 AM


mohan kumar

Total Post:10

Points:70
Posted on    October-20-2011 4:41 AM

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

Uttam Misra

Total Post:124

Points:888
Posted on    October-20-2011 6:39 AM


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

Don't want to miss updates? Please click the below button!

Follow MindStick